Arangodb AQL is like NOT IN SQL

Question

How to do FILTER

like this SQL example in AQL?

SELECT * FROM test WHERE option NOT IN ('A', 'B', 'C')

+3

Tarsis 06 Aug 14 at 18:05

1 answer

stj · Accepted Answer · 2014-08-07T08:00:06+0000

In v2.3 and higher you can do:

FOR doc IN test 
  FILTER doc.option NOT IN [ 'A', 'B', 'C' ]
  RETURN doc

In earlier versions, the following should work:

FOR doc IN test 
  FILTER ! (doc.option IN [ 'A', 'B', 'C' ])
  RETURN doc