ODBC Driver for Jira

Build 26.0.9770

IssueComponents

Lists components assigned to issues, which typically represent parts or modules of a project.

View-Specific Information

You can query IssueComponents by using a Jira Query Language (JQL) query as a filter.

SELECT

The driver uses the Jira API to process filters based on the IssueId, IssueKey, and JQL columns. The driver processes all other filters client-side.

For example, the following queries are processed server-side:

SELECT * FROM IssueComponents WHERE IssueId > 10022 AND IssueId < 10090;

Columns

Name Type References SupportedOperators Platform Description
Id [KEY] String =,IS,IS NOT,IN Common The unique identifier of the component associated with the issue, used internally by Jira to reference the component.
Name String Common The name of the component, which categorizes issues within a project into smaller parts such as modules, features, or teams.
IssueId [KEY] Integer Issues.Id =,!=,IN,NOT IN Common The internal numeric identifier of the issue that is associated with the component.
IssueKey String Issues.Key =,!=,IN,NOT IN Common The readable issue key (such as 'JIRA-456') that uniquely identifies the issue linked to the component.
IssueCreatedDate Datetime =,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common The timestamp representing when the issue associated with the component was originally created.
IssueUpdatedDate Datetime =,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common The timestamp representing the last time the issue linked to the component was updated.
Description String Common A short summary or explanation of what the component represents within the context of the project.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
JQL String Jira Query Language (JQL) allows filtering issue components by various fields, such as component name, issue key, or project.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770