Ordering more than 3 digits

karlie

Hi, I have a column containing only numbers. I can get this to order accurately, but only with 3 digits. As soon as it encounters 4 digits the ordering goes wrong. I'm using server side.

Any ideas?

bindrid

it is being sorted as a string not a number. Number of digits has nothing to do with the issue.

bindrid

We probably need to see your c ode. We need to figure out why its not automatically detecting its type as number.

allan

Likely it contains non-numeric data somewhere in the column, or you are using server-side processing and the sort is string based.

@bindrid - I read "We probably need to see your c ode." as that the original author was writing code in C for DataTables. That woke me up properly on a Monday morning .

Allan

bindrid

I can't type a simple sentence. Just imagine what my code looks like

karlie

Hi, I exported my database column and I found a rogue underscore in there, however, the problem is still there with that removed

I have tried setting my column setting as:

                {
                    "data": "number_column",
                    "orderable": true,
                    "searchable": false,
                    "type": 'num'
                },

And I have tried setting my column def as

{ "type": "num", "targets": 5 },

I've searched for leading and trailing spaces too

allan

"type": 'num'

Remove that. If DataTables isn't automatically detected it as a number type, the built in number sorting won't work.

Sort the data in both directions. It might show a rouge character.

Allan

tangerine

It might show a rouge character.

If your data is wearing rouge, it might need a good wash.

allan

Oh dear. Now imagine what my code looks like .