ODBC Driver for Jira

Build 23.0.8839

Projects

Query, update, insert and delete the available Projects in Jira.

Select

本製品 はJira API を使用して一部のフィルタを処理します。

本製品 は他のフィルタを本製品 内で処理します。 例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM Projects WHERE Id = 10000

INSERT

挿入には、Key、Name、LeadName、およびProjectTypeKey が必要です。次のクエリは、新しいプロジェクトを作成します。

INSERT INTO Projects (Key, Name, LeadName, ProjectTypeKey, Description) VALUES ('EXE4', 'Inserted Project 4', 'admin', 'business', 'New business project.')

Update

Id かKey のいずれかを指定して更新できます。

UPDATE Projects SET Description = 'Updated description', AssigneeType = 'UNASSIGNED', LeadName = 'admin2' WHERE Key = 'EXE4'

Delete

Id かKey のいずれかを指定してプロジェクトを削除できます。

DELETE FROM Projects WHERE Key = 'EXE4'

Columns

Name Type ReadOnly References SupportedOperators Platform Description
Id [KEY] Int True = Common

The Id of the project.

Key String False = Common

The key of the project.

Name String False Common

The name of the project.

Description String False Common

The description of the project.

LeadEmailAddress String True

Users.EmailAddress

Common

The email address of the project lead.

LeadDisplayName String True

Users.DisplayName

Common

The display name of the project lead.

ComponentsAggregate String True Common

The components of the project.

IssueTypesAggregate String True Common

The issue types of the project.

Url String True Common

The URL of the project.

Email String True Common

The email of the project.

AssigneeType String False Common

The assignee type of the project.

VersionsAggregate String True Common

The versions of the project.

RolesAggregate String True Common

The roles of the project.

ProjectKeysAggregate String True Common

The project keys of the project.

ProjectCategoryId String False Common

The Id of the project category.

ProjectCategoryName String True Common

The name of the project category.

ProjectCategoryDescription String True Common

The description of the project category.

ProjectTypeKey String False Common

The key of the project type. Not applicable for update.

LeadAccountId String False

Users.AccountId

Cloud

The Id of the project lead.

LeadAccountKey String True

Users.Key

Server

The Key of the project lead.

LeadAccountName String False

Users.Name

Server

The user name of the project lead.

Simplified Boolean True Cloud

Whether the project is team-managed or not.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839