ODBC Driver for Trello

Build 20.0.7587

Actions

Lists different actions made on Organization/Board/Card determined by type.

Table Specific Information

Select

The driver will use the Trello API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver. For example, the following queries are processed server-side: Actions differ from each other from their type.

SELECT * FROM Actions WHERE Type='commentCard' AND CardId='56eae4d5eb3eb531f1ab43af'
We are retrieving all comment actions made on Card with CardId='56eae4d5eb3eb531f1ab43af'.
SELECT * FROM Actions WHERE Type='addMemberToBoard' AND BoardId='5835595ee004411c6abdbfbd'
We are retrieving all add member actions made on Board with BoardId='56eae4d5eb3eb531f1ab43af'.

For a full list of actions types, visit: https://developers.trello.com/reference#action-types

If BoardId and OrganizationId are not present in the connection properties or in query ( in the case of

SELECT * FROM Actions
, for example) all logged actions of the user will be returned,

otherwise if BoardId is specified,

SELECT * FROM Actions
will return all Actions of the board. Because a board can have many actions, the query may take a while to execute.

If OrganizationId is specified

SELECT * FROM Actions
will return all actions actions on the organization.

If both properties are present

SELECT * FROM Actions
will return all Actions of the board.

You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Columns

Name Type Description
ActionId [KEY] String The Id of the action
Type String The action type (possible values https://developers.trello.com/reference#action-types)
Date Datetime Date created
BoardID String The Id of the board which the action references.
ListName String The name of the list which the action references.
ListID String The Id of the list which the action references.
CardID String The Id of the card which the action references.
CardName String The name of the card which the action references.
CardShortLink String The link of the card which the action references.
MemberId String The Id of the member associated with the action.
MemberName String The name of the member associated with the action.
OldPosition String The old position of the card when you move it up or down inside a list.
ListAfterId String The old position of the card when you move it up or down inside a list.
ListBeforeId String The old position of the card when you move it up or down inside a list.
OrganizationID String

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587