Dan Haywood created ISIS-1673: --------------------------------- Summary: 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)