lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Constantijn Visinescu <baeli...@gmail.com>
Subject Re: Solr Query help - sorting
Date Tue, 25 Aug 2009 08:00:03 GMT
make a new multivalued field in your schema.xml, copy both width and length
into that field, and then sort on that field ?

On Tue, Aug 25, 2009 at 5:40 AM, erikearle@yahoo.com <erikearle@yahoo.com>wrote:

> Clever... but if more than one row adds up to the same value I may get the
> wrong order (like 50, 50 and 10, 90)
>
> I need a max function but the one provided only compares against a
> constant.
>
> Sent from my iPhone
>
> On Aug 24, 2009, at 6:15 PM, Koji Sekiguchi <koji@r.email.ne.jp> wrote:
>
> How about using sum() FunctionQuery, via:
>
> http://localhost:8983/solr/select/?q=_val_%3A%22sum%28width%2Clength%29%22
>
> Thanks,
>
> Koji
>
>
> Erik Earle wrote:
> Suppose I have a database of rectangle attributes that I have indexed in
> Solr and I want to get the top 10 widest or longest rectangles from one
> query.
>
>
> name  |  width  |  length
> A     |  100    |  10
> B     |  10     |  90
> C     |  80     |  10
> ...
>
>
> My indexed fields are:  name, width, length
>
> Is there a way to query so that my data returns the order:  A, B, C
>
>
>
>
>
>
>
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message