KPI: group by storage
I need to add an execution that will summarize the number of active accessions by genebank by storage type.
The issue I'm facing is how to make a HQL select that groups by elements of a collection:
select ?, count(acce) from accession a inner join a.acce acce group by a.institute.code, acce.storage.elements() ??