Forming a GQL query with != not equals

Question

I am trying to form a GQL query that:

SELECT * FROM IvlsRun where origInstrument = 'Catalyst_Dx' and practiceId != '100004'

Finds all IvlsRun(s) where the origInstrument = 'Catalyst_Dx'... but I don't want any of them with practiceId = 10004.

Everytime I add the practiceId != 100004 or practiceId != '100004' I get an error.

I am new to GQL. I am doing this through the datastore viewer.

The error is pretty basic, telling me I don't know how to use GQL:

Learn more about GQL syntax. no matching index found.

The error is pretty basic, telling me I don't know how to use GQL: Learn more about GQL syntax. no matching index found. — user1981068, Jan 15 '13 at 17:11
To get around this I am simply specifying alternate practiceId(s) instead of trying to NOT EQUALS the one I don't want. This is working for now. — user1981068, Jan 15 '13 at 17:18

score 2 · Answer 1 · answered Jan 15 '13 at 19:43

2

You must define custom index when you use query with one or more inequality filters on a property and one or more equality filters on other properties. See Index Configuration.

answered Jan 15 '13 at 19:43

Peter Knego

79,991
11
123
154

Forming a GQL query with != not equals

1 Answers1