Board
Represents a workspace board containing items, columns, and other related data used for task management.
Table-Specific Information
Note: This is an example board. Column names are retrieved dynamically from the API and may differ from the examples provided.SELECT
The connector uses the Monday API to process some of the filters. The connector processes other filters client-side within the connector.Note that multiple filters are supported server-side (when they are all connected solely by AND logical operators or solely by OR logical operators).
- ItemId supports the '=', 'IN', operators.
- Item supports the '=', 'IN', '!=', 'NOT IN', 'CONTAINS' operators.
- Text supports the '=', 'IN', '!=', 'NOT IN', 'CONTAINS' operators.
- Check supports the '=', '!=', 'IS TRUE', 'IS FALSE', 'IS NOT TRUE', 'IS NOT FALSE' operators.
- BoardRelationDisplayValue supports the '=', '!=' operators when comparing with an empty string.
- BoardRelationLinkedItemIds supports the '=', '!=' operators when comparing with an empty string.
- TagsText supports the '=', '!=' operators when comparing with an empty string.
- TagsIds supports the '=', '!=' operators when comparing with an empty string.
- CountryCode supports the '=', 'IN', '!=', 'NOT IN', 'IS NULL', 'IS NOT NULL' operators.
- CountryName supports the '=', 'CONTAINS', 'IS NULL', 'IS NOT NULL' operators.
- DependentOnDisplayValue supports the '=', '!=' operators when comparing with a string containing only one pair of square brackets '[]'.
- DependentOnLinkedItemsIds supports the '=', '!=' operators when comparing with an empty string.
- EmailLabel supports the '=', 'IN', '!=', 'NOT IN', 'CONTAINS', 'IS NULL', 'IS NOT NULL' operators.
- Hour supports the '=', 'IN', '!=', 'NOT IN' operators for time values between 04:00 inclusive and 23:59 inclusive, and the 'IS NULL', 'IS NOT NULL' operators.
- Date supports the '=', 'IN', '!=', 'NOT IN', '>', '>=', '<', '<=', 'IS NULL', 'IS NOT NULL' operators.
- Datetime supports the 'IS NULL', 'IS NOT NULL' operators.
- TimelineFrom supports the 'IS NULL', 'IS NOT NULL' operators.
- TimelineTo supports the 'IS NULL', 'IS NOT NULL' operators.
- WeekStartDate supports the 'IS NULL', 'IS NOT NULL' operators.
- WeekEndDate supports the 'IS NULL', 'IS NOT NULL' operators.
- LinkUrlText supports the '=', 'IN', '!=', 'NOT IN', 'CONTAINS', 'IS NULL', 'IS NOT NULL' operators.
- Numbers supports the '=', '!=', 'IN', 'NOT IN', '>', '>=', '<', '<=', 'IS NULL', 'IS NOT NULL' operators.
- PeopleText supports the '=', '!=' operators when comparing with an empty string.
- PeopleValue supports the 'IS NULL', 'IS NOT NULL' operators.
- DropdownText supports the '=', '!=' operators when comparing with an empty string.
- DropdownValue supports the 'IS NULL', 'IS NOT NULL' operators.
- PhoneCountryShortName supports the '=', 'IN', '!=', 'NOT IN', 'IS NULL', 'IS NOT NULL' operators.
- Phone supports the '=', 'CONTAINS', 'IS NULL', 'IS NOT NULL' operators.
- Rating supports the '=', 'IN', '!=', 'NOT IN', 'IS NULL', 'IS NOT NULL' operators.
- StatusIndex supports the '=', 'IN', '!=', 'NOT IN', 'IS NULL', 'IS NOT NULL' operators.
- StatusLabel supports the '=', 'IN', '!=', 'NOT IN', 'IS NULL', 'IS NOT NULL' operators.
- LastUpdated supports the '=', 'IN', '!=', 'NOT IN' operators.
- TimeTrackingRunning supports the '=', '!=', 'IS TRUE', 'IS FALSE', 'IS NOT TRUE', 'IS NOT FALSE' operators.
- VoteVoterIds supports the '=', '!=' operators when comparing with an empty string.
The following columns are sorted server-side when including an ORDER BY clause:
- CreatedAt supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
- UpdatedAt supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
- Item supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
- BoardRelationDisplayValue supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
- Check supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
- ColorPickerColor supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
- CountryName supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
- DependentOnDisplayValue supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
- EmailLabel supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
- Numbers supports 'ASC NULLS LAST', 'DESC NULLS FIRST'.
- LinkUrlText supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
- Phone supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
- Rating supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
- TimeTrackingDuration supports 'ASC NULLS FIRST', 'DESC NULLS LAST'.
The following queries are processed server side:
SELECT * FROM Board
SELECT * FROM Board WHERE ItemId = '5465844671'
SELECT * FROM Board WHERE ItemId IN ('5465844671','5465844679')
SELECT * FROM Board WHERE Item = 'Item 2'
SELECT * FROM Board WHERE Item != 'Item 2'
SELECT * FROM Board WHERE Item NOT IN ('Item 1','Item 2')
SELECT * FROM Board WHERE Item Contains 'Item'
SELECT * FROM Board WHERE CONTAINS (Item,'Item')
SELECT * FROM Board WHERE NOT CONTAINS (Item,'Item')
SELECT * FROM Board WHERE Check = True
SELECT * FROM Board WHERE Check != True
SELECT * FROM Board WHERE Check IS TRUE
SELECT * FROM Board WHERE Check IS NOT TRUE
SELECT * FROM Board WHERE Check = False
SELECT * FROM Board WHERE Check != False
SELECT * FROM Board WHERE Check IS FALSE
SELECT * FROM Board WHERE Check IS NOT FALSE
SELECT * FROM Board WHERE BoardRelationLinkedItemIds = ''
SELECT * FROM Board WHERE BoardRelationLinkedItemIds != ''
SELECT * FROM Board WHERE BoardRelationDisplayValue = ''
SELECT * FROM Board WHERE BoardRelationDisplayValue != ''
SELECT * FROM Board WHERE CountryCode = 'US'
SELECT * FROM Board WHERE CountryCode != 'US'
SELECT * FROM Board WHERE CountryCode IN ('US','UK')
SELECT * FROM Board WHERE CountryCode NOT IN ('US','UK')
SELECT * FROM Board WHERE CountryCode IS NULL
SELECT * FROM Board WHERE CountryCode IS NOT NULL
SELECT * FROM Board WHERE DependentOnDisplayValue = '[]'
SELECT * FROM Board WHERE DependentOnDisplayValue != '[]'
SELECT * FROM Board WHERE Hour='07:32:00'
SELECT * FROM Board WHERE Numbers IN (12, 55)
SELECT * FROM Board WHERE Numbers = 10
SELECT * FROM Board WHERE Numbers != 10
SELECT * FROM Board WHERE Numbers > 10
SELECT * FROM Board WHERE Numbers >= 10
SELECT * FROM Board WHERE Numbers < 10
SELECT * FROM Board WHERE Numbers <= 10
SELECT * FROM Board WHERE Text = 'test' AND Numbers = 10
SELECT * FROM Board WHERE Text = 'test' OR Numbers = 10
SELECT * FROM Board ORDER BY Item
SELECT * FROM Board ORDER BY CreatedAt
SELECT * FROM Board ORDER BY UpdatedAt
SELECT * FROM Board ORDER BY Numbers ASC NULLS LAST
INSERT
The following inputs can be used in INSERT statements:
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 Board (Item,GroupId,Check) VALUES ('Test','topics',true)
INSERT INTO Board (Item,GroupId,CountryCode,CountryName) VALUES ('Test','topics','US','United States')
INSERT INTO Board (Item,GroupId,Date) VALUES ('Test','topics','2023-11-16')
INSERT INTO Board (Item,GroupId,Datetime) VALUES ('Test','topics','2023-11-16 09:00:00.0-05:00')
INSERT INTO Board (Item,GroupId,DependentLinkedItemsIds) VALUES ('Test','topics','[5561036960, 5561037791]')
INSERT INTO Board (Item,GroupId,DropdownText) VALUES ('Test','topics','label1,label2')
INSERT INTO Board (Item,GroupId,DropdownText,CreateLabelsIfMissing) VALUES ('Test','topics','label3,label4','true')
INSERT INTO Board (Item,GroupId,DropdownValue) VALUES ('Test','topics','{"ids":[1,2]}')
INSERT INTO Board (Item,GroupId,Email,EmailLabel) VALUES ('Test','topics','[email protected]','Mail')
INSERT INTO Board (Item,GroupId,Hour) VALUES ('Test','topics','09:00:00')
INSERT INTO Board (Item,GroupId,LinkUrl,LinkUrlText) VALUES ('Test','topics','https://www.test.com/', 'TestLink')
INSERT INTO Board (Item,GroupId,LocationLat,LocationLng,LocationAddress) VALUES ('Test','topics',29.9772962,31.1324955,'Giza Pyramid Complex')
INSERT INTO Board (Item,GroupId,LongText) VALUES ('Test','topics','TestText')
INSERT INTO Board (Item,GroupId,Numbers) VALUES ('Test','topics','-10')
INSERT INTO Board (Item,GroupId,PeopleValue) VALUES ('Test','topics','{"personsAndTeams":[{"id":51688059,"kind":"person"},{"id":51085546,"kind":"person"}]}')
INSERT INTO Board (Item,GroupId,PhoneCountryShortName,Phone) VALUES ('Test','topics','US','12345678900')
INSERT INTO Board (Item,GroupId,Rating) VALUES ('Test','topics','5')
INSERT INTO Board (Item,GroupId,StatusIndex) VALUES ('Test','topics','2')
INSERT INTO Board (Item,GroupId,StatusIndex,StatusLabel,CreateLabelsIfMissing) VALUES ('Test','topics','15','NewLabel','true')
INSERT INTO Board (Item,GroupId,StatusLabel) VALUES ('Test','topics','Working on it')
INSERT INTO Board (Item,GroupId,TagsIds) VALUES ('Test','topics','[20826704,20826705]')
INSERT INTO Board (Item,GroupId,BoardLinkedItemIds) VALUES ('Test','topics','[5561037791,5561036960]')
INSERT INTO Board (Item,GroupId,Text) VALUES ('Test','topics','TestText')
INSERT INTO Board (Item,GroupId,TimelineFrom,TimelineTo) VALUES ('Test','topics','2023-11-01','2023-12-04')
INSERT INTO Board (Item,GroupId,WeekStartDate,WeekEndDate) VALUES ('Test','topics','2023-11-05','2023-11-11')
INSERT INTO Board (Item,GroupId,World_Clock) VALUES ('Test','topics','Africa/Algiers')
INSERT INTO Board (Item, RelativeTo, PositionRelativeMethod) VALUES ('new', '7161109809', 'before_at')
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, GroupId, State
Note that GroupId, State and column values cannot be updated in the same statement.
Also note that certain types require specifying all related columns to update the object's value (this includes Email, Link, Location, Phone, Timeline, and Week).
UPDATE Board SET GroupId = 'new_group' WHERE ItemId = '5562458608'
UPDATE Board SET State = 'archived' WHERE ItemId = '5562458608'
UPDATE Board SET ItemName = 'Test' WHERE ItemId = '5561890829'
UPDATE Board SET Check = false WHERE ItemId = '5561890829'
UPDATE Board SET CountryCode = 'US', CountryName = 'United States' WHERE ItemId = '5561890829'
UPDATE Board SET CountryCode = NULL, CountryName = NULL WHERE ItemId = '5561890829'
UPDATE Board SET Date = '2023-11-25' WHERE ItemId = '5561890829'
UPDATE Board SET Date = NULL WHERE ItemId = '5561890829'
UPDATE Board SET Datetime = '2023-11-23 04:00:00.0' WHERE ItemId = '5561890829'
UPDATE Board SET DependentLinkedItemsIds = '[5562459384, 5562458774]' WHERE ItemId = '5561890829'
UPDATE Board SET DependentLinkedItemsIds = NULL WHERE ItemId = '5561890829'
UPDATE Board SET DropdownText = 'Label1,Label2' WHERE ItemId = '5561890829'
UPDATE Board SET DropdownText = 'Label6,Label7',CreateLabelsIfMissing = 'true' WHERE ItemId = '5561890829'
UPDATE Board SET DropdownValue = '{"ids":[2,3]}' WHERE ItemId = '5561890829'
UPDATE Board SET DropdownValue = NULL WHERE ItemId = '5561890829'
UPDATE Board SET Email = '[email protected]',EmailLabel = 'NewMail' WHERE ItemId = '5561890829'
UPDATE Board SET Email = NULL, EmailLabel = NULL WHERE ItemId = '5561890829'
UPDATE Board SET Hour = '21:00:00' WHERE ItemId = '5561890829'
UPDATE Board SET Hour = NULL WHERE ItemId = '5561890829'
UPDATE Board SET LinkUrl = 'https://www.test.com', LinkUrlText = 'TestText' WHERE ItemId = '5561890829'
UPDATE Board SET LinkUrl = NULL, LinkUrlText = NULL WHERE ItemId = '5561890829'
UPDATE Board SET LocationAddress = NULL, LocationLat = NULL, LocationLng = NULL WHERE ItemId = '5561890829'
UPDATE Board SET LocationLat = '82', LocationLng = '135', LocationAddress = 'TestLocation' WHERE ItemId = '5561890829'
UPDATE Board SET LongText = 'changed text' WHERE ItemId = '5561890829'
UPDATE Board SET LongText = NULL WHERE ItemId = '5561890829'
UPDATE Board SET Numbers = 10 WHERE ItemId = '5561890829'
UPDATE Board SET Numbers = NULL WHERE ItemId = '5561890829'
UPDATE Board SET PeopleValue = '{"personsAndTeams":[{"id":51085546,"kind":"person"},{"id":961021,"kind":"team"}]}' WHERE ItemId = '5561890829'
UPDATE Board SET PeopleValue = NULL WHERE ItemId = '5561890829'
UPDATE Board SET Phone = NULL, PhoneCountryShortName = NULL WHERE ItemId = '5561890829'
UPDATE Board SET PhoneCountryShortName = 'US', Phone = '16102347959' WHERE ItemId = '5561890829'
UPDATE Board SET Rating = '1' WHERE ItemId = '5561890829'
UPDATE Board SET Rating = NULL WHERE ItemId = '5561890829'
UPDATE Board SET StatusIndex = '2' WHERE ItemId = '5561890829'
UPDATE Board SET StatusIndex = NULL WHERE ItemId = '5561890829'
UPDATE Board SET StatusLabel = 'NewLabel', StatusIndex = '159', CreateLabelsIfMissing = 'true' WHERE ItemId = '5561890829'
UPDATE Board SET StatusLabel = 'Working on it' WHERE ItemId = '5561890829'
UPDATE Board SET TagsIds = '[20826705,20833783]' WHERE ItemId = '5561890829'
UPDATE Board SET TagsIds = NULL WHERE ItemId = '5561890829'
UPDATE Board SET BoardLinkedItemIds = NULL WHERE ItemId = '5561890829'
UPDATE Board SET BoardLinkedItemIds = '[5562459384, 5561890829, 5562458774]' WHERE ItemId = '5561890829'
UPDATE Board SET Text = 'changedText' WHERE ItemId = '5561890829'
UPDATE Board SET Text = NULL WHERE ItemId = '5561890829'
UPDATE Board SET TimelineFrom = '2023-01-01', TimelineTo = '2023-10-10' WHERE ItemId = '5561890829'
UPDATE Board SET TimelineFrom = NULL, TimelineTo = NULL WHERE ItemId = '5561890829'
UPDATE Board SET WeekStartDate = '2023-11-13', WeekEndDate = '2023-11-19' WHERE ItemId = '5561890829'
UPDATE Board SET WeekStartDate = NULL, WeekEndDate = NULL WHERE ItemId = '5561890829'
UPDATE Board SET WorldClock = 'America/New York' WHERE ItemId = '5561890829'
UPDATE Board SET WorldClock = NULL WHERE ItemId = '5561890829'
DELETE
You can delete items by specifying the ItemId.
DELETE FROM Board WHERE ItemId = '5561890829'
Columns
| Name | Type | ReadOnly | References | Description |
| ItemId [KEY] | String | False |
The unique identifier for each item in the system, used to reference and distinguish items across the database. | |
| CreatorId | String | False |
The unique identifier of the user who created the item, allowing tracking of item origin. | |
| CreatedAt | Datetime | False |
The date and time when the item was created in the system, useful for audit and tracking item age. | |
| UpdatedAt | Datetime | False |
The date and time of the most recent update made to the item, enabling tracking of changes over time. | |
| State | String | False |
The current state of the item, indicating whether it is active, archived, deleted, or in any other defined state. | |
| RelativeLink | String | False |
The relative URL path pointing to the item's location within the system or application. | |
| ItemEmail | String | False |
The email address associated with the item, typically used for notifications or communication. | |
| Url | String | False |
The full URL link pointing to the item or related resource, allowing direct access to the item online. | |
| AssetsIds | String | False |
A comma-separated list of unique identifiers for the assets or files associated with the item, facilitating easy referencing. | |
| GroupId | String | False |
The identifier of the group to which this item belongs, used to categorize and manage items in groups. | |
| GroupTitle | String | False |
The title or name of the group containing the item, offering contextual categorization. | |
| Item | String | False |
The name of the item, typically used as a label or title within the system. | |
| BoardRelationDisplayValue | String | False |
A string representing the names of linked items, separated by commas, to visualize their relationship. | |
| BoardRelationLinkedItemIds | String | False |
A comma-separated list of item IDs that are linked to the current item, allowing for reference to related data. | |
| ButtonLabel | String | False |
The label or text displayed on the button associated with the item, providing a user-friendly description of the button's function. | |
| ButtonColor | String | False |
The color of the button in hexadecimal format, used to define the button's visual style. | |
| ButtonValue | String | False |
The value associated with the button, typically represented in JSON format for structured data processing. | |
| Check | Bool | False |
The boolean value indicating whether a condition is true (checked) or false (unchecked), commonly used in forms. | |
| ColorPickerColor | String | False |
The selected color in hexadecimal format, used to specify color preferences in the item. | |
| ColorPickerValue | String | False |
The color value in JSON format, representing the full color configuration for the item. | |
| CountryCode | String | False |
The two-letter ISO code representing the country of the item or associated data. | |
| CountryName | String | False |
The full name of the country associated with the item, providing clarity for localization. | |
| DateIcon | String | False |
A string representing the icon selected for the date, used for visual representation of date fields. | |
| Date | Date | False |
The date value for the item, typically used to represent important events or milestones. | |
| Datetime | Datetime | False |
The datetime value associated with the item, used for tracking both date and time of events. | |
| DependencyDisplayValue | String | False |
A string listing the names of items upon which this task depends, enabling visual representation of task dependencies. | |
| DependencyLinkedItemsIds | String | False |
A list of item IDs representing the tasks or items that this task depends on, ensuring task scheduling accuracy. | |
| DocFileId | String | False |
The unique identifier for the document file associated with the item, used for managing document-related data. | |
| DocFileCreatorId | String | False |
The ID of the user who created the document file, useful for tracking document ownership and history. | |
| DocFileObjectId | String | False |
The identifier of the object or board related to the document file, linking the file to its contextual data. | |
| DocFileUrl | String | False |
The URL where the document file can be accessed or downloaded, providing direct access to the document. | |
| DocFileDocId | String | False |
The unique document identifier associated with the file, used for cross-referencing within document management systems. | |
| DropdownText | String | False |
The text value selected from a dropdown list, representing the user's choice in a user-friendly format. | |
| DropdownValue | String | False |
The value associated with the dropdown selection, represented in JSON format for structured data. | |
| String | False |
The email address associated with the column, typically used for notifications or communications related to the item. | ||
| EmailLabel | String | False |
The label or description of the email field, which may be the same as the email address if no label was entered. | |
| FileText | String | False |
The text value of the file column, used for storing textual content related to the file. | |
| FileValue | String | False |
The value of the file column in JSON format, allowing structured representation of file data. | |
| Hour | Time | False |
The time value associated with the item, representing a specific hour or time in a day. | |
| IntegrationIssueId | String | False |
The unique identifier for the integration issue, used for tracking issues in third-party integrations. | |
| IntegrationEntityId | String | False |
The unique identifier for the entity involved in the integration, allowing for efficient tracking and management. | |
| IntegrationIssueApiUrl | String | False |
The API URL where details about the integration issue can be accessed, facilitating debugging and resolution. | |
| IntegrationValue | String | False |
The value in JSON format representing the data or configuration related to the integration issue. | |
| LastUpdated | String | False |
The identifier of the user who last updated the item, allowing for tracking of who made the most recent changes. | |
| LinkUrl | String | False |
The URL link associated with the item, used to direct users to external resources or related items. | |
| LinkUrlText | String | False |
The display text for the link, providing context or description for users about the link's destination. | |
| LocationLat | Double | False |
The latitude coordinate of the item's location, used for mapping and geospatial purposes. | |
| LocationLng | Double | False |
The longitude coordinate of the item's location, used in conjunction with latitude for accurate geolocation. | |
| LocationPlaceId | String | False |
The place ID associated with the item's location, used for precise location identification in mapping systems. | |
| LocationAddress | String | False |
The full address of the item's location, providing complete details for geolocation purposes. | |
| LocationCity | String | False |
The city in which the item is located, used to specify its geographic location. | |
| LocationCityShort | String | False |
A shorthand version of the city's name, typically used for space-saving purposes. | |
| LocationCountry | String | False |
The country where the item is located, providing regional context for the item. | |
| LocationCountryShort | String | False |
A shortened version of the country's name, typically using its two-letter ISO code. | |
| LocationStreet | String | False |
The street address of the item's location, giving a precise physical location. | |
| LocationStreetNumber | String | False |
The street number of the building, giving additional detail to the street address. | |
| LocationStreetNumberShort | String | False |
A shorthand version of the building number, typically used in forms with limited space. | |
| LocationStreetShort | String | False |
A shortened version of the street name, used when space is limited or for abbreviated addresses. | |
| LongText | String | False |
A field for storing longer text, typically used for descriptions, notes, or additional information. | |
| MirrorDisplayValue | String | False |
The display value for items mirrored from other sources, typically representing the original data. | |
| MirroredItems | String | False |
A list of items that are mirrored, representing items whose data is replicated across different locations. | |
| Numbers | Double | False |
A numeric value representing any relevant quantity or measurement associated with the item. | |
| PeopleText | String | False |
The text value for the people column, used for storing names or descriptions of people related to the item. | |
| PeopleValue | String | False |
The value of the people column in JSON format, representing structured data about people. | |
| PhoneCountryShortName | String | False |
The ISO-2 country code representing the country of the phone number. | |
| Phone | String | False |
The phone number associated with the item, used for contact purposes. | |
| Rating | Int | False |
An integer representing the rating assigned to the item, typically used in review or feedback systems. | |
| StatusIndex | Int | False |
The index number of the status in the board, allowing for sorting and managing item statuses. | |
| StatusIsDone | Bool | False |
A boolean indicating whether the status of the item is marked as complete or not. | |
| StatusLabel | String | False |
The label or name of the status, providing a user-friendly identifier for the item's state. | |
| StatusUpdateId | String | False |
The unique identifier for the status update, allowing for tracking of changes to the item's status. | |
| StatusLabelStyleColor | String | False |
The hexadecimal color value representing the style of the status label, used to define the label's visual color. | |
| StatusLabelStyleBorder | String | False |
The hexadecimal color value representing the style of the status label's border, used for visual distinction. | |
| TagsText | String | False |
The textual representation of the tags associated with the item, providing an easy-to-read list of tags. | |
| TagsIds | String | False |
A list of tag IDs associated with the item, allowing for filtering and categorization based on tags. | |
| Text | String | False |
The text value of the item, typically used for storing descriptions, titles, or other relevant textual data. | |
| TimeTrackingRunning | Bool | False |
A boolean value indicating whether the time tracker associated with the item is currently running. | |
| TimeTrackingStartedAt | Datetime | False |
The timestamp of when the time tracking was started, providing a reference for when the activity began. | |
| TimeTrackingDuration | Int | False |
The total duration in seconds for which the time tracker has been running. | |
| TimelineFrom | Date | False |
The start date for the timeline, used to specify when the project or task begins. | |
| TimelineTo | Date | False |
The end date for the timeline, marking the completion or due date for the project or task. | |
| TimelineVisualizationType | String | False |
The type of visualization to use for the timeline, defining how the timeline data is presented to the user. | |
| VoteCount | Int | False |
The total number of votes cast for the item, used in voting or polling scenarios. | |
| VoterIds | String | False |
A list of user IDs who have voted on the item, used to track voter participation. | |
| WeekStartDate | Date | False |
The start date for the week, typically used for scheduling or time tracking purposes. | |
| WeekEndDate | Date | False |
The end date for the week, marking the conclusion of the weekly period. | |
| WorldClock | String | False |
The timezone or world clock setting used to display the item's time in the correct time zone. |
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 |
| RelativeTo | String |
The item to which the current item is relative, used for positioning items next to each other in a layout. |
| PositionRelativeMethod | String |
The method used to determine the item's position relative to another item, either before or after it. |
| CreateLabelsIfMissing | Bool |
A pseudocolumn that indicates whether new labels for status or dropdown fields should be created if missing, requiring board structure modification permissions. |