Arangodb AQL similar to NOT IN of SQL

Question

How to do a FILTER like this SQL example in AQL?

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

Answer 1

In v2.3 and above, it is possible to 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