BoardSubitems
An example subitems board.
Table-Specific Information
The 本製品 uses the Monday API to process some of the filters. The 本製品 processes other filters client-side within the 本製品. 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
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, 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.
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. | |
Url | String | False |
The item's link. | |
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
CreateLabelsIfMissing | Bool |
Create Status/Dropdown labels if they're missing. Requires permission to change board structure. |