I have a search page that ultimately uses Hibernate's Query by criteria and query by example. However, the search is supposed to allow for a range, a start and end date, if you will.

So my question is two fold. How does one use a Date in QBC/QBE and how does one express a range using a between ala' for Y, y is between x and z or X<=Y<=Z so I can find all Y's that fall between X and Z

Thanks!

David

Have you tried something like


Erik

You put me on the right path. Here is what basically worked

Criteria searchCriteria = session.createCriteria(RevisionData.class);

searchCriteria.createCriteria("correspondence").add(Expression.between("dateReceived",
search.getCorrespondenceStartDateRange(),
search.getCorrespondenceEndDateRange()));

where I had a RevisionData class that contains a Correspondence class and I wanted to find all revisions with a correspondece that fell between two dates.

Thanks!

And for anyone with Hibernate in Action, check page 254