ADO.NET Provider for Linear

Build 26.0.9776

CustomerNeed

All customer needs in the workspace, with optional filtering.

Table-Specific Information

SELECT

The provider 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 provider.

ColumnSupported Operators
id=, !=, IN, NOT IN
createdAt=, !=, IN, NOT IN, <, <=, >, >=
updatedAt=, !=, IN, NOT IN, <, <=, >, >=
customerId=, !=, IN, NOT IN, IS, IS NOT
issueId=, !=, IN, NOT IN, IS, IS NOT
projectId=, !=, IN, NOT IN, IS, IS NOT
commentId=, !=, IN, NOT IN, IS, IS NOT
priority=, !=, IN, NOT IN, <, <=, >, >=

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

SELECT * FROM CustomerNeed LIMIT 1
SELECT * FROM CustomerNeed WHERE priority = 1 LIMIT 1

INSERT

To insert a CustomerNeed record: 
INSERT INTO CustomerNeed (createdAt, customerId, issueId) VALUES ('2026-01-01T00:00:00Z', 'cae81b62-1a35-4aca-8994-79133f1d08a1', '6b0685fc-9057-4401-92d5-80bf69df275f')

UPDATE

To update a CustomerNeed record: 
UPDATE CustomerNeed SET priority = 1 WHERE id = 'a2619aaa-249d-4522-8d05-ecfe214bcf77'

DELETE

To delete a CustomerNeed record: 
DELETE FROM CustomerNeed WHERE id = 'a2619aaa-249d-4522-8d05-ecfe214bcf77'

Columns

Name Type ReadOnly Description
id [KEY] String False

The unique identifier of the entity.

createdAt Datetime False

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.

customerId String False

The customer organization this need belongs to. Null if the need has not yet been associated with a customer.

issueId String False

The issue this need is linked to. Either issueId or projectId must be set. When set, the need's projectId is denormalized from the issue's project.

projectId String False

The project this need is linked to. For issue-based needs, this is denormalized from the issue's project. For project-only needs, this is set directly.

commentId String False

An optional comment providing additional context for this need. Null if the need was not created from or associated with a specific comment.

attachmentId String False

The issue attachment linked to this need. Populated when the need originates from an intake source (e.g., Slack, Intercom) or when a URL is manually provided. Provides a link back to the original source of the customer feedback. Mutually exclusive with projectAttachment.

priority Double False

Whether the customer need is important or not. 0 = Not important, 1 = Important.

body String False

The body content of the need in Markdown format. Used to capture manual input about needs that cannot be directly tied to an attachment. Null if the need's content comes from an attached source.

bodyData String False

[Internal] The body content of the need as a Prosemirror document JSON string. This is the structured representation of the body field, used for rich text rendering in the editor.

creatorId String True

The user who manually created this customer need. Null for needs created automatically by integrations or intake sources.

originalIssueId String True

The issue this customer need was originally created on, before being moved to a different issue or project. Null if the customer need has not been moved from its original location.

url String True

The URL of the source attachment linked to this need, if any. Returns the URL from either the issue attachment or project attachment. Null if the need has no attached source.

content String True

The effective Markdown content shown for this customer need. Returns the manually stored body when present, otherwise falls back to content extracted from the source attachment. Null if no content is available.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9776