How to search using statusCategory() & statusCategoryChangedDate() function with JQL
Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.
Summary
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 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.
Syntax | statusCategory() |
|---|---|
Supported fields | StatusCategory |
Supported operators | IN , NOT IN, = , != |
Unsupported operators | ~ , !~ , > , >= , < , <= IS , IS NOT, WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED |
Examples | Find all issues for which the status category is set to ToDo & In Progress: StatusCategory in ("To Do","In Progress") |
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 | ~ , !~ , IS , IS NOT, WAS , WAS IN , WAS NOT , WAS NOT IN |
Examples | Find all issues for which the statusCategory has changed prior to 7 days. statusCategoryChangedDate <= -7d |
Was this helpful?