cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Gentry" <blackn...@gmail.com>
Subject Re: non-SQL query to find distinct relationships in an entity's table?
Date Tue, 16 May 2006 02:02:14 GMT
I wonder if you could do this by exposing the PK/FK attributes so that
you could use them in an expression?

/dev/mrg


On 5/10/06, Mike Kienenberger <mkienenb@gmail.com> wrote:
> I'm building a search panel, and I want to populate one of the search
> criteria fields with the distinct list of values in the table being
> searched.
>
> Basically, the DataObject results returned from:
>
> select * from OTHER_TABLE
>     where OTHER_TABLE_PK in
>         (select distinct(OTHER_TABLE_FK) from SEARCHED_TABLE)
>
> Is there a way to do this other than using SQL Template?
>

Mime
View raw message