The board log events.

Table Specific Information

The adapter uses the API to process some of the filters. The adapter processes other filters client-side within the adapter. 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. For example, the following queries are processed server side.

• BoardId supports the '=, IN' operators.
• UserId supports the '=, IN' operators.
• ColumnId supports the '=, IN' operators.
• GroupId supports the '=, IN' operators.
• ItemId supports the '=, IN' operators.
• CreatedAt supports the '=, >, >=, <, <=' operators.

SELECT

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	Long	Boards.id	The unique identifier of the board.
AccountId	String		The account ID that initiated the event.
UserId	Int	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		Group id to filter.
ItemId	Long		Item id to filter.