I have different JIRA Status(such as ToDo, In-progress, Grooming, UAT, etc..), i want combine status

[Anantharaj]

Currently we have some different type of JIra ticket status, such as below example. 
But, I need to display the below status count in Two dimension filter Gadget/ Column Chart Gadget. I want to write a Script to retrieve the records by merging some of the status to be simple/user friendly statusmessage for high-level business understanding. something like below,

For example (from the below status):

BACKLOGS
TO DO
CANCELLED
GROOMING
READY FOR DEVELOPMENT

IN PROGRESS
TESTING
DONE

For example (I want to combine the status as below):
IN BACKLOGS  ( All above BACKLOGS)
REQUIREMENT(The above "TO DO" and "GROOMING" items only)

IN-PROGRESS (All above "READY FOR DEVELOPMENT", "IN PROGRESS",  "TESTING")
DONE ( The above "DONE")


How to write Jira Search Query/Script to combine the above JIRA status like that, so can use that Script to create the Gadget accordingly in JIRA DASHBOARD.?

[Emre Toptancı _OBSS_ · Accepted solution]

Hello @Anantharaj

I am not sure I understand your need perfectly but I believe you are trying to get a "Two Dimentional Filter Statistics" gadget, with one dimension being Status. The thing is, you want to display not each individual status, but you want to put them in status groups.

If that is the case, I am sorry but it can't be done with plain JQL.

I can recommend the following solution which requires a little configuration.

Create a Select List custom field named Status Group. Define all status group names as options of this field. Modify each transition in your workflow(s) and make sure that the correct status group name is set to this field in each transition. You can also update this field on existing issues using Bulk Change.

When this is all done, instead of using the Status field you can use the Status Group custom field to prepare your Two-Dimensional gadget.

The upside of this solution is: It doesn't require any additional apps. The downside is: It requires some configuration (proportional to the number of workflows/transitions you have) so it might be hard to build and maintain.

Hope this helps.

[Anantharaj]

Thanks for the assistance, @Emre Toptancı _OBSS_this helps.

[Rahul_RVS]

Hi @Anantharaj 

Welcome to the community !!

If you would be interested in a third party app to group your statues and view count for each of your status groups, you can try out our app

Time in Status Reports 

The add-on provides the time in each status for the entire lifecycle of the issue and you can filter by issue type as well. You can also combine your statuses to define your lead/cycle/resolution time and also extract the transitions history of the issues. The main features of the app are as below

• More than 8 types of Time in Status Reports. Excel Export available for all status reports.
  
  • Time in Status
  • Time with Assignee
  • Time in Status with Assignee
  • Time with Assignee per Status
  • Status/Assignee Count
  • Multiple Transition Reports
  • Avg Time in status reports
• Status grouping
• Save your reports
• CSV Export
• Multiple chart types