JIRA reporting clarification

[Vibhor Dwivedi]

Jira reporting is good but when it comes to aggregating issue fields there are no options available.I am trying to simply querying projects with time spent for those projects but not found any JQL for the same.Is there any future plans to provide group by function on JIRA Issue search UI.Please correct me if i am wrong.

[Nic Brough -Adaptavist- · Accepted solution]

I don't think there is. The problem here is that defining what you want to group by and add up is so wide ranging and variable, there's no easy way to put together something that will make more than a tiny fraction of the user-base happy.

[Vibhor Dwivedi]

Thanks nic, Yes I am using few of the other tools which have group by option available for users and it make reporting very powerful. For complex reports in JIRA user has to either retrieve data and and process it in some other tool.

[Pablo Beltran]

SQL for JIRA transforms JQL into standard SQL so you can use SQL aggregation functions like SUM, COUNT, AVG, MAX, MIN, etc. in a straightforward way.