Hibernate criteria and/or with many-to-many

Question

This is the query i'm running:

    List<Coupon> coupons = getDb().createCriteria(Coupon.class)
    .add(Restrictions.le("validFrom", startTime.getTime()))
    .add(Restrictions.ge("validUntil", startTime.getTime()))
    .add(Restrictions.eq("user", user))
    .createAlias("spots", "spotsAlias")
    .add(Restrictions.or(
            Restrictions.eq("isGlobal", true),
            Restrictions.eq("spotsAlias.id", spot.getId())
            ))
    .add(Restrictions.eq("isRedeemed", false))
    .add(Restrictions.eq("isDeleted", false))
    .add(Restrictions.eq("isActive", true))
    .addOrder(Order.asc("isGlobal"))
    .addOrder(Order.desc("validFrom"))
    .list();

it's supposed to get all coupons that are:

valid at startTime
related to user
global or related to a specific spot
not redeemed
not deleted
activated

the coupons are in many-to-many relationship with spots. the relationship works - this query does return coupons that are specifically related to the queried spot. Unfortunately, it never returns global coupons, even when there are no "local" coupons in the database at all.

Any suggestions? help will be very much appreciated!

try using disjunction()? – user3487063 Aug 07 '14 at 14:13 — user3487063, Aug 07 '14 at 14:13

user3487063 · Answer 1 · 2014-08-07T14:48:05.783

0

Try using disjunction and see:

 .add( Restrictions.disjunction().add(Restrictions.eq("global", Boolean.TRUE))
                              .add(Restrictions.eq("spotsAlias.id", spot.getId())))

Also if global is a property in your Entity, then you need to use :

Restrictions.eq("global", Boolean.TRUE)

Also if you refer to Restrictions class, it has only

eq(String propertyName, Object value)

method which takes object as second parameter and not a primitive type.

edited Aug 07 '14 at 14:48

answered Aug 07 '14 at 14:17

user3487063

3,672
1
17
24

no. still the same result. doesn't return coupons with isGlobal=true. – Octavio Ben-Aharon Aug 07 '14 at 14:28
is global a property in your entity? – user3487063 Aug 07 '14 at 14:30
"could not resolve property: global of: com.pinkpark.model.Coupon" – Octavio Ben-Aharon Aug 07 '14 at 14:38
yes please use (propertyName, object) in all your restrictions and your Order.asc(propertyName) / Order.desc(propertyName) – user3487063 Aug 07 '14 at 14:41
do you have Boolean.TRUE in place of true?, rightnow you are passing in primitive types to a method that accepts objects as second parameter. – user3487063 Aug 07 '14 at 15:53

Hibernate criteria and/or with many-to-many

1 Answers1