Single column supporting only 4 digits or less on sort/filter/redraw

Single column supporting only 4 digits or less on sort/filter/redraw

ryanryan Posts: 2Questions: 0Answers: 0
edited February 2012 in General
I found a few pieces of older posts that touched on a similar problem I am having:

1. http://datatables.net/forums/discussion/6708/search-not-finding-some-records-in-firefoxchrome/p1
2. http://datatables.net/forums/discussion/3746/datatables-1.7.x-search-does-not-find-some-rows-in-opera/p1

I am experiencing a similar situation where on redraw, I lose row records due to a single columns reluctance to support 5+ digits for an integer.

Unlike the others, I am experiencing this across all browsers I am able to get my hands on.

If the cell contains 9999 or less, the row remains post filter/sort/draw, if it has 10000 or more - it disappears from the table, but is still recognized in stats ie - "Showing 1 to 10 of 83 entries (filtered from 85 total entries)" where 2 entries have a integer over 4 digits.

I've tried using the following sType - formatted-num, currency, numeric

What is interesting, the next column over is set to sType currency, and 5+ digits work just fine.

Any ideas on this matter? Snippet below:

Thanks!

v1.9.0

[code]
$(document).ready(function() {

var oTable = $('#grid').dataTable( {

"bFilter": true,
"bProcessing": true,
"bLengthChange": false,
"aoColumnDefs": [
{ "bVisible": false, "aTargets": [ 5,6 ] },
],

"aoColumns": [
null,
null,
{ "sType": "formatted-num"},
{ "sType": "currency"},
{ "sType": "currency"},
null,
null
]
});
});
[/code]

Replies

  • ryanryan Posts: 2Questions: 0Answers: 0
    Well, after digging and digging - I found the error - and it has nothing to do with the above issues. Datatables was working just as it had been instructed to - I had a mislabeled variable that was causing this ruckus.

    Don't mind me . . . nothing to see here.
This discussion has been closed.