[ 
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)

Reply via email to