Distinct in seam

[aizaviour]

Hello all

Im using seam 2.0.1 and my database is Oracle 10g

I can't take distinct value from my seam generated entity

Plz guide me the code for the correct code with a example

In sql we can use

Select distinct col from table

how this can be implemented in seam..

[rogermorituesta.rogermori.yahoo.com]

Hi Ramesh:

A simple example is listed below.

You might want to transform the output into a List<Map> using a Hibernate transformer.

Roger.

select distinct p.attr1 as attr1, p.attr2 as attr2 from MyEntity p