ADO.NET Provider for Linear

Build 26.0.9776

Team

All teams whose issues the user can access. This includes public teams and private teams the user is a member of. This may differ from `administrableTeams`, which returns teams whose settings the user can change but whose issues they don't necessarily have access to.

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, <, <=, >, >=
name=, !=, IN, NOT IN, LIKE, CONTAINS
key=, !=, IN, NOT IN, LIKE, CONTAINS
description=, !=, IN, NOT IN, IS, IS NOT, LIKE, CONTAINS
retiredAt=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=
parentId=, !=, IN, NOT IN, IS, IS NOT
restrictedById=, !=, IN, NOT IN, IS, IS NOT
visibility=, !=, IN, NOT IN

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

SELECT * FROM Team LIMIT 1
SELECT * FROM Team WHERE createdAt = '2026-01-01T00:00:00Z' LIMIT 1

INSERT

To insert a Team record: 
INSERT INTO Team (name, key, description) VALUES ('sample', 'sample', 'sample')

UPDATE

To update a Team record: 
UPDATE Team SET name = 'sample' WHERE id = '921cb6bf-d5b6-44bb-9c6b-217b97dd27a2'

DELETE

To delete a Team record: 
DELETE FROM Team WHERE id = '921cb6bf-d5b6-44bb-9c6b-217b97dd27a2'

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 team's name.

key String False

The team's unique key, used as a prefix in issue identifiers (e.g., 'ENG' in 'ENG-123') and in URLs.

description String False

The team's description.

icon String False

The icon of the team.

color String False

The team's color.

retiredAt Datetime False

The time at which the team was retired. Retired teams no longer accept new issues or members. Null if the team has not been retired.

parentId String False

The team's parent team.

restrictedById String True

[Internal] For restricted teams, the enclosing private team that forms the visibility boundary. Null for public and private teams.

cyclesEnabled Bool False

Whether the team uses cycles for sprint-style issue management.

cycleStartDay Double False

The day of the week that a new cycle starts (0 = Sunday, 1 = Monday, ..., 6 = Saturday).

cycleDuration Double False

The duration of each cycle in weeks.

cycleCooldownTime Double False

The cooldown time after each cycle in weeks.

cycleIssueAutoAssignStarted Bool False

Auto assign started issues to current cycle.

cycleIssueAutoAssignCompleted Bool False

Auto assign completed issues to current cycle.

cycleLockToActive Bool False

Auto assign issues to current cycle if in active status.

upcomingCycleCount Double False

How many upcoming cycles to create.

timezone String False

The timezone of the team. Defaults to

inheritWorkflowStatuses Bool False

Whether the team should inherit its workflow statuses from its parent. Only applies to sub-teams.

inheritProjectStatuses Bool False

[Internal] Whether the team should inherit its project statuses from its parent team, or from the workspace when it has no parent.

inheritIssueEstimation Bool False

Whether the team should inherit its estimation settings from its parent. Only applies to sub-teams.

issueEstimationType String False

The issue estimation type to use. Must be one of

issueEstimationAllowZero Bool False

Whether to allow zeros in issues estimates.

setIssueSortOrderOnStateChange String False

Where to move issues when changing state.

issueEstimationExtended Bool False

Whether to add additional points to the estimate scale.

defaultIssueEstimate Double False

What to use as a default estimate for unestimated issues.

triageEnabled Bool False

Whether triage mode is enabled for the team. When enabled, issues created by non-members or integrations are routed to a triage state for review before entering the normal workflow.

requirePriorityToLeaveTriage Bool False

Whether an issue needs to have a priority set before leaving triage.

defaultIssueStateId String False

The default workflow state into which issues are set when they are opened by team members.

triageIssueStateId String True

The workflow state into which issues are set when they are opened by non-team members or integrations if triage is enabled.

allMembersCanJoin Bool False

Whether all members in the workspace can join the team. Only used for public teams.

securitySettings String False

Security settings for the team, including role-based restrictions for issue sharing, label management, member management, template management, and agent skills.

scimManaged Bool False

Whether the team is managed by a SCIM integration. SCIM-managed teams have their membership controlled by the identity provider.

scimGroupName String False

The SCIM group name for the team.

progressHistory String True

[Internal] The progress history of the team.

currentProgress String True

[Internal] The current progress of the team.

groupIssueHistory Bool False

Whether to group recent issue history entries.

aiThreadSummariesEnabled Bool False

Whether to enable resolved thread AI summaries.

aiDiscussionSummariesEnabled Bool False

Whether to enable AI discussion summaries for issues in this team.

autoClosePeriod Double False

Period after which issues are automatically closed in months. Null/undefined means disabled.

autoCloseStateId String False

The canceled workflow state which auto closed issues will be set to. Defaults to the first canceled state.

autoArchivePeriod Double False

Period after which automatically closed, completed, and duplicate issues are automatically archived in months.

autoCloseParentIssues Bool False

Whether parent issues should automatically close when all child issues are closed

autoCloseChildIssues Bool False

Whether child issues should automatically close when their parent issue is closed

joinByDefault Bool False

[Internal] Whether new users should join this team by default.

inheritSlackAutoCreateProjectChannel Bool False

[Internal] Whether the team should inherit its Slack auto-create project channel setting from its parent. Only applies to sub-teams.

slackAutoCreateProjectChannel Bool False

[Internal] Whether to automatically create a Slack channel when a new project is created in this team.

cycleCalenderUrl String True

Calendar feed URL (iCal) for cycles.

visibility String True

The visibility of the team. Returns public for teams visible to all workspace members, private for teams visible only to members, and restricted for non-private teams inside a private-team boundary.

displayName String True

The name of the team including its parent team name if it has one.

issueCount Int True

The total number of issues in the team. By default excludes archived issues; use the includeArchived argument to include them.

ledInitiativeCount Int True

The number of initiatives led by this team that would be deleted along with it. Counts every led initiative, including ones not otherwise visible to the caller, to mirror what deleting the team cascades.

activeCycleId String True

Team's currently active cycle.

triageResponsibilityId String True

Team's triage responsibility.

initiativesEnabled Bool False

Whether team initiatives are enabled and shown in the team's sidebar.

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