ActivityLogs
Get a board's log events.
View-Specific Information
SELECT
The driver uses the Monday API to process some of the filters. The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data.
- BoardId supports the '=','IN' comparison operators.
- UserId supports the '=','IN' comparison operators.
- CreatedAt supports the '>','>=;to' comparison operators.
- ColumnId supports the '=','IN' comparison operators.
- GroupId supports the '=','IN' comparison operators.
- ItemId supports the '=','IN' comparison operators.
SELECT * FROM ActivityLogs WHERE BoardId IN ('2307103055', '2182296646')
SELECT * FROM ActivityLogs WHERE UserId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE ColumnId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE GroupId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE ItemId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE CreatedAt > '2022-02-17 05:12:04.419' AND CreatedAt < '2022-02-17 05:12:04.861'
SELECT * FROM ActivityLogs WHERE CreatedAt >= '2022-02-17 05:12:04.419' AND CreatedAt <= '2022-02-17 05:12:04.861'
Columns
Name | Type | References | Description |
Id [KEY] | String | The ID of the activity log event. | |
BoardId | String |
Boards.id | The unique identifier of the board. |
AccountId | String | The account ID that initiated the event. | |
UserId | String |
Users.Id | The user ID of the user who initiated the event. |
CreatedAt | Datetime | The time of the event. | |
Data | String | The item's column values in string form. | |
Entity | String | The entity of the event that was changed (pulse / board). | |
Event | String | The action that took place. | |
ColumnId | String | Column id to filter. | |
GroupId | String |
Groups.Id | Group id to filter. |
ItemId | String | Item id to filter. |