Re: Solr Query help - sorting

2009-08-25 Thread Erik Earle
hanks guys! - Original Message From: Erik Hatcher To: solr-user@lucene.apache.org Sent: Tuesday, August 25, 2009 11:26:58 AM Subject: Re: Solr Query help - sorting If you're using DataImportHandler, a custom (Java or script) transformer could do this. Also an UpdateProcessor could do it

Re: Solr Query help - sorting

2009-08-25 Thread Erik Hatcher
I can because the app and db that Solr is indexing are not really the best place to add this type of functionality. - Original Message From: Koji Sekiguchi To: solr-user@lucene.apache.org Sent: Tuesday, August 25, 2009 4:04:29 AM Subject: Re: Solr Query help - sorting Hi E

Re: Solr Query help - sorting

2009-08-25 Thread Erik Earle
ality. - Original Message From: Koji Sekiguchi To: solr-user@lucene.apache.org Sent: Tuesday, August 25, 2009 4:04:29 AM Subject: Re: Solr Query help - sorting Hi Erik Earle, Ahh, I read your mail too fast... Erik Hatcher's method should work. Thanks! Koji Erik Hatcher wrote: > You could

Re: Solr Query help - sorting

2009-08-25 Thread Koji Sekiguchi
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. The

Re: Solr Query help - sorting

2009-08-25 Thread Erik Hatcher
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 fi

Re: Solr Query help - sorting

2009-08-25 Thread Constantijn Visinescu
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 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

Re: Solr Query help - sorting

2009-08-24 Thread erikea...@yahoo.com
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 wrote: How about using sum() FunctionQu

Re: Solr Query help - sorting

2009-08-24 Thread Koji Sekiguchi
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 on

Solr Query help - sorting

2009-08-24 Thread Erik Earle
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 I