CreateCriteria on more than one table

[Jayanthisri]

Hi ,

I have a hibernate createCriteria as follows:

Criteria criteria = getSession().createCriteria(OfferCredit.class);
                criteria.createCriteria("offer").add(
                                Restrictions.eq("status", LeverageUtils.ACTIVE_STATUS)).add(
                                Restrictions.ge("expirationDate", new Date()));
                criteria.createCriteria("user").add(Restrictions.eq("userId", userId));
                criteria.add(Restrictions.eq("status", LeverageUtils.ACTIVE_STATUS));
                criteria.addOrder(Order.asc("creationDate"));
                list = criteria.list();


     where OfferCredit, Offer and User are tables. I want the OfferCredit if the offer  in Offer table is active  and the user in User table is active.(OfferCredit table has offer and user but has no reference if they are active.So i need to check with offer and user table)

My OfferCredit.groovy has User and Offer

Please help me with creating criteria(in grails) same as above.

[MikeHugo]

It would be something like this:

def criteria = OfferCredit.createCriteria {
        offer {
                eq('status', LeverageUtils.ACTIVE_STATUS)
                ge('expirationDate',new Date())
        }
        user {
                eq('userId', userId)
        }
        eq(''status', LeverageUtils.ACTIVE_STATUS)
        order('creationDate', 'asc')
}

criteria.list()

See http://grails.org/doc/1.0.x/guide/5.%20Object%20Relational%20Mapping%20(GORM).html#5.4.2%20Criteria 
  for more details


On May 7, 2008, at 1:38 AM, Jayanthisri wrote:

>
> Hi ,
>
> I have a hibernate createCriteria as follows:
>
> Criteria criteria = getSession().createCriteria(OfferCredit.class);
> criteria.createCriteria("offer").add(
> Restrictions.eq("status", LeverageUtils.ACTIVE_STATUS)).add(
> Restrictions.ge("expirationDate", new Date()));
> criteria.createCriteria("user").add(Restrictions.eq("userId",  
> userId));
> criteria.add(Restrictions.eq("status",  
> LeverageUtils.ACTIVE_STATUS));
> criteria.addOrder(Order.asc("creationDate"));
> list = criteria.list();
>
>
>     where OfferCredit, Offer and User are tables. I want the  
> OfferCredit if
> the offer  in Offer table is active  and the user in User table is
> active.(OfferCredit table has offer and user but has no reference if  
> they
> are active.So i need to check with offer and user table)
>
> My OfferCredit.groovy has User and Offer
>
> Please help me with creating criteria(in grails) same as above.
>
>
> --
> View this message in context: http://www.nabble.com/CreateCriteria-on-more-than-one-table-tp17098332p17098332.html
> Sent from the grails - dev mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe from this list, please visit:
>
>    http://xircles.codehaus.org/manage_email
>
>

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

[Jayanthisri]

Thanks !

Jayanthisri wrote:

Hi ,

I have a hibernate createCriteria as follows:

Criteria criteria = getSession().createCriteria(OfferCredit.class);
                criteria.createCriteria("offer").add(
                                Restrictions.eq("status", LeverageUtils.ACTIVE_STATUS)).add(
                                Restrictions.ge("expirationDate", new Date()));
                criteria.createCriteria("user").add(Restrictions.eq("userId", userId));
                criteria.add(Restrictions.eq("status", LeverageUtils.ACTIVE_STATUS));
                criteria.addOrder(Order.asc("creationDate"));
                list = criteria.list();


     where OfferCredit, Offer and User are tables. I want the OfferCredit if the offer  in Offer table is active  and the user in User table is active.(OfferCredit table has offer and user but has no reference if they are active.So i need to check with offer and user table)

My OfferCredit.groovy has User and Offer

Please help me with creating criteria(in grails) same as above.