JDBC Driver for Jira

Build 23.0.8839


Query the available IssueSubtasks in Jira.

Table Specific Information

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


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'


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


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


=,<>,>,>=,<,<=,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


Common The issue type Id of the subtask.
TypeName String


Common The issue type name of the subtask.
TypeDescription String


Common The issue type description of the subtask.
TypeSubtask Boolean


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 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