CardTableColumns
Create, Update, and Query the Card table columns.
Table Specific Information
Select
The following query is processed server side while other filters are processed client side within the add-in.SELECT * FROM CardTableColumns WHERE ProjectId = '37595039' AND Id = '7416500344'
Insert
The columns CardId, ProjectId and Title are required to insert.
INSERT INTO CardTableColumns(CardId, ProjectId, Title, Description) VALUES('7416037619', '37595039', 'testTitle', 'testDesc')
Update
You must specify the ProjectId and Id of the CardTableColumn to update it.
UPDATE CardTableColumns SET Title = 'Updated title' WHERE ProjectId = '37595039' AND Id = '7416500344'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
Id of the Card Table column. | |
| ProjectId | Long | True |
Projects.Id |
The Project Id. |
| Status | String | True |
Status. | |
| VisibleToClients | Boolean | True |
Boolean value representing whether the columns are visible to clients. | |
| CreatedAt | Datetime | True |
The creation date. | |
| UpdatedAt | Datetime | True |
The updation date. | |
| Title | String | False |
Title. | |
| InheritsStatus | Boolean | True |
Inherits status. | |
| Type | String | True |
Type. | |
| Url | String | True |
Url. | |
| AppUrl | String | True |
App url. | |
| BookmarkUrl | String | True |
Bookmark url. | |
| SubscriptionUrl | String | True |
Subscription url. | |
| Position | Integer | True |
Position. | |
| ParentId | Long | True |
Parent Id. | |
| ParentTitle | String | True |
Parent title. | |
| ParentType | String | True |
Parent Type. | |
| ParentUrl | String | True |
Parent url. | |
| ParentAppUrl | String | True |
Parent app url. | |
| BucketId | Long | True |
Project Id. | |
| BucketName | String | True |
Project name. | |
| BucketType | String | True |
Project type. | |
| CreatorId | Long | True |
People.Id |
Creator Id. |
| Description | String | False |
Description. | |
| Subscribers | String | True |
Subscribers. | |
| Color | String | True |
Color. | |
| CardsCount | Integer | True |
Cards count. | |
| CommentCount | Integer | True |
Comments count. | |
| CardsUrl | String | True |
Cards url. |
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 |
| CardId | Long |
The Card Id. |