How to get all items from a specific date

monday Apps & Developers
, ,
1

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’

3

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

5

Hello again @sommeralisson,

This is working well now :grin:

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