BoardSubitems
Represents a subitems board, storing nested items related to a primary board's items for more detailed task tracking.
Table-Specific Information
The 'Subitems'-type tables support the same server-side filters for SELECT queries and CUD operations as the main board, including bulk INSERT, UPDATE, and DELETE.SELECT
The following example retrieves each subitem's Id and name joined by its parent board item's Id and name:SELECT C.ItemId AS ChildId, C.Subitem AS ChildName, P.ItemId AS ParentId, P.Item AS ParentName FROM BoardSubitems C INNER JOIN Board P ON C.ParentItemId = P.ItemId
INSERT
The following columns can be used in INSERT statements:
ParentItemId, GroupId, ItemName, CreateLabelsIfMissing, BoardId, BoardRelationLinkedItemIds, Checkbox, CountryCode, CountryName, DateDate, DateDatetime, DependencyLinkedItemsIds, DropdownText, DropdownValue, Email, EmailLabel, Hour, LinkUrl, LinkUrlText, LocationLat, LocationLng, LocationAddress, LongText, Numbers, PeopleValue, PhoneCountryShortName, Phone, Rating, StatusIndex, StatusLabel, TagsIds, Text, TimelineFrom, TimelineTo, WeekStartDate, WeekEndDate, or WorldClock.
INSERT INTO BoardSubitems (ParentItemId, Subitem) VALUES ('5562458608', 'NewSubItem')
UPDATE
The following columns can be used in UPDATE statements:
CreateLabelsIfMissing, BoardId, BoardRelationLinkedItemIds, ItemName, Checkbox, CountryCode, CountryName, DateDate, DateDatetime, DependencyLinkedItemsIds, DropdownText, DropdownValue, Email, EmailLabel, Hour, LinkUrl, LinkUrlText, LocationLat, LocationLng, LocationAddress, LongText, Numbers, PeopleValue, PhoneCountryShortName, Phone, Rating, StatusIndex, StatusLabel, TagsIds, Text, TimelineFrom, TimelineTo, WeekStartDate, WeekEndDate, or WorldClock.
UPDATE BoardSubitems SET WorldClock = 'Europe/Amsterdam' WHERE ItemId = '5573109452'
DELETE
You can delete entries by specifying the ItemId.
DELETE FROM BoardSubItems WHERE ItemId = '5561890829'
Columns
| Name | Type | ReadOnly | References | Description |
| ItemId [KEY] | String | False |
The unique identifier for each item in the system, used for referencing and querying specific items. | |
| ParentItemId | String | False |
The unique identifier of the parent item, indicating the hierarchical relationship between items. | |
| CreatorId | String | False |
The unique identifier of the user who created the item, helpful for tracking ownership. | |
| CreatedAt | Datetime | False |
The timestamp representing when the item was created in the system. | |
| UpdatedAt | Datetime | False |
The timestamp representing the last time the item was updated, useful for tracking changes. | |
| State | String | False |
Represents the current status of the item, such as 'all', 'active', 'archived', or 'deleted'. | |
| RelativeLink | String | False |
The relative URL or path to the item, used for navigation or linking within the system. | |
| ItemEmail | String | False |
The email address associated with the item, if applicable, typically used for notifications or communications. | |
| Url | String | False |
The full URL link to the item, providing access to the item’s page or resource. | |
| AssetsIds | String | False |
A comma-separated list of unique identifiers for the assets or files associated with the item. | |
| GroupId | String | False |
The identifier of the group to which the item belongs, used to organize and categorize items. | |
| GroupTitle | String | False |
The title or name of the group that contains this item, providing context for grouping and organization. | |
| Subitem | String | False |
The name or description of the subitem, typically used in hierarchical or dependent structures. | |
| OwnerText | String | False |
The textual value of the column, providing a human-readable form of the data stored in that column. | |
| OwnerValue | String | False |
The value of the column represented in JSON format, capturing complex data in a structured format. | |
| StatusIndex | Int | False |
The index position of the current status in the board, helping to identify its order in a list of statuses. | |
| StatusIsDone | Bool | False |
Indicates whether the item is marked as 'done' in its current status, used for task tracking. | |
| StatusLabel | String | False |
The label or name assigned to the status, which is visible to users to indicate the item’s progress. | |
| StatusUpdateId | String | False |
The unique identifier for any updates linked to the item’s current status, useful for tracking changes. | |
| StatusLabelStyleColor | String | False |
The color style applied to the status label, represented as a hex value to visually indicate the status. | |
| StatusLabelStyleBorder | String | False |
The border color style applied to the status label, represented as a hex value, enhancing visual distinction. | |
| DateIcon | String | False |
The icon associated with the date field, represented as a string, used for visual reference or selection. | |
| Date | Date | False |
The date value stored in the column, used to track specific dates associated with the item. | |
| Datetime | Datetime | False |
The datetime value stored in the column, capturing both the date and time of an event or action. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| CreateLabelsIfMissing | Bool |
A pseudocolumn that triggers the creation of missing status or dropdown labels, requiring proper permissions to modify the board structure. |