Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
Received-SPF: pass (athena.apache.org: domain of toporniz@gmail.com designates
 74.125.82.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <1421774249517-4180653.post@n3.nabble.com>
References: <1421774249517-4180653.post@n3.nabble.com>
Date: Tue, 20 Jan 2015 23:17:24 +0100
Message-ID: 
 <CAKzZM-u8bYbmFSD7E7c6oZ67RNMguXCtPKx4RhHRBSVu2mxHWg@mail.gmail.com>
Subject: Re: Filter Solr multivalued fields to be able to add pagination
From: Alvaro Cabrerizo <toporniz@gmail.com>
To: "solr-user@lucene.apache.org" <solr-user@lucene.apache.org>
Content-Type: multipart/alternative; boundary=047d7b66f93ba7e7ff050d1ccdcb

--047d7b66f93ba7e7ff050d1ccdcb
Content-Type: text/plain; charset=UTF-8

Hi,

Currently, there is no way to sort by a multi-value field within solr
(first the system should sort the content of the field, then sort
documents...). Anyway, if you have a clear idea on how the sort should be
done try to accomodate your data to your needs (in case it is posible).

One option could be to copy the last value of the original field (i.e.
reviewdate)
into a new single-value field (e.g. name it lastreviewdate) and then sort
by this new field (lastreviewdate). The copy could be done using your own
update chain. For example, reusing CloneFieldUpdateProcessorFactory
<https://lucene.apache.org/solr/4_4_0/solr-core/org/apache/solr/update/processor/CloneFieldUpdateProcessorFactory.html>
and
extending the FieldValueSubsetUpdateProcessorFactory
<https://lucene.apache.org/solr/4_4_0/solr-core/org/apache/solr/update/processor/FieldValueSubsetUpdateProcessorFactory.html>
which
will extract the last element of the lastreviewdate field (Your
LastFieldValueUpdateProcessorFactory). Thus part of your solrconfig.xml
should look like this:

...
<updateRequestProcessorChain name="yourProcessorChain">
...
<processor class="solr.CloneFieldUpdateProcessorFactory">
   <str name="source">reviewdate</str>
   <str name="dest">lastreviewdate</str>
 </processor>
 <processor class="yourpackage.YourLastFieldValueUpdateProcessorFactory">
   <str name="fieldName">lastreviewdate</str>
 </processor>
...
</updateResquestProcessorChain>

Regards.

p.d. Not clear if LastFieldValueUpdateProcessorFactory
<https://lucene.apache.org/solr/4_4_0/solr-core/org/apache/solr/update/processor/LastFieldValueUpdateProcessorFactory.html>
could
copy the value you are interested in, thus avoiding the creation of the new
class yourpackage.YourLastFieldValueUpdateProcessorFactory


On Tue, Jan 20, 2015 at 6:17 PM, PeterKerk <petervdkerk@hotmail.com> wrote:

> I have the Solr XML response below using this query:
>
> http://localhost:8983/solr/tt/select/?indent=off&facet=false&wt=xml&fl=title,overallscore,service,reviewdate&q=*:*&fq=id:315&start=0&rows=4&sort=reviewdate%20desc
>
> I want to add paging on the multivalued fields, but the above query throws
> the error `can not sort on multivalued field: reviewdate`
>
> How can I add paging (or put differenly select only a subset of the
> response
> based on a filter on a multivalued field)? In my case with a pagesize of 4
> and total results of 18 that would result in 5 pages.
>
>
>
>         <?xml version="1.0" encoding="UTF-8"?>
>         <response>
>            <lst name="responseHeader">
>                   <int name="status">0</int>
>                   <int name="QTime">0</int>
>                   <lst name="params">
>                          <str name="facet">true</str>
>                          <str
> name="fl">reviewtitle,overallscore,service,reviewdate,rating</str>
>                          <str name="facet.mincount">1</str>
>                          <str name="indent">on</str>
>                          <str name="q">*:*</str>
>                          <str name="fq">id:315</str>
>                   </lst>
>            </lst>
>            <result name="response" numFound="1" start="0">
>                   <doc>
>                          <float name="rating">8.78</float>
>                          <arr name="service">
>                                 <int>8</int>
>                                 <int>10</int>
>                                 <int>10</int>
>                                 <int>10</int>
>                                 <int>5</int>
>                                 <int>8</int>
>                                 <int>9</int>
>                                 <int>10</int>
>                                 <int>10</int>
>                                 <int>10</int>
>                                 <int>10</int>
>                                 <int>9</int>
>                                 <int>9</int>
>                                 <int>9</int>
>                                 <int>9</int>
>                                 <int>6</int>
>                                 <int>1</int>
>                                 <int>10</int>
>                          </arr>
>                          <arr name="overallscore">
>                                 <int>8</int>
>                                 <int>10</int>
>                                 <int>10</int>
>                                 <int>10</int>
>                                 <int>8</int>
>                                 <int>8</int>
>                                 <int>9</int>
>                                 <int>10</int>
>                                 <int>9</int>
>                                 <int>10</int>
>                                 <int>10</int>
>                                 <int>9</int>
>                                 <int>10</int>
>                                 <int>9</int>
>                                 <int>9</int>
>                                 <int>8</int>
>                                 <int>1</int>
>                                 <int>10</int>
>                          </arr>
>                          <arr name="reviewdate">
>                                 <date>2014-11-26T17:18:50.367Z</date>
>                                 <date>2014-10-10T16:54:07.397Z</date>
>                                 <date>2014-08-18T14:21:17.807Z</date>
>                                 <date>2014-08-17T00:20:41.877Z</date>
>                                 <date>2014-08-14T15:30:44.963Z</date>
>                                 <date>2014-08-14T15:23:36.29Z</date>
>                                 <date>2014-08-13T16:25:38.327Z</date>
>                                 <date>2014-08-13T13:54:47.847Z</date>
>                                 <date>2014-08-13T13:20:20.753Z</date>
>                                 <date>2014-06-16T23:29:37.093Z</date>
>                                 <date>2012-11-23T21:54:07.897Z</date>
>                                 <date>2012-11-21T17:40:01.11Z</date>
>                                 <date>2012-11-17T01:58:53.15Z</date>
>                                 <date>2012-11-14T02:17:30.677Z</date>
>                                 <date>2012-11-13T23:22:14.613Z</date>
>                                 <date>2012-11-13T19:09:25.563Z</date>
>                                 <date>2012-08-01T18:09:33.243Z</date>
>                                 <date>2012-07-09T20:37:39.837Z</date>
>                          </arr>
>
>                   </doc>
>            </result>
>            <lst name="facet_counts">
>                   <lst name="facet_queries" />
>                   <lst name="facet_fields" />
>                   <lst name="facet_dates" />
>                   <lst name="facet_ranges" />
>            </lst>
>         </response>
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Filter-Solr-multivalued-fields-to-be-able-to-add-pagination-tp4180653.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>

--047d7b66f93ba7e7ff050d1ccdcb--