Hi Erik Earle,

Ahh, I read your mail too fast... Erik Hatcher's method should work.

Thanks!

Koji


Erik Hatcher wrote:
You couldn't sort on a multiValued field though.

I'd simply index a max_side field, and have the indexing client add a single valued field with max(length,width) to it. Then sort on max_side.

    Erik

On Aug 25, 2009, at 4:00 AM, Constantijn Visinescu wrote:

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, erikea...@yahoo.com <erikea...@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 <k...@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













Reply via email to