-
1. Re: lower with envers criteria
adamw Aug 30, 2011 11:14 AM (in response to desol4tion)What's "lower"?
Adam
-
2. Re: lower with envers criteria
desol4tion Aug 30, 2011 11:24 AM (in response to adamw)Don't you know the function lower or upper in java and sql :
lower("Adam") = "adam"
uper("Adam") = "ADAM"
-
3. Re: lower with envers criteria
adamw Sep 6, 2011 10:56 AM (in response to desol4tion)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.
Adam -
4. Re: lower with envers criteria
pims2lu May 10, 2012 9:52 AM (in response to desol4tion)Hello,
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);
query.add(AuditEntity.property("denomination").eq(denomination));
but this code is case sensitive.
How can i apply a lower function on my property "denomination" ?
Thanks a lot for your help.
-
5. Re: lower with envers criteria
adamw May 23, 2012 6:09 AM (in response to pims2lu)As I wrote above there's no option yet to add a lower to the where cause of a query.
Adam