Using distinct with active objects

Soufiane June 2, 2020

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

 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events