ProjectRelation

Returns all project dependency relations in the workspace.

Table-Specific Information

SELECT

Retrieve Linear ProjectRelation records:

SELECT * FROM ProjectRelation LIMIT 1

INSERT

To insert a ProjectRelation record:

INSERT INTO ProjectRelation (type, projectId, relatedProjectId, anchorType, relatedAnchorType) VALUES ('blocks', '16015fc0-0aeb-4a05-9c8b-3451a0ee5e2a', 'f325215e-9ec8-4a0d-87f1-2499ce3c2f0c', 'start', 'start')

UPDATE

To update a ProjectRelation record:

UPDATE ProjectRelation SET projectMilestoneId = '921cb6bf-d5b6-44bb-9c6b-217b97dd27a2' WHERE id = 'b6d3252e-3bf4-4fb9-9cd0-cc57c63060a7'

DELETE

To delete a ProjectRelation record:

DELETE FROM ProjectRelation WHERE id = 'b6d3252e-3bf4-4fb9-9cd0-cc57c63060a7'

Columns


Name	Type	ReadOnly	Description
id [KEY]	String	False	The unique identifier of the entity.
createdAt	Datetime	True	The time at which the entity was created.
updatedAt	Datetime	True	The last time at which the entity was meaningfully updated. This is the same as the creation time if the entity hasn't been updated after creation.
archivedAt	Datetime	True	The time at which the entity was archived. Null if the entity has not been archived.
type	String	False	The type of dependency relationship from the project to the related project (e.g., blocks).
projectId	String	False	The source project in the dependency relation.
projectMilestoneId	String	False	The specific milestone within the source project that the relation is anchored to. Null if the relation applies to the project as a whole.
anchorType	String	False	The type of anchor on the source project end of the relation, indicating whether it is anchored to the project itself or a specific milestone.
relatedProjectId	String	False	The target project in the dependency relation.
relatedProjectMilestoneId	String	False	The specific milestone within the target project that the relation is anchored to. Null if the relation applies to the target project as a whole.
relatedAnchorType	String	False	The type of anchor on the target project end of the relation, indicating whether it is anchored to the project itself or a specific milestone.
userId	String	True	The user who last created or modified the relation. Null if the user has been deleted.