Single column supporting only 4 digits or less on sort/filter/redraw
Single column supporting only 4 digits or less on sort/filter/redraw
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]
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]
This discussion has been closed.
Replies
Don't mind me . . . nothing to see here.