Re: Sorting fields with letters?

2011-10-24 Thread Peter Spam
Tried using the ord() function, but it was the same as the standard sort. Do I just need to bite the bullet and reindex everything? Thanks! Pete On Oct 21, 2011, at 5:26 PM, Tomás Fernández Löbbe wrote: I don't know if you'll find exactly what you need, but you can sort by any field or

Sorting fields with letters?

2011-10-21 Thread Peter Spam
Hi everyone, I have a field that has a letter in it (for example, 1A1, 2A1, 11C15, etc.). Sorting it seems to work most of the time, except for a few things, like 10A1 is lower than 8A100, and 10A100 is lower than 10A99. Any ideas? I bet if my data had leading zeros (ie 10A099), it would

Re: Sorting fields with letters?

2011-10-21 Thread Tomás Fernández Löbbe
Well, yes. You probably have a string field for that content, right? so the content is being compared as strings, not as numbers, that why something like 1000 is lower than 2. Leading zeros would be an option. Another option is to separate the field into numeric fields and sort by those (this last

Re: Sorting fields with letters?

2011-10-21 Thread Peter Spam
Is there a way to use a custom sorter, to avoid re-indexing? Thanks! Pete On Oct 21, 2011, at 2:13 PM, Tomás Fernández Löbbe wrote: Well, yes. You probably have a string field for that content, right? so the content is being compared as strings, not as numbers, that why something like 1000

Re: Sorting fields with letters?

2011-10-21 Thread Tomás Fernández Löbbe
I don't know if you'll find exactly what you need, but you can sort by any field or FunctionQuery. See http://wiki.apache.org/solr/FunctionQuery On Fri, Oct 21, 2011 at 7:03 PM, Peter Spam ps...@mac.com wrote: Is there a way to use a custom sorter, to avoid re-indexing? Thanks! Pete On