Fetch list of items updated after a specific date

Hey @kranthi_thoughtflow,

Any chance you could filter the last updated column using one of the predefined compare values? It wouldn’t do exactly what you’re looking for though, so this could also be a great feature request 🙂

Best,
Rachel

Thank you @rachelatmonday . A few questions based on this documentation

• There is an option to query based on PAST_DATETIME. Would this solve my problem? Also, what is the format of date time that this query expects?
  

  

• I was also looking at this api Items page by column value

This seems to have a provision of taking board_id as input. But from the documentation, it is not clear if it can accept multiple board ids. Can you please confirm if this accepts multiple board ids?

Thank you.

Hey @kranthi_thoughtflow,

That wouldn’t be of much help. The “PAST_DATETIME” is actually a specific compare value that you pass in a query. It doesn’t accept specific timestamps and only returns items updated in the past (which is all of them).

query {
  boards(ids: 1234567890) {
    items_page (query_params: {rules: [{column_id: "__last_updated__", compare_value: ["PAST_DATETIME"], operator:any_of, compare_attribute:"UPDATED_AT"}]}) {
      items {
        id
        name
      }
    }
  }
}

Could you use another compare value, like “TODAY” or “LAST_WEEK”?

Regarding items_page_by_column_values, it is not an array/only takes one ID!

Best,
Rachel

Thank you @rachelatmonday