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 connector.

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
CardId	Long	The Card Id.