Hi, May you show us what result you actually get? Wouldn't it make more sense to choose a numeric fieldtype? To get proper sort order of numbers in a string field, all number need to be exactly same length since order will be lexiographical, i.e. "10" will come before "2", but after "02".
-- Jan Høydahl, search solution architect Cominvent AS - www.cominvent.com On 10. sep. 2010, at 19.14, n...@frameweld.com wrote: > Hello, I seem to be having a problem with sorting. I have a string field > (time_code) that I want to order by. When the results come up, it displays > the results differently from relevance which I would assume, but the results > aren't ordered. The data in time_code came from a numeric decimal with a six > digit precision if that makes a difference(ex: 1.000000). > > Here is the query I give it: > > q=ceremony+AND+presentation_id%3A296+AND+type%3Ablob&version=1.3&json.nl=map&rows=100000&start=0&wt=json&hl=true&hl.fl=text&hl.simple.pre=<span+class%3D"hl">&hl.simple.post=<%2Fspan>&hl.fragsize=0&hl.mergeContiguous=false&&sort=time_code+asc > > > And here's the field schema: > > <field name="presentation_id" type="sint" indexed="true" stored="true"/> > <field name="asset_id" type="sint" indexed="true" stored="true"/> > <field name="type" type="text" indexed="true" stored="true"/> > <field name="text" type="text" indexed="true" stored="true" > multiValued="true"/> > <field name="time_code" type="string" indexed="true" stored="true"/> > <field name="unique_key" type="string" indexed="true" stored="true"/> > <dynamicField name="*" type="text" indexed="true" stored="true"/> > <field name="all_text" type="text" indexed="true" stored="true" > allowDups="true" multiValued="true"/> > <copyField source="*" dest="all_text"/> > <field name="text_dup" type="textSpell" indexed="true" stored="true" > allowDups="true"/> > <copyField source="text" dest="text_dup"/> > > Thanks for any help. >
