ProjectTeams
Associates Project with Team.
Table-Specific Information
SELECT
The connector 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 connector.- projectId supports the =, !=, IN, NOT IN operators.
- teamId supports the =, !=, IN, NOT IN operators.
For example, the following queries are processed server-side:
SELECT * FROM ProjectTeams LIMIT 1
INSERT
To insert a ProjectTeams record:INSERT INTO ProjectTeams (projectId, teamId) VALUES ('16015fc0-0aeb-4a05-9c8b-3451a0ee5e2a', '921cb6bf-d5b6-44bb-9c6b-217b97dd27a2')
DELETE
To delete a ProjectTeams record:DELETE FROM ProjectTeams WHERE projectId = '16015fc0-0aeb-4a05-9c8b-3451a0ee5e2a' AND teamId = '921cb6bf-d5b6-44bb-9c6b-217b97dd27a2'
Columns
| Name | Type | ReadOnly | Description |
| projectId [KEY] | String | False |
The id of the associated Project. |
| teamId [KEY] | String | False |
The id of the associated Team. |