Would having a solr-document represent a 'product purchase per account' solve your problem? You could then easily link the date of purchase to the document as well as the account-number.
e.g: fields: orderid (key), productid, product-characteristics, order-characteristics (including date of purchase). or in case of option of multiple products having a joined orderid: fields: cat(orderid,productid) (key), orderid, productid, product-characteristics, order-characteristics (including date of purchase). The difference to your setup (i.e: one document per account) is that the suggested setup above may return multiple documents when you search by account-nr, which may or may not be what you're after. hth, Geert-Jan 2011/3/9 dan whelan <d...@adicio.com> > Hi, > > I'm investigating how to set up a schema like this: > > I want to index accounts and the products purchased (multiValued) by that > account but I also need the ability to search by the date the product was > purchased. > > It would be easy if the purchase date wasn't part of the requirements. > > How would the schema be designed? Is there a better approach? > > Thanks, > > Dan > >
