Limiting / Filtering multivalue fields in Solr

Question

Is there a way to limit, or filter, the returned text of a multivalued field in Solr? Given the following document structure in Solr:

...
<doc>
    <str name="title">example</str>
    <arr name="foo">
        <str>bar1</str>
        <str>bar2</str>
        <str>bar3</str>
        <str>bar4</str>
        <str>bar5</str>
        <str>bar6</str>
    </arr>
</doc>
...

I'd like to limit the response to only show 1 of the "foo" values based on a Filter Query request. So for example, the query:

select/?q=example&fq=foo:bar2`

I would want a response of:

...
<doc>
    <str name="title">example</str>
    <arr name="foo">
        <str>bar2</str>
    </arr>
</doc>
...

score 2 · Accepted Answer · answered Dec 24 '12 at 03:35

2

Nope. There is not way to filter the Multivalued Values returned with the response.
You can easily do it at client side though.

If you can use Facet to get the list, you can use facet.prefix to limit the values for the field foo returned as facet.

answered Dec 24 '12 at 03:35

Jayendra

52,349
4
80
90

Thanks, I was expecting this type of answer. The problem is that "foo" could contain thousands of values which will effect efficiency just on data transfer alone. – dubrie Dec 25 '12 at 00:37

score 0 · Answer 2 · answered Jan 06 '15 at 11:23

0

Did you try using dynamic fields if you know the sample space of values for 'foo'? For example:

and then filter on bar_x:true. You would end up using a large number of dynamic fields.

answered Jan 06 '15 at 11:23

dr.house

190
1
9

score -3 · Answer 3 · edited Feb 12 '15 at 19:40

-3

filter query should work, try below code

&fq=+foo:"bar2"

edited Feb 12 '15 at 19:40

Vidhi

2,026
2
20
31

answered Feb 12 '15 at 18:50

Saravanan

1

Limiting / Filtering multivalue fields in Solr

3 Answers3

Linked