java - Google Cloud Datastore - Inequality returning "no matching index found" -

-

in android studio, i'm trying use google clood datastore android app.

with google example https://cloud.google.com/datastore/docs/concepts/indexes#datastore_indexes_and_properties able add tom (32 years old) , lucy (30 years old) person , children of company acme. can see these 2 entries in datastore in google developers console.

  • i can retrieve children company acme if set query filter below.

    key acmekey = makekey("company", "acme").build(); makefilter("__key__",     propertyfilter.operator.has_ancestor,     makevalue(acmekey)).build()));
    • if want retrieve person age equal 32 add filter above makefilter("age", propertyfilter.operator.equal, makevalue(32)).build() then, person tom.
  • but, if, instead of operator.equal put inequality filter operator.less_than or operator.greater_than error "no matching index found".

i think it's problem of indexes, don't understand how can set index. use android studio , don't use @ app engine. want retrieve data mysql simple where age > 32.

btw, tried gql , exact same problem, work equal, not greater_than (and same in https://developers.google.com/apis-explorer).

so, know how can fix problem ? !!

index configuration cloud datastore handled using gcd.sh tool.

it's easiest if you're able run queries against local datastore provided gcd.sh. tool can determine indexes you'll need, , can use updateindexes command configure them on production app.

if not, can configure indexes hand:

  1. gcd.sh create <project> -d <project>
  2. create file @ <project>/web-inf/datastore-indexes.xml following content:

<?xml version="1.0" encoding="utf-8"?> <datastore-indexes autogenerate="true"> <datastore-index kind="company" ancestor="true"> <property name="age" direction="asc" /> </datastore-index> </datastore-indexes>

  1. gcd.sh updateindexes <project>

the exact content of file depend on queries want run. this page gives additional details on format of indexes file.


Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

how does one get csharp-sqlite to throw exceptions for duplicates or foreign key constraint violations -

-
i making use of csharp-sqlite. in sqlite database have uniqueness , foreign key constraints. when write "duplicate" table exception not raised , way found check exception use following: var error = sqlitecommand.getlasterror(); i hoping able following: var sqlstring = "some insert sql"; var command = sqlitecommand(sqlstring); command.parameters.add(... parameter...); using (var sqlconnection = new sqliteconnection(connectionstring)) { try { command.executenonquery(); } catch (exception ex) { exception } { sqlconnection.close(); } } the "catch" block never hit, though var error = sqlitecommand.getlasterror(); does return description of error expecting. have idea how solve this, or standard practice using csharp-sqlite library?
Read more

Simple Angular 2 project fails 'Unexpected reserved word' -

-
i trying create simple angular2 project based on ng2do project. using quickstart , have following code... <script src="js/quickstart/dist/es6-shim.js"></script> .... import {component, template, bootstrap, foreach} 'js/quickstart/angular2/angular2'; this gives me following error... uncaught syntaxerror: unexpected reserved word what missing? don't know if helps have been having issues day realised because starting code script reference <script src="app.js"> </script> instead of using <script> system.import('app'); </script> hope helps using in tsconfig { "version": "1.5.0-beta", "compileroptions": { "target": "es6", "module": "amd", "declaration": false, "noimplicitany": false, "removecomments": true, "nolib": fal...
Read more