Favorite

The authenticated user's favorites. Returns all bookmarked items that appear in the user's sidebar.

Table-Specific Information

SELECT

Retrieve Linear Favorite records:

SELECT * FROM Favorite LIMIT 1

INSERT

To insert a Favorite record:

INSERT INTO Favorite (sortOrder) VALUES (1)

UPDATE

To update a Favorite record:

UPDATE Favorite SET sortOrder = 2 WHERE id = 'feb9ca65-ee57-4edd-818a-76b43a0e60f4'

DELETE

To delete a Favorite record:

DELETE FROM Favorite WHERE id = 'feb9ca65-ee57-4edd-818a-76b43a0e60f4'

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	True	The type of entity this favorite references, such as 'issue', 'project', 'cycle', 'customView', 'document', 'folder', etc. Determines which associated entity field is populated.
parentId	String	False	The parent folder of the favorite. Null if the favorite is at the top level of the sidebar. Only favorites of type 'folder' can be parents.
folderName	String	False	The name of the folder. Only applies to favorites of type folder.
liveFolderPreset	String	False	The predefined live folder represented by this favorite.
liveFolderDefinition	String	True	The versioned lazy root and filter represented by this live favorite folder.
projectTab	String	False	The targeted tab of the project.
predefinedViewType	String	False	The type of favorited predefined view (e.g., 'allIssues', 'activeCycle', 'backlog', 'triage'). Only populated when the favorite type is 'predefinedView'.
initiativeTab	String	False	The targeted tab of the initiative.
pipelineTab	String	False	The targeted tab of the release pipeline.
ownerId	String	True	The user who owns this favorite. Favorites are personal and only visible to their owner.
sortOrder	Double	False	The position of this item in the user's favorites list. Lower values appear first. Used to maintain user-defined ordering within the sidebar.
issueId	String	False	The favorited issue.
projectId	String	False	The favorited project.
projectTeamId	String	True	[DEPRECATED] The favorited team of the project.
cycleId	String	False	The favorited cycle.
customViewId	String	False	The favorited custom view.
predefinedViewTeamId	String	False	The team of the favorited predefined view.
documentId	String	False	The favorited document.
initiativeId	String	False	The favorited initiative.
labelId	String	False	The favorited label.
projectLabelId	String	False	The favorited project label.
initiativeLabelId	String	False	[INTERNAL] The favorited initiative label.
userId	String	False	The favorited user.
customerId	String	False	The favorited customer.
releaseId	String	False	The favorited release.
releasePipelineId	String	False	The favorited release pipeline.
releaseNoteId	String	False	The favorited release note.
teamId	String	False	The favorited team.
url	String	True	URL of the favorited entity. Folders return 'null' value.
title	String	True	[Internal] Favorite's title text (name of the favorite'd object or folder).
detail	String	True	[Internal] Detail text for favorite's `title` (e.g. team's name for a project).
color	String	True	[Internal] Returns the color of the favorite's icon. Unavailable for avatars and views with fixed icons (e.g. cycle).
icon	String	True	[Internal] Name of the favorite's icon. Unavailable for standard views, issues, and avatars