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 will see a column called Category, with ToDo, Inprogress, and Done as the three status categories. This function fetches data based on this category change.
| 構文 | statusCategory() |
|---|---|
| サポートされるフィールド | StatusCategory |
| サポートされる演算子 | IN , NOT IN, = , != |
| サポートされない演算子 | ~ , !~ , > , >= , < , <= IS , IS NOT, WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED |
| 例 | Find all issues for which the status category is set to ToDo & In Progress: |
statusCategoryChangeDate()
Similar to StatusCategory, you can issue based on the timeline using the statusCategoryChangedDate() function.
| 構文 | statusCategoryChangedDate() |
|---|---|
| サポートされるフィールド | StatusCategory |
| サポートされる演算子 | = , != , > , >= , < , <= , CHANGED |
| サポートされない演算子 | ~ , !~ , IS , IS NOT, WAS , WAS IN , WAS NOT , WAS NOT IN |
| 例 | Find all issues for which the statusCategory has changed prior to 7 days. statusCategoryChangedDate <= -7d |