AppEngine GqlQuery (WHERE NOT)

Question

I want to find all employees from a company where the telephone number is NOT empty.

Now I have this:

db.GqlQuery('SELECT * FROM Employee '
       'WHERE company = :company '
       'AND phone > :nophone', company=company, nophone=None)

But this always prints out empty results although there are items with telephone number.

Does the same query without the filter on 'phone' return any results? Can you provide the model definition and some sample data? — Nick Johnson, Nov 19 '10 at 04:47

score 0 · Accepted Answer · edited Jul 14 '12 at 03:11

0

try to use

db.GqlQuery('SELECT * FROM Employee  '
  'WHERE company = :company '
  'AND phone != :nophone', company=company, nophone=None)

1 Answers1