Hi,
Discounts can change daily. Also there can be a lot of them (over time and
in a given time period ).
Could you give an example of what you mean buy multi-valuing the field.
Thanks
On 3 June 2011 14:29, Erick Erickson <erickerick...@gmail.com> wrote:
> How often are the discounts changed? Because you can simply
> re-index the book information with a multiValued "discounts" field
> and get something similar to your example (&wt=json)....
>
>
> Best
> Erick
>
> On Fri, Jun 3, 2011 at 8:38 AM, Judioo <cont...@judioo.com> wrote:
> > What is the "best practice" method to index the following in Solr:
> >
> > I'm attempting to use solr for a book store site.
> >
> > Each book will have a price but on occasions this will be discounted. The
> > discounted price exists for a defined time period but there may be many
> > discount periods. Each discount will have a brief synopsis, start and end
> > time.
> >
> > A subset of the desired output would be as follows:
> >
> > .......
> > "response":{"numFound":1,"start":0,"docs":[
> > {
> > "name":"The Book",
> > "price":"$9.99",
> > "discounts":[
> > {
> > "price":"$3.00",
> > "synopsis":"thanksgiving special",
> > "starts":"11-24-2011",
> > "ends":"11-25-2011",
> > },
> > {
> > "price":"$4.00",
> > "synopsis":"Canadian thanksgiving special",
> > "starts":"10-10-2011",
> > "ends":"10-11-2011",
> > },
> > ]
> > },
> > .........
> >
> > A requirement is to be able to search for just discounted publications. I
> > think I could use date faceting for this ( return publications that are
> > within a discount window ). When a discount search is performed no
> > publications that are not currently discounted will be returned.
> >
> > My question are:
> >
> > - Does solr support this type of sub documents
> >
> > In the above example the discounts are the sub documents. I know solr is
> not
> > a relational DB but I would like to store and index the above
> representation
> > in a single document if possible.
> >
> > - what is the best method to approach the above
> >
> > I can see in many examples the authors tend to denormalize to solve
> similar
> > problems. This suggest that for each discount I am required to duplicate
> the
> > book data or form a document
> > association<http://stackoverflow.com/questions/2689399/solr-associations
> >.
> > Which method would you advise?
> >
> > It would be nice if solr could return a response structured as above.
> >
> > Much Thanks
> >
>
