Re: getArray matching specific criteria?

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed May 28 2008 - 12:37:32 EDT

  • Next message: Andrey Razumovsky: "LEFT JOIN avaliable?"

    Hi there,

    you need an expression matching on relationship. E.g:

    ExpressionFactory.matchExpression("master", masterObject);

    where "master" is the name of relationship.

    Andrus

    On May 28, 2008, at 4:45 PM, Garcia Corral, Josep wrote:

    > Hello,
    >
    > Having this:
    >
    > Class Master {
    > int id;
    > ...
    > };
    >
    > Class Detail {
    > int id_master;
    > ...
    > String data;
    > };
    >
    > I cannot figure out how to perform a SelectQuery to obtain detail
    > records matching a condition, equivalent to a pseudocode SQL
    > sentence like this:
    >
    > Select Detail.* from Detail, Master where Detail.id_master =
    > myMasterInstance_id and data = other_value;
    >
    > In pseudocode Java, I would like to have:
    >
    > Master myMaster;
    > ...
    > List<Detail> list = myMaster.getDetailArray( data field matching
    > specific criteria);
    >
    > Is it a good practice to do it via SelectQuery, or is it better to
    > do this via SQLTemplate?
    >
    > Josep
    >



    This archive was generated by hypermail 2.0.0 : Wed May 28 2008 - 12:38:07 EDT