CardTableCards
Create, Update, and Query the Card table cards.
Table Specific Information
Select
The following queries are processed server side while other filters are processed client side within the add-in.SELECT * FROM CardTableCards WHERE ProjectId = '37595039' AND CardTableColumnId = '7416523073' SELECT * FROM CardTableCards WHERE ProjectId = '37595039' AND Id = '7416545710'
Insert
The columns CardTableColumnId, ProjectId and Title are required to insert.
INSERT INTO CardTableCards(ProjectId, CardTableColumnId, Title, Content, DueOn) VALUES('37595039', '7416523073', 'Test title2', 'Test Content2', '2025-01-02')
Update
You must specify the ProjectId and Id of the CardTableCard to update it.
UPDATE CardTableCards SET Title = 'Updated title' WHERE ProjectId = '37595039' AND Id = '7420207738'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
Projects.KanbanBoardId |
Id of the Card Table column. |
| ProjectId | Long | True |
Projects.Id |
The Project Id. |
| CardTableColumnId | Long | True |
The CardTableColum Id. | |
| 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. | |
| Completed | Boolean | True |
Completed. | |
| Content | String | False |
Content. | |
| DueOn | Datetime | False |
Due date. | |
| CommentCount | Integer | True |
Comment count. | |
| CommentsCount | Integer | True |
Comments count. | |
| CommentsUrl | String | True |
Comments Url. | |
| Assignees | String | True |
Assigness. | |
| CompletionSubscribers | String | True |
Completion subscribers. | |
| CompletionUrl | String | True |
Completion url. |