IssueTransitions

Query the available IssueTransitions in Jira.

テーブル固有の情報

SQL とJQL (Jira Query Language) を使用して、IssueTransitions を検索できます。

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

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

IssueTransitions で使用可能なカラムは、IssueId、IssueKey、およびJQL です。次に例を示します。

SELECT * FROM IssueTransitions WHERE JQL = 'id=10022'


Name	Type	References	SupportedOperators	Platform	Description
Id [KEY]	String			Common	The Id of the transition.
IssueId [KEY]	Integer	Issues.Id	=,<>,>,>=,<,<=,IN,NOT IN	Common	The Id of the issue.
IssueKey	String	Issues.Key	=,<>,>,>=,<,<=,IN,NOT IN	Common	The key of the issue.
IssueCreatedDate	Datetime		=,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN	Common	The date the transition's issue was created.
IssueUpdatedDate	Datetime		=,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN	Common	The date the transition's issue was last updated.
HasScreen	String			Common	Whether the transition has a screen.
Name	String			Common	The name of the transition.
ToDescription	String			Common	The description of the status the issue is transitioning to.
ToId	String			Common	The Id of the status the issue is transitioning to.
ToName	String			Common	The name of the status the issue is transitioning to.
StatusCategoryId	String			Common	The status category Id of the transition.
StatusCategoryKey	String			Common	The status category key of the transition.
StatusCategoryName	String			Common	The status category name of the transition.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
JQL	String		JQL (Jira Query Language) allows you to build structured queries.