Thanks for the quick response, but exactly here lies my problem: (1) "The contains() operator also performs multiple queries," (2) "...the contains() filter is replaced with an equal-to filter. The results are merged, in the order of the items in the list" (3) "A single query containing != or contains() operators is limited to 30 sub-queries." (4) i want to query primary-key using indexes
e.g. tsql: select * from tab where key in [0,1,2,3,4,5,....100,103,105,999] order by anything desc // one single query that uses the index well I have created a keyword table, where every keyword "points" via a List<Key> to maybe hundreds of records. Whenever a keyword is clicked (e.g. in a tagcloud) I want to retrieve all of the items specified by the key-list with one query and I need the list to be sorted by the property the user wishes to. I could retrieve any single object, add it to the list and implement sortable to sort by different columns and directions. But this is not comfortable and my App is still using enough CPU-Time. Any suggestions or Ideas how someone of you might have faced a similar problem? best regards alex On Mar 8, 3:39 am, Karel Alvarez <[email protected]> wrote: > Hi, > there is an example in this > page:http://code.google.com/appengine/docs/java/datastore/queriesandindexe... > > look for the "contains()" > > thanks > Karel > > On Sun, Mar 7, 2010 at 2:19 AM, Alexander Lagler > > <[email protected]> wrote: > > hi, > > > can you tell me how to query datastore in java with an KEYLIST by > > using > > List<myclass> mylist = (List<myclass>)query.execute(LIST OF KEYS); > > > i do not want to use > > pm.getObjectsById(List<Object>) > > because i want to use both 'setOrdering()' and 'setRange()' > > > couldnt find something on the web, so any information and/or > > codeexample would be great! > > > thx in advance > > alex > > > -- > > You received this message because you are subscribed to the Google Groups > > "Google App Engine for Java" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group > > athttp://groups.google.com/group/google-appengine-java?hl=en. -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
