AnsweredAssumed Answered

Sort datagrid numerically

Question asked by amarsden on Sep 6, 2013
Latest reply on Oct 16, 2013 by amarsden

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?