[CAUSEWAY-1673] [CAN'T REPRODUCE] jdoqlFromClause validator is too strict, does not allow for NOT EXISTS

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Cannot Reproduce
• Affects Version/s: 1.14.0
• Fix Version/s: 1.15.0
• Assignee: Daniel Keir Haywood
• Reporter: Daniel Keir Haywood
• Created: 31/Jul/17 14:09
• Updated: 14/Aug/17 19:00
• Resolved: 31/Jul/17 14:30

Description

For example:

@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
        ),