To-many relationship while specifying additional constraints?

From: Jeff de Vries (jdevrie..frog.com)
Date: Thu Sep 15 2005 - 13:08:18 EDT

  • Next message: Gili: "Feedback regarding Cayenne vs Hibernate"

    I have a to-many relationship which has hundreds of related objects. I
    almost never want to fetch all of them, but I frequently want to fetch
    some subset of them. While I can use a SelectQuery to get want I want,
    I have to manually specify all the join conditions that normally
    Cayenne's to-many handling would do automatically for me. What I was
    thinking is that it would be nice if there were some additional methods
    similiar to the following:

    List getFooArray(); // already have this ...
    List getFooArray(Expression e); // just like above, but tacks the
    expression, e, on to the automatically generated query that includes the
    join constraints, so I can retrieve a subset of the objects in the
    to-many relationship
    List getFooArray(Expresion e, Ordering o); // like above, but adds an
    ORDER BY clause ... just wishing.

    So, I guess this is really more of a "feature request" rather than a
    question, although if someone already knows how to do this with the
    existing system I'd like to hear about it.

    Thanks,
    Jeff de Vries

    This archive was generated by hypermail 2.0.0 : Thu Sep 15 2005 - 13:08:24 EDT