Re: Optimizing a query to sort results alphabetically for a determinated field

2009-08-24 Thread Marc Sturlese
It just worked. Thanks a lot! Good to know sortMissingLast works not just in sortable fields Constantijn Visinescu wrote: > > not 100% sure but the example schema has: > omitNorms="true"/> > > So i'd say give it a go and see what happens ;) > > On Mon, Aug 24, 2009 at 12:24 PM, Marc Stur

Re: Optimizing a query to sort results alphabetically for a determinated field

2009-08-24 Thread Avlesh Singh
Ah ... I just got wiser! Thanks Erik. Cheers Avlesh On Mon, Aug 24, 2009 at 4:39 PM, Erik Hatcher wrote: > > On Aug 24, 2009, at 7:03 AM, Avlesh Singh wrote: > > Can you really sort accurately on tokenized fields? >> > > Yes, as long as there is *one and only one* term emitted from the analyzer

Re: Optimizing a query to sort results alphabetically for a determinated field

2009-08-24 Thread Erik Hatcher
On Aug 24, 2009, at 7:03 AM, Avlesh Singh wrote: Can you really sort accurately on tokenized fields? Yes, as long as there is *one and only one* term emitted from the analyzer. KeywordTokenizer is your friend, and comes in handy to lowercase or pattern replace things. Erik

Re: Optimizing a query to sort results alphabetically for a determinated field

2009-08-24 Thread Avlesh Singh
Can you really sort accurately on tokenized fields? Cheers Avlesh On Mon, Aug 24, 2009 at 3:54 PM, Marc Sturlese wrote: > > Yes but I thought it was just for sortable fields: > sint,sfloat,sdouble,slong. > Can I apply "sortMissingLast"to text fields analyzed with KeywordAnalyzer? > > Constantij

Re: Optimizing a query to sort results alphabetically for a determinated field

2009-08-24 Thread Constantijn Visinescu
not 100% sure but the example schema has: So i'd say give it a go and see what happens ;) On Mon, Aug 24, 2009 at 12:24 PM, Marc Sturlese wrote: > > Yes but I thought it was just for sortable fields: > sint,sfloat,sdouble,slong. > Can I apply "sortMissingLast"to text fields analyzed with

Re: Optimizing a query to sort results alphabetically for a determinated field

2009-08-24 Thread Marc Sturlese
Yes but I thought it was just for sortable fields: sint,sfloat,sdouble,slong. Can I apply "sortMissingLast"to text fields analyzed with KeywordAnalyzer? Constantijn Visinescu wrote: > > There's a "sortMissingLast" true/false property that you can set on your > fielType definitions in the schema

Re: Optimizing a query to sort results alphabetically for a determinated field

2009-08-24 Thread Constantijn Visinescu
There's a "sortMissingLast" true/false property that you can set on your fielType definitions in the schema. On Mon, Aug 24, 2009 at 11:58 AM, Marc Sturlese wrote: > > Hey there, I need to sort my query results alphabetically for a > determinated > field called "town". This field is analyzed with