Sort datagrid numerically

adrian.marsden_DevonCC

Hi

I'm failing to sort a datagrid, that has results from a query task, numerically.

There is a field, that the service has defined as an integer, however it gets sorted in the datagrid as text (so I get 1,10,11,12,2,21,22 rather than 1,2,10,11,12,21,22)

I have tried adding a formatter on the grid like

        function PAOFormat(item) {                         var link = Number(item) + 0 ;             return link;         }  

But that fails - changing it to Number(item) + 100 does indeed add 100- to the number, so how do I tell it to be a number cell.

I have seen there is a celltype property, but I can't find a full list of cell types the best I have found is

cellTypeThe type of cell in the column. Allowable cell types include

• dojox.grid.cells.Bool
• dojox.grid.cells.Select

Any ideas?

ACM

JasonZou

Prior to

        //Create data object to be used in store         var data = {             identifier: "OBJECTID",             label: "LSData",             items: items         };

Go through the items loop, and convert the item attribute in need to number. Here is a sample.

var fldNameConvert = "fldConvertion"; var newItems = dojo.map(items, function(item) {     var newItem = dojo.clone(item);     newItem[fldNameConvert] = parseInt(newItem[fldNameConvert]);     return newItem; });  var data = {      identifier: "OBJECTID",      label: "LSData",      items: newItems };