Associates Project with User.

Table-Specific Information

SELECT

The component 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 component.

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

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

SELECT * FROM ProjectMembers LIMIT 1

INSERT

To insert a ProjectMembers record:

INSERT INTO ProjectMembers (projectId, userId) VALUES ('16015fc0-0aeb-4a05-9c8b-3451a0ee5e2a', 'cfa5f5f6-bcd8-4a1e-9844-5186f9af10e3')

DELETE

To delete a ProjectMembers record:

DELETE FROM ProjectMembers WHERE projectId = '16015fc0-0aeb-4a05-9c8b-3451a0ee5e2a' AND userId = 'cfa5f5f6-bcd8-4a1e-9844-5186f9af10e3'

Columns

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