The history of a Issue.

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.

• issueId supports the =, !=, IN, NOT IN operators.

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

SELECT * FROM IssueHistory LIMIT 1

Columns

Name	Type	Description
issueId [KEY]	String	The id of the parent Issue.
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.
actorId	String	Identifier of the user who made these changes. Can be used to query the user directly. Null if the change was made by an integration, automation, or system process.
updatedDescription	Bool	Whether the issue's description was updated.
fromTitle	String	What the title was changed from.
toTitle	String	What the title was changed to.
fromAssigneeId	String	Identifier of the user from whom the issue was re-assigned. Can be used to query the user directly. Null if the assignee was not changed or the issue was previously unassigned.
toAssigneeId	String	Identifier of the user to whom the issue was assigned. Can be used to query the user directly. Null if the assignee was not changed or the issue was unassigned.
fromPriority	Double	What the priority was changed from.
toPriority	Double	What the priority was changed to.
fromTeamId	String	Identifier of the team from which the issue was moved. Can be used to query the team directly. Null if the team was not changed.
toTeamId	String	Identifier of the team to which the issue was moved. Can be used to query the team directly. Null if the team was not changed.
fromParentId	String	Identifier of the previous parent issue. Can be used to query the issue directly. Null if the parent was not changed or the issue previously had no parent.
toParentId	String	Identifier of the new parent issue. Can be used to query the issue directly. Null if the parent was not changed or the issue was removed from its parent.
fromStateId	String	Identifier of the previous workflow state (issue status) of the issue. Can be used to query the workflow state directly. Null if the status was not changed.
toStateId	String	Identifier of the new workflow state (issue status) of the issue. Can be used to query the workflow state directly. Null if the status was not changed.
fromCycleId	String	Identifier of the previous cycle of the issue. Can be used to query the cycle directly. Null if the cycle was not changed or the issue was not in a cycle.
toCycleId	String	Identifier of the new cycle of the issue. Can be used to query the cycle directly. Null if the cycle was not changed or the issue was removed from a cycle.
toConvertedProjectId	String	Identifier of the new project that was created by converting this issue to a project. Can be used to query the project directly. Null if the issue was not converted to a project.
fromProjectId	String	Identifier of the previous project of the issue. Can be used to query the project directly. Null if the project was not changed or the issue was not in a project.
toProjectId	String	Identifier of the new project of the issue. Can be used to query the project directly. Null if the project was not changed or the issue was removed from a project.
fromEstimate	Double	What the estimate was changed from.
toEstimate	Double	What the estimate was changed to.
archived	Bool	Whether the issue was archived (true) or unarchived (false) in this change. Null if the archive status was not changed.
trashed	Bool	Whether the issue was trashed or un-trashed.
attachmentId	String	Identifier of the attachment that was linked to or unlinked from the issue. Can be used to query the attachment directly. Null if no attachment change occurred.
autoClosed	Bool	Whether the issue was auto-closed.
autoArchived	Bool	Whether the issue was auto-archived.
fromDueDate	Date	What the due date was changed from.
toDueDate	Date	What the due date was changed to.
customerNeedId	String	[Deprecated] Identifier of the customer need that was linked to the issue. Use customer need related arrays in changes instead.
changes	String	[Internal] Serialized JSON representing changes for certain non-relational properties.
triageResponsibilityAutoAssigned	Bool	Boolean indicating if the issue was auto-assigned using the triage responsibility feature.
fromSlaStartedAt	Datetime	The time at which the issue's SLA was previously started.
toSlaStartedAt	Datetime	The time at which the issue's SLA is now started.
fromSlaBreachesAt	Datetime	The SLA breach time that was previously set on the issue.
toSlaBreachesAt	Datetime	The SLA breach time that is now set on the issue.
fromSlaBreached	Bool	Whether the issue had previously breached its SLA.
toSlaBreached	Bool	Whether the issue has now breached its SLA.
fromSlaType	String	The type of SLA that was previously set on the issue.
toSlaType	String	The type of SLA that is now set on the issue.