Hi Mikhail, I read the article and can't see how to solve my problem with FieldCollapsing.
Any other suggestions? Torben Am 04.10.2012 um 17:31 schrieb Mikhail Khludnev: > it's a typical nested document problem. there are several approaches. Out > of the box solution as far you need facets is > http://wiki.apache.org/solr/FieldCollapsing . > > On Thu, Oct 4, 2012 at 7:19 PM, Torben Honigbaum < > torben.honigb...@neuland-bfi.de> wrote: > >> Hi Jack, >> >> thank you for your answer. The problem is, that I don't know the value for >> option A and that the values are numbers and I've to use the values as >> facet. So I need something like this: >> >> Docs: >> >> <doc> >> <str name="id">3</str> >> <str name="options"> >> <str>A</str> >> <str>B</str> >> ... >> <str> >> <str name="value"> >> <str>200</str> >> <str>400</str> >> ... >> <str> >> </doc> >> <doc> >> <str name="id">4</str> >> <str name="options"> >> <str>A</str> >> <str>E</str> >> ... >> <str> >> <str name="value"> >> <str>300</str> >> <str>400</str> >> ... >> <str> >> </doc> >> <doc> >> <str name="id">6</str> >> <str name="options"> >> <str>A</str> >> <str>C</str> >> ... >> <str> >> <str name="value"> >> <str>200</str> >> <str>400</str> >> ... >> <str> >> </doc> >> >> Query: …?q=options:A >> >> Facet: 200 (2), 300 (1) >> >> Thank you >> Torben >> >> Am 04.10.2012 um 17:10 schrieb Jack Krupansky: >> >>> Use a field called "option_value_pairs" with values like "A 200" and >> then query with a quoted phrase "A 200". >>> >>> You could use a special character like equal sign instead of space: >> "A=200" and then you don't have to quote it in the query. >>> >>> -- Jack Krupansky >>> >>> -----Original Message----- From: Torben Honigbaum >>> Sent: Thursday, October 04, 2012 11:03 AM >>> To: solr-user@lucene.apache.org >>> Subject: Problem with relating values in two multi value fields >>> >>> Hello, >>> >>> I've a problem with relating values in two multi value fields. My >> documents look like this: >>> >>> <doc> >>> <str name="id">3</str> >>> <str name="options"> >>> <str>A</str> >>> <str>B</str> >>> <str>C</str> >>> <str>D</str> >>> <str> >>> <str name="value"> >>> <str>200</str> >>> <str>400</str> >>> <str>240</str> >>> <str>310</str> >>> <str> >>> </doc> >>> >>> My problem is that I've to search for a set of documents and display >> only the value for option A, for example, and use the value field as facet >> field. I need a result like this: >>> >>> <doc> >>> <str name="id">3</str> >>> <str name="options">A</str> >>> <str name="value">200</str> >>> </doc> >>> <facet> … >>> >>> I think that this is a use case which isn't possible, right? So can >> someone show me an alternative way to solve this problem? The documents >> each have 500 options with 500 related values. >>> >>> Thank you >>> Torben >>> >> >> > > > -- > Sincerely yours > Mikhail Khludnev > Tech Lead > Grid Dynamics > > <http://www.griddynamics.com> > <mkhlud...@griddynamics.com>
