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

[Syamala Uggina]

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

[Nic Brough -Adaptavist-]

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"

[Carlos Garcia Navarro]

Hi @Syamala Uggina

you could also use the 'resolution' field to refer to all the tickets that are resolved. E.g., with this clause: ... resolution is not EMPTY...

Hope it helps.

[Syamala Uggina]

Thanks Carlos..I think this information really helps .What I have noticed is Resolution field is hidden and could not able to do any configuration changes as my project is created under "Next Gen" Category.

Where ever the resolution field captures the value as "Done" those issues are displayed in my report. 

Please di help me how can I make the resolution field visible

[Carlos Garcia Navarro]

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. :-)

[Navarambh Software - Gmail]

Hi,

As per my knowledge, JQL does not allow bucketing of statuses (or any other field).

You may need a third party add-on to achieve this. 

This is possible with our app: AIO Reports and Timesheets for Jira

https://marketplace.atlassian.com/apps/1212942/aio-reports-and-timesheets-for-jira?hosting=cloud&tab=overview

Documentation link:

https://aioreports.atlassian.net/wiki/spaces/ART/overview

A calculated field to bucket the statuses can be created, and then that field can be used to create the created/resolved report using a multi-axis bar chart.

Please let us know if you need us to share detailed steps.

For any questions or issues, please email us at support@aioreports.com

Regards

AIO Support

[Syamala Uggina]

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.