According to the Wikipedia article on Google App Engine:
The where clause of select statements can perform >, >=, <, <= operations on one column only. Therefore, only simple where clauses can be constructed.
What does this mean?
According to the Wikipedia article on Google App Engine:
The where clause of select statements can perform >, >=, <, <= operations on one column only. Therefore, only simple where clauses can be constructed.
What does this mean?
Sounds to me like you can't compare two columns to each other: WHERE Column1 > Column2
wouldn't work for example.
Google explains it in their article on querying the App Engine datastore. Look for the bulleted list titled, "The filter operator can be any of the following:"
See this document:
For example, this query is allowed:
select from Person where birthYear >= minBirthYearParam
&& birthYear <= maxBirthYearParam
However, this query is not allowed, because it uses inequality filters on two different properties in the same query:
select from Person where birthYear >= minBirthYearParam
&& height >= minHeightParam // ERROR