[appengine-java] Re: how should I design my data model for following scenario

2010-07-12 Thread pac
Another way I can think of divide the kind and do some form of keys only query on ItemIndex and transform them to parent keys (http:// www.youtube.com/watch?v=AgaL6NGpkB8) and then filter in memory as per invoiceDate? But this way I may end fetching lots of invoices which do not meet criteria, any

[appengine-java] Re: how should I design my data model for following scenario

2010-07-11 Thread Parvez
Thanks Robert. I don’t think that will solve it. I think text search could have solved it easily, which is not in at the moment, unfortunately. If I design it something like this (Item as concatenated strings of items separated by a space): InvoiceNo Item InvoiceD

[appengine-java] Re: how should I design my data model for following scenario

2010-07-11 Thread Robert Lancer
I dont fully understand the problem, but you might want to look into using the IN filter option that can take a list of items and return the associated entities, if the list is small enough you can cook up the set operations in memory. On Jul 11, 6:58 am, Parvez wrote: > I want retrieve invoice