JDBC Driver for Jira

Build 23.0.8839

IssueSubtasks

Query the available IssueSubtasks in Jira.

Table Specific Information

You can search for IssueSubtasks by using SQL and JQL (Jira Query Language).

Select

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

The driver processes other filters within the driver.

The available columns for IssueSubtasks are IssueId, IssueKey, and JQL. For example:

SELECT * FROM IssueSubtasks WHERE IssueId = 10009 AND JQL = 'creator = john'

Columns

Name Type References SupportedOperators Platform Description
SubtaskId [KEY] String Common The Id of the subtask.
SubtaskKey String Common The key of the subtask.
IssueId Integer

Issues.Id

=,<>,>,>=,<,<=,IN,NOT IN Common The Id of the parent issue.
IssueKey String

Issues.Key

=,<>,>,>=,<,<=,IN,NOT IN Common The key of the parent issue.
IssueCreatedDate Datetime =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common The date the subtask's issue was created.
IssueUpdatedDate Datetime =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common The date the subtask's issue was last updated.
Summary String Common The summary of the subtask.
TypeId String

IssueTypes.Id

Common The issue type Id of the subtask.
TypeName String

IssueTypes.Name

Common The issue type name of the subtask.
TypeDescription String

IssueTypes.Description

Common The issue type description of the subtask.
TypeSubtask Boolean

IssueTypes.Subtask

Common A boolean indicating if the issue is a subtask.
PriorityId String Common The priority Id of the subtask.
PriorityName String Common The priority name of the subtask.
StatusId String Common The status Id of the subtask.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
JQL String JQL (Jira Query Language) allows you to build structured queries.

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