Re: non-SQL query to find distinct relationships in an entity's table?

From: Michael Gentry (blacknex..mail.com)
Date: Mon May 15 2006 - 22:02:14 EDT

  • Next message: Marek Wawrzyczny: "Re: CayenneServlet response appears not to be GC'ed"

    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 <mkienen..mail.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?
    >

    This archive was generated by hypermail 2.0.0 : Mon May 15 2006 - 22:02:39 EDT