Hi Andrus,I have tested with Cayenne 3.0M4 and there is a bug transforming an expression into EJBQL :
I created a ticket : https://issues.apache.org/cayenne/browse/CAY-1073
ExpressionFactory.notInExp(DailyJob.DEPARTMENT_ID_PROPERTY, departmentIds);
---> "SMASTER.DEPTID not in (1, 2)"
Then i transform it to EJBQL with Expression.toEJBQL("a")
---> "a.departmentId not in ()"
the IN clause is empty.
Thanks.
Laurent Marchal.
