NOT IN sql-like query google app engine not working

Question

how to turn this:

Contact.gql('WHERE email IN :1', emails)

emails is a list of emais like: ["foo@example.com", "foo2@example.com"]

into this:

Contact.gql('WHERE email NOT IN :1', emails)

it raises an error:

BadQueryError: Parse Error: Invalid WHERE Condition at symbol NOT

the answer is here http://stackoverflow.com/questions/3807591/how-to-construct-gql-to-not-contain-a-value-from-a-set — pahko, Mar 08 '13 at 18:28

score 4 · Answer 1 · answered Mar 08 '13 at 19:09

4

It's not that it's not working, it's that you're trying something that isn't supported.

answered Mar 08 '13 at 19:09

Dave W. Smith

1 Answers1