Last updated

The last updated column represents when an item was last updated. You can filter by and read the last updated column via the API, but you currently cannot update or clear it.

Filter by the last updated column

Using the items_page object, you can easily filter a board's items based on specific columns or column values.

The last updated column is unique in that you don't need to add the column to your board in order to filter by it. Instead, use "__last_updated__" as the column ID and define your rules as you would for any other column (see example here).

Regardless of whether the column is visible on the board, you can filter items by:

• Who last updated them
• When they were last updated

The table below outlines the supported operators, compare values, and compare attributes for the last updated column. Note: The not_any_of operator returns items that do not match the specified compare value(s).

Examples

The following example returns all items on the specified board that were last updated on today's date, even though there is no last updated column on the board.

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

The following example returns all items on the specified board that were last updated by user 123456.

query {
  boards (ids: 1234567890) {
    items_page (query_params: {rules: [{column_id: "last_updated", compare_value: ["person-123456"], operator:any_of}]}) {
      items {
        id
        name
      }
    }
  }
}

Read the last updated column

You can query the last updated column using the column_values object that enables you to return column-specific subfields by sending a fragment in your query. Values for the last updated column are of the LastUpdatedValue type.

query {
  items (ids:[1234567890, 9876543210]) {
    column_values {
      ... on LastUpdatedValue {
        updated_at
        value
      }
    }
  }
}

Fields

📘

Join our developer community!

We've created a community specifically for our devs where you can search through previous topics to find solutions, ask new questions, hear about new features and updates, and learn tips and tricks from other devs. Come join in on the fun! 😎