ODBC Driver for Jira

Build 24.0.8963

Projects

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

Select

The driver uses the Jira API to process some of the filters.

The driver processes other filters within the driver. For example, the following queries are processed server side:

SELECT * FROM Projects WHERE Id = 10000

INSERT

Key, Name, LeadName and ProjectTypeKey are required to insert. The following query creates a new project:

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

Update

You can update by specifying either Id or Key:

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

Delete

Delete a project by specifying either Id or 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 24.0.8963