CODEWITHSUNDEEP
google-app-enginegoogle-cloud-datastore
JR Galia
JR Galia

Reputation: 17269

Inequality Filter in AppEngine Datastore

I understand that Google AppEngine supports only one inequality filter per query. What are the workaround on this limitation? Are there any solution that will provide similar effect?

Upvotes: 7

Views: 2992

Answers (3)

alexey28
alexey28

Reputation: 5230

When I meat this problem (example searching range from - to) I use query with single inequality filter. Depending on sorting order (asc or desc) I select upper or bottom limit. After that I filter result programatically with bottom or upper limit that was not in query filter.

Upvotes: 0

Peter Knego
Peter Knego

Reputation: 80340

Actually GAE supports multiple inequality filters as long as they are on the same property.

The workarounds to this limitation are data-specific, e.g. it depends how your data is structured and how you want to query it. For example, for geo searching, as @Dan Holevoet mentioned, there are various geo-hashing algorithms. Basically all such algorithms involve combining multiple properties into one and at the same time quantizing the property (creating discrete values). For example geo-hashing involves dividing up the world map into small fixed-size areas (= combining lat/lon and quantizing) in order to be able to search via equality operator.

Upvotes: 3

Dan Holevoet
Dan Holevoet

Reputation: 9183

Whether there is a workaround for having a single inequality filter per query depends on the type of dataset you are querying over.

For instance, if you wanted to query positional data using a latitude and longitude address, you'd typically need to query for a range of values on two properties (lat and long). However, with a geohash algorithm you can accomplish an equivalent query using only a single property.

Upvotes: 1

Related Questions