Hello,
We want to execute the belown SQL:
Employee[] eList = activeObject.find(Employee.class, Query.select("COUNTRY").distinct());
This results in an sql exception:
org.h2.jdbc.JdbcSQLException: Data conversion error converting "France"
I guess the `select` argument has to be the `ID` field.
Is their a way to use `DISTINCT` with active objects, and ideally, retrieve only the specified column?
PS: We found these 2 issues that describe exactly the same problem we are encoutering, but we don't see any solution their although they are marked as resolved. Could we have more details about this.
https://ecosystem.atlassian.net/browse/AO-6
https://ecosystem.atlassian.net/browse/AO-3521