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
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
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