The creation log column represents an item's creator and the date and time they created it. The API allows you to read and filter the creation log column, but you currently can't update or clear it.

Read a creation log column

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

query {
  items(
    ids: [
      1234567890
      9876543210
    ]
	) {
    column_values {
      ... on CreationLogValue {
        created_at
        creator
      }
    }
  }
}

import { ApiClient } from "@mondaydotcomorg/api";
const mondayApiClient = new ApiClient({ token: myToken });

const query = `query($itemIds: [ID!]) { items (ids:$itemIds) { column_values { value ... on CreationLogValue { created_at creator { email } } } } }`;
const variables = {
  itemIds: [9571351485, 9572374902],
};

const response = await mondayApiClient.request(query, variables);

Fields

Field	Description
column `Column!`	The column the value belongs to.
created_at `Date!`	The item's creation date.
creator `User!`	The item's creator.
creator_id `ID!`	The unique identifier of the item's creator.
id `ID!`	The column's unique identifier.
text `String`	The column's value as text.
type `ColumnType!`	The column's type.
value `JSON`	The column's JSON-formatted raw value.

Filter a creation log column

Using the items_page object, you can easily filter a board's items by specific columns or column values. The table below contains the creation log column's supported operators, compare values, and compare attributes.

Operators	Compare values	Compare attributes
`any_of`	The user IDs to filter by	`"CREATED_BY"`
`not_any_of`	The user IDs to filter by	`"CREATED_BY"`

Examples

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

query {
  boards(ids: 1234567890) {
    items_page(
      query_params: {
        rules: [
          {
            column_id: "creation_log"
            compare_value: [123456]
            compare_attribute: "CREATED_BY"
            operator: any_of
          }
        ]
      }
    ) {
      items {
        id
        name
      }
    }
  }
}

import { ApiClient } from "@mondaydotcomorg/api";
const mondayApiClient = new ApiClient({ token: myToken });

const query = `query ($board_id: [ID!], $column_id: ID!, $operator: ItemsQueryRuleOperator!, $compare_value:CompareValue!, $compare_attribute: String!) { boards (ids: $board_id) { items_page (query_params: {rules: [{column_id: $column_id, compare_value: $compare_value, compare_attribute: $compare_attribute, operator:$operator}]}) { items { id name } } } }`;
const variables = {
  board_id: 9571351437,
  column_id: "country",
  compare_value: [123456], // country code
  compare_attribute: "CREATED_BY", // country code
  operator: "any_of",
};

const response = await mondayApiClient.request(query, variables);