SSIS Components for Jira

Build 22.0.8509

BoardIssues

Query the agile Board Issues in Jira.

テーブル固有の情報

Select

本製品 はJira API を使用して一部のフィルタを処理します。 本製品 は他のフィルタを本製品 内で処理します。 SupportEnhancedSQL をfalse に設定することで、クエリのクライアント側の実行をオフにできます。

例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM BoardIssues WHERE BoardId = '1' 
SELECT * FROM BoardIssues WHERE BoardId IN (70,215) 

Columns

Name Type References SupportedOperators Platform Description
Id [KEY] Integer

Issues.Id

=,IN Common The Id of the issue.
Key String

Issues.Key

=,IN Common The key of the issue.
BoardId [KEY] Integer

Boards.Id

=,IN Common The board the issue is included in.
IssueTypeId String

IssueTypes.Id

=,!=,IS,IS NOT,IN,NOT IN Common The issue type Id.
IssueTypeName String =,!=,IS,IS NOT,IN,NOT IN Common The issue type name.
StatusId Integer

Statuses.Id

=,!=,IS,IS NOT,IN,NOT IN Common The issue status Id.
StatusName String =,!=,IS,IS NOT,IN,NOT IN Common The issue status name.
ProjectId Integer

Projects.Id

=,!=,IS,IS NOT,IN,NOT IN Common The project Id of the issue.
ProjectKey String

Projects.Key

=,!=,IS,IS NOT,IN,NOT IN Common The project key of the issue.
ProjectName String =,!=,IS,IS NOT,IN,NOT IN Common The project name of the issue.
ClosedSprintsAggregate String Common The issue's previous sprints that have been closed.
Created Datetime =,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common The creation date of the issue.
Updated Datetime =,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common The updated date of the issue.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8509