Hi Mike!
I have tried with:
Expression expDate = ExpressionFactory.exp("modifiedDate>
TO_DATE('2003-07-17','yyyy-mm-dd')");
but I get this exception:
Caused by: org.apache.cayenne.exp.ExpressionException: [v.4.2.M1 Nov 26 2020
09:20:26] Encountered " "(" "( "" at line 1, column 22.
Was expecting one of:
<EOF>
"or" ...
"and" ...
"|" ...
"^" ...
"&" ...
"<<" ...
">>" ...
"+" ...
"-" ...
"/" ...
"*" ...
and I really would want to have all my expression in one string, without use
greaterExp.
Like this:
Expression exp = ExpressionFactory.exp("businessPartnerName='andrea' and
businessPartnerCode!='rossi' or ((businessPartnerCode!='bianchi' and
maxAdvancePaymentPercent>9) or businessPartnerCode!='pippo' or
(maxAdvancePaymentPercent>100 or maxAdvancePaymentPercent<10)) and
modifiedDate> TO_DATE('2003-07-17','yyyy-mm-dd')");
But maybe it is not possible.
Andrea
On 2021/01/02 12:45:49, Mike Kienenberger <[email protected]> wrote:
> Oracle expects SQL like the following to compare dates.
>
> MODIFIED_DATE > TO_DATE('2003-07-17','yyyy-mm-dd')
>
> You either need to use that in your exp() method, or use greaterExp(),
> which can automatically generate the needed sql for the current database.
>
> Date date = new GregorianCalendar(2003, Calendar.JULY,
> 17).getTime() ;
> Expression matchDateGreaterThanDate1 =
> ExpressionFactory.greaterExp("MODIFIED_DATE", date);
>
>
>
>
> On Sat, Jan 2, 2021 at 3:45 AM Andrea Biasillo <[email protected]> wrote:
>
> > Hi!
> >
> > Is it possible to use Date values in ExpressionFactory.exp?
> >
> > This works very well:
> >
> > Expression exp = ExpressionFactory.exp("businessPartnerName='andrea' and
> > businessPartnerCode!='rossi' or ((businessPartnerCode!='bianchi' and
> > maxAdvancePaymentPercent>9) or businessPartnerCode!='pippo' or
> > (maxAdvancePaymentPercent>100 or maxAdvancePaymentPercent<10))");
> >
> > but if I use a Date value like this:
> >
> > Expression expDate = ExpressionFactory.exp("modifiedDate> '2003-07-17'");
> >
> > The database, Oracle in my case, will complain:
> >
> > Literal does not match format string
> > (the database expects something like this: MODIFIED_DATE > DATE
> > '2003-07-17')
> >
> > Any input?
> >
> > Andrea
> >
> >
> >
> >
> >
> >
>
