When using Active Objects in a Jira plugin you have a limited amount of operations you can execute against the database. For example the
count(*) - methods only allow to return the result of the first row. More or less the Active Objects API is restricted to entity-specific methods.
Example: Having a table named ‘votes’ with the field ‘weekday’ how could I query for the number of entries like this:
select count(*) from votes group by weekday;
Using Active Objects the following code just brings up the first result as the method only returns an ‘int’ value:
What is the right way to perform such type of database queries in a Jira plugin?