Jira Server Plugin Development: Group by

[Attila Czegledi]

Hi, I am developing a Jira Server plugin, where I would like to have the worklogs grouped by fields on the issues they were logged on.

Currently I have a functional solution, but it uses JDBC, and it is dependent on the  underlying postgre database. I would like it to work on multiple databases.

Is there a way to do this? 

[Aron Gombas _Midori_]

The recommended (bullet-proof) way of working with relational database is using ActiveObjects. It is DB independent and supported by Atlassian themselves.

I'm not sure if it has any concept of "group by", but if it doesn't, you can still do the grouping with the Java objects returned in your own code.