Closed dynamobi-build closed 12 years ago
[author="jvs", created="Mon, 28 May 2007 10:19:48 -0500 (GMT-05:00)"]
Implemented in eigenchange 9349. In keeping with LURQL's clunky syntax conventions, you can only put NOT in front of an existing predicate, and you can't parenthesize yet. So the following will work:
WHERE NOT x IN ...
WHERE NOT x = 'foo'
WHERE NOT EXISTS p in (....
WHERE x='foo' AND NOT y = 'bar'
But the following will not:
WHERE x NOT IN ...
WHERE x = 'foo' AND NOT (y='bar')
LURQL doc with updated grammar will be published soon.
[reporter="jvs", created="Fri, 20 Oct 2006 19:00:23 -0500 (GMT-05:00)"] NOT EXISTS and NOT IN would be especially useful