Don't you know the function lower or upper in java and sql :
lower("Adam") = "adam"
uper("Adam") = "ADAM"
Ah, such lower You can currently only do it as a projection; there's no API to add such a function to the where clause.
sorry for my question, but can you give me a sample code ?
Acually, i am doing this :
Number revisionMax = reader.getRevisionNumberForDate(SearchDate);
AuditQuery query = reader.createQuery().forEntitiesAtRevision(Enterprise.class,revisionMax);
but this code is case sensitive.
How can i apply a lower function on my property "denomination" ?
Thanks a lot for your help.
As I wrote above there's no option yet to add a lower to the where cause of a query.