CODEWITHSUNDEEP
javahibernate
Edgaras Karka
Edgaras Karka

Reputation: 7852

Java hibernate. How to get a entity where a date field is oldest using the criteria?

I have entity DataStatus with the field date.

My goal is get the oldest row by date field.

public DataStatus getOldest(){
    Criteria criteria = session.createCriteria(DataStatus.class);
    criteria.add(Restrictions.eq("date", MIN));
    List<DataStatus> results = criteria.list();
    if(results.size()<1)return null;
    return results.get(0);
}

Upvotes: 1

Views: 1294

Answers (1)

czpona
czpona

Reputation: 320

User order by mechanism from criteria API

CriteriaQuery<DataStatus> q = cb.createQuery(DataStatus.class);
Root<DataStatus> c = q.from(DataStatus.class);
q.select(c);
q.orderBy(cb.asc(c.get("date")));

Upvotes: 1

Related Questions