UserIssueDrafts
The issueDrafts of the authenticated user.
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.- userId supports the =, !=, IN, NOT IN operators.
For example, the following queries are processed server-side:
SELECT * FROM UserIssueDrafts LIMIT 1
Columns
| Name | Type | Description |
| userId [KEY] | String | The id of the parent User. |
| id [KEY] | String | The unique identifier of the entity. |
| createdAt | Datetime | The time at which the entity was created. |
| updatedAt | Datetime | 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 | The time at which the entity was archived. Null if the entity has not been archived. |
| title | String | The draft's title. This will become the issue's title when the draft is published. |
| description | String | The draft's description in markdown format. |
| priority | Double | The priority of the draft. 0 = No priority, 1 = Urgent, 2 = High, 3 = Normal, 4 = Low. |
| estimate | Double | The estimate of the complexity of the draft. Null if no estimate has been set. |
| dueDate | Date | The date at which the issue would be due. |
| teamId | String | Identifier of the team associated with the draft. Can be used to query the team directly. |
| cycleId | String | Identifier of the cycle associated with the draft. Can be used to query the cycle directly. Null if no cycle is assigned. |
| projectId | String | Identifier of the project associated with the draft. Can be used to query the project directly. Null if no project is assigned. |
| projectMilestoneId | String | Identifier of the project milestone associated with the draft. Can be used to query the project milestone directly. Null if no milestone is assigned. |
| assigneeId | String | Identifier of the user assigned to the draft. Can be used to query the user directly. Null if the draft is unassigned. |
| delegateId | String | The agent user delegated to work on the issue being drafted. |
| stateId | String | Identifier of the workflow state associated with the draft. Can be used to query the workflow state directly. Determines the initial status the issue will have when the draft is published. |
| parentId | String | The ID of the parent issue draft, if any. |
| sourceCommentId | String | Identifier of the comment that the draft was created from. Set when a draft is created from an existing comment. Null if the draft was not created from a comment. |
| parentIssueId | String | The ID of the parent issue, if any. |
| subIssueSortOrder | Double | The order of items in the sub-draft list. Only set if the draft has `parent` set. |
| priorityLabel | String | Label for the priority. |
| descriptionData | String | [Internal] The draft's description as a Prosemirror document. |
| attachments | String | Serialized array of JSONs representing attachments. |
| needs | String | Serialized array of JSONs representing customer needs. |
| relations | String | Serialized issue relations to recreate when the draft is published. |
| schedule | String | Serialized array of JSONs representing the recurring issue's schedule. |