Where is the annotation in sleep mode with the date as a condition

Question

I was wondering if there is a way to use @Where(clause="")a set of things to bind to where is_active=1 AND expires_date <= new Date()in relation @OneToMany.

Something like that

@Where(clause="is_active=1 AND expires_date <=" + new Date())

Or can you only do this with constants?

This code will not work only for job search or if there is a way to do it. Thanks in advance.

Answer 1

@Where.clause , .
- / , , filter, .
, - ; , .

Answer 2

, . , .

Calendar rightNow = Calendar.getInstance();
Criteria criteria = session.createCriteria(yourclassname.class);
criteria.add(Restrictions.eq("is_active", 1));
criteria.add(Restrictions.le("expires_date", rightNow));

Answer 3

, , sql, current_date postgresql:

@Where(clause="is_active=1 AND expires_date <= current_date")