app engine query filter by 'id' range of entities, ignoring ancestor(s)

I have entities like these ones:

Entity [products(147)]

Entity [manufacturer(23)/products(131)]

Entity [manufacturer(17)/products(131)]

Now, I'm trying to find using a Query all the entities of kind 'products' which have an ID from 100 and up. Ones like the above 147 & 131.

The problem is that I don't know how to ask for these, "detaching" the ancestor from it in the query.

Tried these:

Not working:

SELECT __key__ FROM products WHERE ID >= 100

Partially working:

SELECT __key__ FROM products WHERE __key__ >= 100

This is how I insert the query filter:

query.addFilter("__key__",开发者_如何学编程 FilterOperator.GREATER_THAN_OR_EQUAL, KeyFactory.createKey("products", 100));

This partially working one gives the proper results ONLY for 'root' entities, i.e ones without an ancestor.

Any way to modify it so it ignore ancestor(s)? Thanks!

There's no built in way to do this, because this query is meaningless. IDs are allocated such that they are unique for a given kind and parent. You can't rely on IDs alone to uniquely identify an entity if it might have different parent entities, so it's pretty meaningless to query for a range of IDs regardless of parent.