The creation log column represents an item's creator and the date it was created.

Via the API, the creation log column supports read and filter operations. You can't update or clear it programmatically.

Column Type	Implementation Type	Supported Operations
`creation_log`	`CreationLogValue`	Read: Yes Filter: Yes Update: No Clear: No

Queries

Creation log columns can be queried through the column_values field on items queries using an inline fragment on CreationLogValue.

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

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

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

const variables = { itemIds: [9571351485, 9572374902] };
const response = await mondayApiClient.request(query, variables);

Fields

You can use the following fields to specify what information your CreationLogValue implementation will return.

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 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 raw JSON-formatted column value.

Filter

You can filter items by creation log values using the items_page object. The creation log column supports the following operators:

Operators	Compare Values	Compare Attributes
`any_of`	User IDs to include	`"CREATED_BY"`
`not_any_of`	User IDs to exclude	`"CREATED_BY"`

Example

The following query returns all items 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 ($boardId: [ID!], $columnId: ID!, $operator: ItemsQueryRuleOperator!, $compareValue: CompareValue!, $compareAttribute: String!) {
    boards(ids: $boardId) {
      items_page(
        query_params: {
          rules: [
            {
              column_id: $columnId,
              compare_value: $compareValue,
              compare_attribute: $compareAttribute,
              operator: $operator
            }
          ]
        }
      ) {
        items {
          id
          name
        }
      }
    }
  }
`;

const variables = {
  boardId: 9571351437,
  columnId: "creation_log",
  compareValue: [123456],        // user ID
  compareAttribute: "CREATED_BY",
  operator: "any_of",
};

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