[jira] [Created] (ISIS-1673) jdoqlFromClause validator is too strict, does not allow for NOT EXISTS

[Dan Haywood (JIRA)]

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)