CustomView
All custom views accessible to the user, including personal views and shared workspace views. Excludes views scoped to a specific project or initiative.
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.| Column | Supported Operators |
| id | =, !=, IN, NOT IN |
| createdAt | =, !=, IN, NOT IN, <, <=, >, >= |
| updatedAt | =, !=, IN, NOT IN, <, <=, >, >= |
| name | =, !=, IN, NOT IN, LIKE, CONTAINS |
| creatorId | =, !=, IN, NOT IN |
| shared | =, != |
| modelName | =, !=, IN, NOT IN, LIKE, CONTAINS |
| teamId | =, !=, IN, NOT IN, IS, IS NOT |
For example, the following queries are processed server-side:
SELECT * FROM CustomView LIMIT 1
SELECT * FROM CustomView WHERE shared = true LIMIT 1
INSERT
To insert a CustomView record:INSERT INTO CustomView (name, description, icon) VALUES ('sample', 'sample', 'sample')
UPDATE
To update a CustomView record:UPDATE CustomView SET name = 'sample' WHERE id = 'e7235edb-efbc-420a-bca7-ff6f3153830f'
DELETE
To delete a CustomView record:DELETE FROM CustomView WHERE id = 'e7235edb-efbc-420a-bca7-ff6f3153830f'
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. |
| name | String | False |
The name of the custom view, displayed in the sidebar and navigation. |
| description | String | False |
The description of the custom view. |
| icon | String | False |
The icon of the custom view. Can be an emoji or a decorative icon identifier. |
| color | String | False |
The hex color code of the custom view icon. |
| creatorId | String | True |
The user who originally created the custom view. |
| ownerId | String | False |
The user who owns the custom view. For personal views, only the owner can see and edit the view. |
| updatedById | String | True |
The user who last updated the custom view. Null if the updater's account has been deleted. |
| filterData | String | False |
The structured filter applied to issues in the custom view. Used when the view's modelName is |
| projectFilterData | String | False |
The filter applied to projects in the custom view. When set, this view displays projects instead of issues. |
| initiativeFilterData | String | False |
The filter applied to initiatives in the custom view. When set, this view displays initiatives instead of issues. |
| feedItemFilterData | String | False |
The filter applied to feed items in the custom view. When set, this view displays feed items (updates) instead of issues. |
| shared | Bool | False |
Whether the custom view is shared with everyone in the organization. Shared views appear in the workspace sidebar for all members. Personal (non-shared) views are only visible to their owner. |
| slugId | String | True |
The custom view's unique URL slug, used to construct human-readable URLs. Automatically generated on creation. |
| modelName | String | True |
The entity type this view displays. Determined by which filter is set: |
| teamId | String | False |
The team that the custom view is scoped to. Null if the view is workspace-wide or scoped to a project/initiative instead. |