report grouped by custom field in Jira Service Desk

Question

Jira Service Desk cloud. i have a series of service requests. each service request has a custom field called product. i would like to build a list of requests with a grouping by product. i started to build custom queues for each product, but with 100 products it becomes very difficult to manage. do you know a way to make groupings on custom field to show the queue of Jira Service Desk or to make reports in Jira Service Desk ?

Mario O.G · Answer

Hi Calogero,

I think Structure Cloud might be what you need here.

Structure Cloud is an app that makes it easy for project managers to assemble meaningful, big-picture views of the project information that’s buried in Jira.

It also allows you to group your issues by custom fields, which appears to be your goal.

The Structure Cloud quick start guide is available here.

I hope that helps!

Mario O.G
[ALM Works]

Consulente Atlassian · Answer

thank you for your answer. Yes I know this JQL command. The fact is that this command still produces a list of hundreds of issues, though sorted by product alphabetically. I may not have written my problem right. I find the set of reports that is Jira Service Desk very small so I'm looking for some plugins that allow me to do this kind of aggregations.

Petter Gonçalves · Answer

Hello @Consulente Atlassian

Thank you for reaching out.

Per your description, I believe you are trying to return a list of issues grouped by the value of a custom field (Product), where you can use to configure your reports in Jira Service Desk. Is that correct?

I believe you can achieve this goal by creating a single JQL filter to return all your project issues in the issue navigator, and using the parameter ORDER BY to properly group your issues by the selected value in the custom field:

Project = yourproject and ORDER BY product

You can have more details about the JQL language in the documentation below:

JQL structure

Let us know if you have any questions.