Number cast as string in column sorting

[contreformeParticipant]

Hello,

i have these parameters on grid init :

fields : [{name:”duration”},{…}]
columns : [{text:”Duration (in minutes)”,datafield:”duration”,width:”30%”,type:”number”},{…}]
rows : [{“duration” : “85”,…}]

when I sort the column in ASC or DESC JQXGrid does so in alphabetical order where 9 > 10

I have tried :
– removing the quotes as : {“duration” : 85} but then JQXGrid init fails
– type:”int” or “float” – and/or format:”n” without success

Thanks for your help
s.

[Peter StoevKeymaster]

Hi contreforme,

1. There is no “type” column property.
2. This “type” should be set in the datafields initialization.
3. I would suggest you looking at the Grid’s demos to learn how to correctly initialize the Grid widget.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts