[ https://issues.apache.org/jira/browse/ISIS-1673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dan Haywood resolved ISIS-1673.
-------------------------------
Resolution: Cannot Reproduce
> [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)