Returns all initiative-to-project associations in the workspace.

Table-Specific Information

SELECT

Retrieve Linear InitiativeToProject records:

SELECT * FROM InitiativeToProject LIMIT 1

INSERT

To insert an InitiativeToProject record:

INSERT INTO InitiativeToProject (initiativeId, projectId, sortOrder) VALUES ('0617da23-e55d-4eeb-9eec-a02c812ddd8e', '16015fc0-0aeb-4a05-9c8b-3451a0ee5e2a', 1)

UPDATE

To update an InitiativeToProject record:

UPDATE InitiativeToProject SET sortOrder = 2 WHERE id = 'b6d3252e-3bf4-4fb9-9cd0-cc57c63060a7'

DELETE

To delete an InitiativeToProject record:

DELETE FROM InitiativeToProject 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.
projectId	String	False	The project that the initiative is associated with.
initiativeId	String	False	The initiative that the project is associated with.
sortOrder	String	False	The sort order of the project within its parent initiative.