In the generated SQL? I don't think that's possible yet. Please file a JIRA feature request.
I have accomplished the same by adding two times the date proerty as ge and also le of the date.
Again one more issue in my case is, can i somehow pass in my query builder to take the maximum value of the revision along with my where clause?
Is there a way to get the result based on the maximum of the revision number?
You want to find the maximum revision number? Try adding a projection: AuditEntity.revisionNumber().max()
Thanks Adam , the same worked.