Can some one help me in updating the following JQL query.

Question

I have applied a filter with the following condition.

issuetype = Bug AND project = SR AND status in ("Deployed to Beta Env", "Deployed to Test Env.", Done, "Ready for Deployment", "Ready for Testing") ORDER BY status ASC, created DESC

I want to group different status into a single status and should be considered as done, so that while generating a report "Created vs Resolved" I want all these various status to be displayed under reolved.

Regards

Syamala

Carlos Garcia Navarro · Answer

Hmm..my understanding is that next-gen projects only have one resolution and is set when the issue is moved to the column furthest to the right, so there may not be much flexibility at the moment. I'd play with reports like Nic suggested in his answer. If I figure out one way to do this, I'll let you know. :-)

Nic Brough -Adaptavist- · Answer

JQL is not SQL.  JQL only finds issues, it has nothing to say about the content of them (except for the order, which some reports use)

For your reporting, first find a report that can group issues together, and then configure it to look at "status category"

Syamala Uggina · Answer

Thanks for the response AIO. As of now we don't have plans to look in to any apps. We want to leverage the existing functionalities of JIRA to generate the reports.

if our requirement was not full filled by JIRA for sure will revisit your App.

Thanks again for the quick response.