Re: [appengine-java] Re: no matching index found..

2010-09-27 Thread Cyrille Vincey
My pleasure On 27/09/10 16:24, "Prateek" wrote: >Hi Cyrille , > >I had the datastore-indexes-auto.xml , but not the datastore- >indexes.xml. > >Adding datastore-indexes.xml solved my problem. > >Thanks a lots buddy. > >Regards >Prateek Agarwal > >On Sep 27, 1:21 pm, Cyrille Vincey wrote: >> The

[appengine-java] Re: no matching index found..

2010-09-27 Thread Prateek
Hi Cyrille , I had the datastore-indexes-auto.xml , but not the datastore- indexes.xml. Adding datastore-indexes.xml solved my problem. Thanks a lots buddy. Regards Prateek Agarwal On Sep 27, 1:21 pm, Cyrille Vincey wrote: > The GAE Eclipse plugin is supposed to create all required indexes in

[appengine-java] Re: no matching index found..

2010-09-27 Thread Prateek
Hi Cyrille , The File exist in my directory, as well as the indexes is also included in my datastore-indexes.xml. It works fine locally but when deployed @ GAE it gives that particular error. no matching index found.. On Sep 27, 1:21 pm, Cyrille Vincey wrote: > The GAE Eclip

[appengine-java] Re: no matching index found error while using 'Not Equal To' with 'And' operator

2010-08-02 Thread Stephen Johnson
Subhash, Here's a clip from the relevant portion of the Docs regarding index order: An index table contains columns for every property used in a filter or sort order. The rows are sorted by the following aspects, in order: * ancestors * property values used in equality filters * prope

[appengine-java] Re: no matching index found error while using 'Not Equal To' with 'And' operator

2010-08-02 Thread Stephen Johnson
Sorry, I meant: Thus you need an INDEX ordered by name then age because the equality COLUMNS need to proceed the inequality COLUMNS in the index. (Didn't have my coffee yet). So, my guess would be that your second query: On Aug 2, 9:37 am, Stephen Johnson wrote: > Hi Subhash, > The first query

[appengine-java] Re: no matching index found error while using 'Not Equal To' with 'And' operator

2010-08-02 Thread Stephen Johnson
Hi Subhash, The first query gets translated into two queries: Select * From User Where userName = 'sachin' And age < '20' and Select * From User Where userName = 'sachin' And age > '20' Thus you need a query ordered by name then age because the equality filters need to proceed the inequali