JPQL to enum in reports

Support
#1

Hi,
Is there a way to covert an aggregated jpql back to enum, I have created a report counting all active accounts. Is there a way to convert the 0 and 1 back to their enum equivalent?

Thanks.

#3

Hi,

Do you mean, display the String values of enum elements instead of their int ID values? If so, it is not supported for JPQL datasets, only Entities and List of entities.
But you still can use a CASE-condition in your JPQL query (CASE {WHEN … THEN …}).