Following code working in cuba is not working in jmix -
List<ComplianceTask> list = dataManager.load(ComplianceTask.class) .query("select o from com_ComplianceTask o where EXTRACT(YEAR FROM o.dueDate) =:myYear") //.fetchPlan("complianceMonitoring-view") .parameter("myYear", fromYear) .list();
tp = dataManager.loadValue(
“select count(o.id) from com_ComplianceTask o where o.status = ‘NEW’ and @between(o.dueDate, now, now+7, day)”, Integer.class)
.one();
shows error after EXTRACT. and before @between
Please Advice