InitiativeRelation

Returns all initiative parent-child relations in the workspace.

Table-Specific Information

SELECT

Retrieve Linear InitiativeRelation records:

SELECT * FROM InitiativeRelation LIMIT 1

INSERT

To insert an InitiativeRelation record:

INSERT INTO InitiativeRelation (initiativeId, relatedInitiativeId, sortOrder) VALUES ('0617da23-e55d-4eeb-9eec-a02c812ddd8e', '92f7a1e0-056b-44b4-80d9-43e0b0f3dda6', 1)

UPDATE

To update an InitiativeRelation record:

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

DELETE

To delete an InitiativeRelation record:

DELETE FROM InitiativeRelation 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.
initiativeId	String	False	The parent initiative in this hierarchical relation.
relatedInitiativeId	String	False	The child initiative in this hierarchical relation.
userId	String	True	The user who last created or modified the relation. Null if the user has been deleted.
sortOrder	Double	False	The sort order of the child initiative within its parent initiative.