Queries based on relationship size

From: Kevin Menard (kmenar..ervprise.com)
Date: Wed Feb 20 2008 - 20:05:59 EST

  • Next message: Frank Schwarz: "Create SQL-DDL scripts"

    Greetings,

    I'm running into a little difficulty performing a query that I think
    comes up often enough that it should be fairly straightforward.

    I have a schema similar to the following:

    Customer <--- BillingInfo <--- Order

    I've mapped the read-only relationship "orderHistory" from Customer to
    Order.

    Now I'd like to perform two queries. One for customers with orders and
    one for customers without. I'd rather not filter in the app itself
    because I'd like to paginate the result lists.

    Is there a way to do this without resulting to an SQLTemplate query?

    Thanks,
    Kevin 

    -- 
Kevin Menard
Servprise International, Inc.
Remote reboot & power control for your network
www.servprise.com                  +1 508.892.3823 x308

    This archive was generated by hypermail 2.0.0 : Wed Feb 20 2008 - 20:06:33 EST