SELECT DISTINCT x FROM y

Discussions about modeling, execution and management of process/application data.
Forum rules
Make sure every topic contains information about your LSPS version and if relevant also your server OS, client OS, database name and version, and application server name and version.
clay.rowland
 
Posts: 35
Joined: Thu Apr 19, 2012 8:14 pm

SELECT DISTINCT x FROM y

Mon Jul 09, 2012 2:49 pm

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;?

Maros Bajtos
 
Posts: 145
Joined: Mon Feb 27, 2012 2:52 pm

Re: SELECT DISTINCT x FROM y

Wed Jul 11, 2012 8:48 am

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.

Return to Data modeling

Who is online

Users browsing this forum: No registered users and 0 guests