denormalize your docs to option x value tuples, identify them by duping id.
<doc> <str name="setid">3</str> <str name="options">A</str> <str name="value">200</str> </doc> <doc> <str name="setid">3</str> <str name="options">B</str> <str name="value">400</str> </doc> <doc> <str name="setid">3</str> <str name="options">B</str> <str name="value">400</str> </doc> <doc> <str name="setid">3</str> <str name="options">C</str> <str name="value">240</str> </doc> then collapse them by set "setid" field. (it can not be uniqkey). On Fri, Oct 5, 2012 at 6:26 PM, Torben Honigbaum < torben.honigb...@neuland-bfi.de> wrote: > 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> > > -- Sincerely yours Mikhail Khludnev Tech Lead Grid Dynamics <http://www.griddynamics.com> <mkhlud...@griddynamics.com>
