NotificationSubscription
The authenticated user's notification subscriptions. These subscriptions control which notifications the user receives for specific entities such as teams, projects, cycles, labels, custom views, initiatives, customers, and users.
Table-Specific Information
SELECT
Retrieve Linear NotificationSubscription records:SELECT * FROM NotificationSubscription LIMIT 1
INSERT
To insert a NotificationSubscription record:INSERT INTO NotificationSubscription (active) VALUES (true)
UPDATE
To update a NotificationSubscription record:UPDATE NotificationSubscription SET active = false 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. |
| subscriberId | String | True |
The user who will receive notifications from this subscription. |
| customerId | String | False |
The customer that this notification subscription is scoped to. Null if the subscription targets a different entity type. |
| customViewId | String | False |
The custom view that this notification subscription is scoped to. Null if the subscription targets a different entity type. |
| cycleId | String | False |
The cycle that this notification subscription is scoped to. Null if the subscription targets a different entity type. |
| labelId | String | False |
The issue label that this notification subscription is scoped to. Null if the subscription targets a different entity type. |
| projectId | String | False |
The project that this notification subscription is scoped to. Null if the subscription targets a different entity type. |
| initiativeId | String | False |
The initiative that this notification subscription is scoped to. Null if the subscription targets a different entity type. |
| teamId | String | False |
The team that this notification subscription is scoped to. Null if the subscription targets a different entity type. |
| userId | String | False |
The user that this notification subscription is scoped to, for user-specific view subscriptions. Null if the subscription targets a different entity type. |
| contextViewType | String | False |
The type of contextual view (e.g., active issues, backlog) that further scopes a team notification subscription. Null if the subscription is not associated with a specific view type. |
| userContextViewType | String | False |
The type of user-specific view that further scopes a user notification subscription. Null if the subscription is not associated with a user view type. |
| active | Bool | False |
Whether the subscription is active. When inactive, no notifications are generated from this subscription even though it still exists. |
| notificationSubscriptionTypes | String | False |
The specific notification event types the subscriber wants to receive for the target entity. Accepts a comma-separated list or JSON array of String values. Used only when creating or updating a record; reads return NULL. |