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
>
