Excel Add-In for Jira

Build 25.0.9434

IssueComponents

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

Table Specific Information

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

Select

The add-in uses the Jira API to process some of the filters.

The add-in processes other filters within the add-in.

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

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 Jira Query Language (JQL) allows filtering issue components by various fields, such as component name, issue key, or project.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434