The templates of a Team.

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
teamId	=, !=, IN, NOT IN
id	=, !=, IN, NOT IN
createdAt	=, !=, IN, NOT IN, <, <=, >, >=
updatedAt	=, !=, IN, NOT IN, <, <=, >, >=
type	=, !=, IN, NOT IN, LIKE, CONTAINS
name	=, !=, IN, NOT IN, LIKE, CONTAINS

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

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

Columns

Name	Type	Description
teamId [KEY]	String	The id of the parent Team.
id [KEY]	String	The unique identifier of the entity.
createdAt	Datetime	The time at which the entity was created.
updatedAt	Datetime	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	The time at which the entity was archived. Null if the entity has not been archived.
type	String	The entity type this template is for, such as 'issue', 'project', or 'document'.
name	String	The name of the template.
description	String	A description of what the template is used for.
icon	String	The icon of the template, either a decorative icon type or an emoji string. Null if no icon has been set.
color	String	The hex color of the template icon. Null if no custom color has been set.
templateData	String	The template data as a JSON-encoded string containing the pre-filled attributes for the entity type (e.g., issue fields, project configuration, or document content).
sortOrder	Double	The sort order of the template within the templates list.
lastAppliedAt	Datetime	The date when the template was last applied to create or update an entity. Null if the template has never been applied.
content	String	The template's content in markdown format: the body it pre-fills on the entity it creates. Distinct from `description`, which says what the template is for. Form templates serialize their form fields as markdown placeholders instead. Null when the template has no content.
hasFormFields	Bool	[Internal] Whether the template has form fields