sql select distinct in datasource? OR how to avoid duplicate results

[rpoyner]

I'm pulling data from a table in an Oracle data warehouse. A select of the fields I need returns multiple identical lines unless I use something like select distinct to limit the results. Can the datasource xml be written in a way that will generate a fetch query like this:

select distinct
field.1
field.2
field.3
from myBigMessyTable
where idNumber=idNumberOfInterest;

The complete, long list of fields in the upstream view of course forms a unique record, but the subset of fields that I need ends up with lots of repeats. Using a list of desired fields with select distinct gives unique results, but maybe there is a more smartclient friendly way to achieve something similar?

select
*
from myBigMessyTable
where idNumber=idNumberOfInterest
group by
field.1
field.2
field.3;

Might also work, but of course I have no idea how to code that into a datasource either.

Thanks
RP

[Blama]

Hi rpoyner,

see the very last text block in the ServerSummaries-docs, which describes exactly your way 2.

Best regards
Blama

[rpoyner]

Beautiful.

Thanks.