BoardSubitems
Represents a subitems board, storing nested items related to a primary board's items for more detailed task tracking.
Table-Specific Information
The connector uses the Monday API to process some of the filters. The connector processes other filters client-side within the connector.
SELECT
Note: 'Subitems'-type tables support the same server-side filters and CUD operations as the main board.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 inputs 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, WorldClock
INSERT INTO BoardSubitems (ParentItemId, Subitem) VALUES ('5562458608','NewSubItem')
UPDATE
The following inputs 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, 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 a more granular control over the tuples that are 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. |