How to search using statusCategory() & statusCategoryChangedDate() function with JQL
プラットフォームについて: Cloud のみ - この記事は クラウド プラットフォームのアトラシアン製品に適用されます。
目的
This article will help us understand how to search for issues based on StatusCategory and statusCategoryChangedDate functions using JQL
ソリューション
A function in JQL appears as a word followed by parentheses, which may contain one or more explicit values or Jira fields. In a clause, a function is preceded by an operator, which in turn is preceded by a field. A function performs a calculation on either specific Jira data or the function's content in parentheses, such that only true results are retrieved by the function, and then again by the clause in which the function is used.
statusCategory()
Search for issues based on status category. When you navigate to https://JIRASITENAME.atlassian.net/secure/admin/ViewStatuses.jspa you can see a column called Category and (ToDo, Inprogress, Done) are the three status categories. This function uses to fetch data based on this category change.
| 構文 | statusCategory() |
|---|---|
| サポートされるフィールド | StatusCategory |
| サポートされる演算子 | IN , NOT IN, = , != |
| サポートされない演算子 | ~ , !~ , > , >= , < , <= |
| 例 |
|
statusCategoryChangeDate()
Similar to StatusCategory, you can issue based on the timeline using the statusCategoryChangedDate() function.
| 構文 | statusCategoryChangedDate() |
|---|---|
| サポートされるフィールド | StatusCategory |
| サポートされる演算子 | = , != , > , >= , < , <= , CHANGED |
| サポートされない演算子 | ~ , !~ , |
| 例 |
|