How to search using statusCategory() & statusCategoryChangedDate() function with JQL
Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.
Purpose
This article will help us understand how to search for issues based on StatusCategory and statusCategoryChangedDate functions using JQL
Solution
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.
| Syntax | statusCategory() |
|---|---|
| Supported fields | StatusCategory |
| Supported operators | IN , NOT IN, = , != |
| Unsupported operators | ~ , !~ , > , >= , < , <= |
| Examples |
|
statusCategoryChangeDate()
Similar to StatusCategory, you can issue based on the timeline using the statusCategoryChangedDate() function.
| Syntax | statusCategoryChangedDate() |
|---|---|
| Supported fields | StatusCategory |
| Supported operators | = , != , > , >= , < , <= , CHANGED |
| Unsupported operators | ~ , !~ , |
| Examples |
|