BoardSubitems
An example subitems board.
Table Specific Information
The provider uses the Monday API to process some of the filters. The provider processes other filters client-side within the provider. 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.
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
INSERT statements are mapped to the 'create_subitem' GraphQL mutation.
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
UPDATE statements are mapped to the 'change_multiple_column_values' GraphQL mutation.
The following inputs can be used in UPDATE statements:
ItemId, 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
UPDATE BoardSubitems SET WorldClock='Europe/Amsterdam' WHERE ItemId='5573109452'
DELETE
DELETE statements are mapped to the 'delete_item' GraphQL mutation.
You can delete entries by specifying the ItemId.
Columns
Name | Type | ReadOnly | References | Description |
ItemId [KEY] | String | False |
The item's unique identifier. | |
ParentItemId | String | False |
The item's parent unique identifier. | |
CreatorId | String | False |
The item's creator unique identifier. | |
CreatedAt | Datetime | False |
The item's create date. | |
UpdatedAt | Datetime | False |
The item's last updated date. | |
State | String | False |
The item's state (all, active, archived, deleted). | |
RelativeLink | String | False |
The item's relative path. | |
ItemEmail | String | False |
The item's email. | |
AssetsIds | String | False |
A comma separated list of the items' assets/files unique identifiers. | |
GroupId | String | False |
The title of the group that contains this item. | |
GroupTitle | String | False |
The title of the group that contains this item. | |
Subitem | String | False |
The item's name. | |
OwnerText | String | False |
The column's textual value in string form. | |
OwnerValue | String | False |
The column's value in json format. | |
StatusIndex | Int | False |
The index of the status in the board. | |
StatusIsDone | Bool | False |
Whether the status is done. | |
StatusLabel | String | False |
The label of the status. | |
StatusUpdateId | String | False |
The ID of an update attached to the status. | |
StatusLabelStyleColor | String | False |
The style of the status label. The label's color in hex format. | |
StatusLabelStyleBorder | String | False |
The style of the status label. The label's border color in hex format. | |
DateIcon | String | False |
The string representation of selected icon. | |
Date | Date | False |
The column's date value. | |
Datetime | Datetime | False |
The column's datetime value. |
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 |
Create Status/Dropdown labels if they're missing. Requires permission to change board structure. |