SSIS Components for Jira

Build 24.0.9062

Epics

Query all the Epics.

テーブル固有の情報

Select

本製品 はJira API を使用して一部のフィルタを処理します。

本製品 は他のフィルタを本製品 内で処理します。

例えば、次のクエリはサーバー側でフィルタリングされます。

SELECT * FROM Epics WHERE BoardId = 1

SELECT * FROM Epics WHERE BoardId IN (1, 2, 3)

特定のエピックのId またはKey を指定:

SELECT * FROM Epics WHERE Id = 10000 

SELECT * FROM Epics WHERE Id IN (10000, 10001) 

SELECT * FROM Epics WHERE Key = 'TSS-9151' 

SELECT * FROM Epics WHERE Key IN ('TSS-9151', 'TSS-9152') 

Columns

Name Type References SupportedOperators Platform Description
Id [KEY] Integer =,IN Common The Id of the Epic.
Key [KEY] String =,IN Common The key of the Epic.
BoardId [KEY] Integer

Boards.Id

=,IN Common The board Id the Epic is in.
Name String Common The name of the Epic.
Done Boolean Common Whether or not the Epic is done.
ColorKey String Common The key of the Epic's color.
Summary String Common A brief summary for the Epic.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062