Get a collection of items.

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.

• Id supports the '=' operators.
• BoardId supports the '=' operators.
• ColumnId supports the '=' operators.
• ColumnValue supports the '=, IN' operators.

SELECT

SELECT * FROM Items ORDER BY CreatedAt DESC
SELECT * FROM Items WHERE Id = 2181917692
SELECT * FROM Items WHERE BoardId = '2181917679' AND ColumnId = 'text' AND ColumnValue = 'test'
SELECT * FROM Items WHERE BoardId = '2181917679' AND ColumnId = 'text' AND ColumnValue IN ('Working on it','test')

Columns

Name	Type	References	Description
Id [KEY]	Long		The item's unique identifier.
BoardId	Long	Boards.Id	The unique identifier of the board.
CreatorId	String	Users.Id	The unique identifier of the item creator.
GroupId	String	Groups.Id	The group's unique identifier.
CreatedAt	Datetime		The item's create date.
Name	String		The item's name.
Email	String		The item's email.
State	String		The item's state (all / active / archived / deleted).
UpdatedAt	Datetime		The item's last update date.
AssetsIds	String		A comma separated list of the items' assets/files unique identifiers.
ColumnId	String	Columns.Id	The column's unique identifier.
ColumnValue	String		The column values to search items by. You can use text values for the search.
ColumnType	String		The column type.