JDBC Driver for Monday

Build 22.0.8462

ActivityLogs

The board log events.

Table Specific Information

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. 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462