Skip to main content

I have the following structure:


query { 

    boards (ids: ["xxxxxxx", "xxxxxxx"]) {

    name 

    state

    board_folder_id

        items_page {

        items {

            name

            id 

            name

            column_values(ids: ["controle_de_tempo", "lista_suspensa31", "lista_suspensa3", "lista_suspensa2"]) {

                id 

                value 

                text 

                value type 

                ... on TimeTrackingValue { 

                    running

                    started_at

                    history { 

                        status 

                        ended_at 

                        started_at 

                        started_user_id 

                        manually_entered_end_date 

                    }

                }

            }

        }

    }

}

}

How can I specify a date and get all items from that date on? The date I want to use is the updates to the ‘controle_de_tempo’ column, for example: all items that have been updated since ‘2024-01-01’

Hello there @sommeralisson,


We seem to have an issue with that query. Our team is working on this as we speak and I will update you as soon as I have news!


Cheers,

Matias

Hello again @sommeralisson,


This is working well now 😁


You can use a query like this one to get the items that have a specific date to them:


query {

  boards(ids: 1234567890) {

    items_page(

      query_params: {rules: [ { 

        column_id: "date4", 

        compare_value: ["2024-01-01"], 

        operator: any_of}]}

    ) {

      items {

        id

        name

      }

    }

  }

}

Or you can use something like this to get the items after a specific date (that date included):


query {

  boards(ids: 1234567890) {

    items_page(

      query_params: {rules: [ { 

        column_id: "date4", 

        compare_value: ["2024-01-01", "2100-10-10"], 

        operator: between}]}

    ) {

      items {

        id

        name

      }

    }

  }

}

I hope that helps!


Cheers,

Matias

Hello @Matias.Monday can we do that in the column last_updated? I suppose i’m having a timezone issue passing only "TODAY "

Reply


Terms & ConditionsCookie settings