[ https://issues.apache.org/jira/browse/ISIS-1673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dan Haywood updated ISIS-1673: ------------------------------ Summary: [CAN'T REPRODUCE] jdoqlFromClause validator is too strict, does not allow for NOT EXISTS (was: jdoqlFromClause validator is too strict, does not allow for NOT EXISTS) > [CAN'T REPRODUCE] jdoqlFromClause validator is too strict, does not allow for > NOT EXISTS > ---------------------------------------------------------------------------------------- > > Key: ISIS-1673 > URL: https://issues.apache.org/jira/browse/ISIS-1673 > Project: Isis > Issue Type: Improvement > Affects Versions: 1.14.0 > Reporter: Dan Haywood > Assignee: Dan Haywood > Priority: Minor > Fix For: 1.15.0 > > > For example: > {code} > @Query( > name = > "findNotInAnyPaymentBatchByApprovalStateAndPaymentMethod", language = "JDOQL", > value = "SELECT " > + "FROM org.estatio.capex.dom.invoice.IncomingInvoice > " > + "WHERE !(SELECT invoice " > + " FROM > org.estatio.capex.dom.payment.PaymentLine).contains(this) " > + " && approvalState == :approvalState " > + " && paymentMethod == :paymentMethod " > + "ORDER BY invoiceDate ASC " // oldest first > ), > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)