Database

Linear local sync: searchable entities, .search() filters, and operators.

The Linear plugin syncs data locally. Use corsair.linear.db.<entity>.search({ data, limit?, offset? }) with the filters listed per entity.

New to Corsair? See database operations, data synchronization, and multi-tenancy.

Comments

Path: linear.db.comments.search

const rows = await corsair.linear.db.comments.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
entity_id	string	equals, contains, startsWith, endsWith, in
id	string	equals, contains, startsWith, endsWith, in
body	string	equals, contains, startsWith, endsWith, in
issueId	string	equals, contains, startsWith, endsWith, in
userId	string	equals, contains, startsWith, endsWith, in
parentId	string	equals, contains, startsWith, endsWith, in
editedAt	date	equals, before, after, between
createdAt	date	equals, before, after, between
updatedAt	date	equals, before, after, between
archivedAt	date	equals, before, after, between

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

---

Issues

Path: linear.db.issues.search

const rows = await corsair.linear.db.issues.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
entity_id	string	equals, contains, startsWith, endsWith, in
id	string	equals, contains, startsWith, endsWith, in
title	string	equals, contains, startsWith, endsWith, in
description	string	equals, contains, startsWith, endsWith, in
estimate	number	equals, gt, gte, lt, lte, in
sortOrder	number	equals, gt, gte, lt, lte, in
number	number	equals, gt, gte, lt, lte, in
identifier	string	equals, contains, startsWith, endsWith, in
url	string	equals, contains, startsWith, endsWith, in
stateId	string	equals, contains, startsWith, endsWith, in
teamId	string	equals, contains, startsWith, endsWith, in
assigneeId	string	equals, contains, startsWith, endsWith, in
creatorId	string	equals, contains, startsWith, endsWith, in
projectId	string	equals, contains, startsWith, endsWith, in
cycleId	string	equals, contains, startsWith, endsWith, in
parentId	string	equals, contains, startsWith, endsWith, in
dueDate	date	equals, before, after, between
startedAt	date	equals, before, after, between
completedAt	date	equals, before, after, between
canceledAt	date	equals, before, after, between
triagedAt	date	equals, before, after, between
snoozedUntilAt	date	equals, before, after, between
createdAt	date	equals, before, after, between
updatedAt	date	equals, before, after, between
archivedAt	date	equals, before, after, between

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

---

Projects

Path: linear.db.projects.search

const rows = await corsair.linear.db.projects.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
entity_id	string	equals, contains, startsWith, endsWith, in
id	string	equals, contains, startsWith, endsWith, in
name	string	equals, contains, startsWith, endsWith, in
description	string	equals, contains, startsWith, endsWith, in
icon	string	equals, contains, startsWith, endsWith, in
color	string	equals, contains, startsWith, endsWith, in
priority	number	equals, gt, gte, lt, lte, in
sortOrder	number	equals, gt, gte, lt, lte, in
startDate	date	equals, before, after, between
targetDate	date	equals, before, after, between
completedAt	date	equals, before, after, between
canceledAt	date	equals, before, after, between
leadId	string	equals, contains, startsWith, endsWith, in
createdAt	date	equals, before, after, between
updatedAt	date	equals, before, after, between
archivedAt	date	equals, before, after, between

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

---

Teams

Path: linear.db.teams.search

const rows = await corsair.linear.db.teams.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
entity_id	string	equals, contains, startsWith, endsWith, in
id	string	equals, contains, startsWith, endsWith, in
name	string	equals, contains, startsWith, endsWith, in
key	string	equals, contains, startsWith, endsWith, in
description	string	equals, contains, startsWith, endsWith, in
icon	string	equals, contains, startsWith, endsWith, in
color	string	equals, contains, startsWith, endsWith, in
private	boolean	equals
createdAt	date	equals, before, after, between
updatedAt	date	equals, before, after, between
archivedAt	date	equals, before, after, between

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

---

Users

Path: linear.db.users.search

const rows = await corsair.linear.db.users.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
entity_id	string	equals, contains, startsWith, endsWith, in
id	string	equals, contains, startsWith, endsWith, in
name	string	equals, contains, startsWith, endsWith, in
email	string	equals, contains, startsWith, endsWith, in
displayName	string	equals, contains, startsWith, endsWith, in
avatarUrl	string	equals, contains, startsWith, endsWith, in
active	boolean	equals
admin	boolean	equals
createdAt	date	equals, before, after, between
updatedAt	date	equals, before, after, between

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

---