JDBC Driver for Jira

Build 22.0.8462

IssueTypes

Query the available Issue Types in JIRA.

Select

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

The driver processes other filters within the driver.

SELECT * FROM IssueTypes WHERE Id = 3

Insert

Name is required to insert. The following query creates a new issue type:

INSERT INTO IssueTypes (Name, Description, Subtask) VALUES ('Issue type name 3', 'test description', false)

Update

You can update by specifying the issue type Id:

UPDATE IssueTypes SET Name = 'Updated Name 3', Description = 'Updated description' WHERE Id = 10306

Delete

Delete an issue type by specifying the issue type Id:

DELETE FROM IssueTypes WHERE Id = 10306

Columns

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

The Id of the issue type.

Name String False Common

The name of the issue type.

Description String False Common

The description of the issue type.

Subtask Boolean False Common

The subtask of the issue type. Not applicable for update.

IconUrl String True Common

The icon URL of the issue type.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462