ODBC Driver for Jira

Build 24.0.8963

IssueComponents

Query the available IssueComponents in Jira.

Table Specific Information

You can search IssueComponents 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 IssueComponents are IssueId, IssueKey, and JQL. For example:

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

Columns

Name Type References SupportedOperators Platform Description
Id [KEY] String =,<>,IS,IS NOT,IN,NOT IN Common The Id of the component.
Name String Common The name of the component.
IssueId [KEY] Integer

Issues.Id

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

Issues.Key

=,<>,>,>=,<,<=,IN,NOT IN Common The issue key of the component.
IssueCreatedDate Datetime =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common The date the component's issue was created.
IssueUpdatedDate Datetime =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common The date the component's issue was last updated.
Description String Common The description of the component.

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 24.0.8963