Page 1 of 1

SELECT DISTINCT x FROM y

Posted: Mon Jul 09, 2012 2:49 pm
by clay.rowland
I'd like to retrieve the distinct values for a field defined on a shared record. What is the optimal way to do a SELECT DISTINCT x FROM y;?

Re: SELECT DISTINCT x FROM y

Posted: Wed Jul 11, 2012 8:48 am
by Maros Bajtos
This is not supported in the current version (2.6.1) of LSPS. The recommended way to solve this problem is implementing your own function as a method of an EJB, inject datasource and perform query using standard JDBC. Since this is very simple query without complicated entity mapping, I believe it should be satisfactory solution.

We plan to address this issue in future releases.