Associates Project with ProjectLabel.

Table-Specific Information

SELECT

The add-in uses the Linear API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the add-in.

• projectId supports the =, !=, IN, NOT IN operators.
• projectLabelId supports the =, !=, IN, NOT IN operators.

For example, the following queries are processed server-side:

SELECT * FROM ProjectLabels LIMIT 1

INSERT

To insert a ProjectLabels record:

INSERT INTO ProjectLabels (projectId, projectLabelId) VALUES ('16015fc0-0aeb-4a05-9c8b-3451a0ee5e2a', '28920324-ec4a-4c91-a057-589ff4bc6f07')

DELETE

To delete a ProjectLabels record:

DELETE FROM ProjectLabels WHERE projectId = '16015fc0-0aeb-4a05-9c8b-3451a0ee5e2a' AND projectLabelId = '28920324-ec4a-4c91-a057-589ff4bc6f07'

Columns

Name	Type	ReadOnly	Description
projectId [KEY]	String	False	The id of the associated Project.
projectLabelId [KEY]	String	False	The id of the associated ProjectLabel.