DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
Examples
Manual
Reference
Extensions
Plug-ins
Blog
Forums
Discussions
Sign In
Support
FAQs
Download
Purchase
≡
Show site navigation
tabletools osettings initialisation
tabletools osettings initialisation
anony
Posts: 6
Questions: 0
Answers: 0
June 2012
edited June 2012
in
General
Hello there,
cant solve the problem it doesnt give a right solution to the problem
my code says oSettings unused.
No matter if i create a varable its not recognized and gives an error
Replies
anony
Posts: 6
Questions: 0
Answers: 0
June 2012
my script is as follows,
jQuery.fn.dataTableExt.oSort['string-case-asc'] = function (x, y) {
return ((x < y) ? -1 : ((x > y) ? 1 : 0));
};
jQuery.fn.dataTableExt.oSort['string-case-desc'] = function (x, y) {
return ((x < y) ? 1 : ((x > y) ? -1 : 0));
};
$(document).ready(function() {
$('#datatable-wrapper').append('');
$('#example').dataTable( {
"bStateSave":true,
"fnStateSave": function ( oSettings , oData) {
alert("fnSaveState invoked");
localStorage.setItem('DataTables_'+window.location.pathname, JSON.stringify(oData));
},
"fnStateLoad": function (oSettings) {
alert("fnStateLoad invoked");
var data = localStorage.getItem('DataTables_'+window.location.pathname);
return JSON.parse(data);},
"fnInitComplete": function(oSettings) {
var cols = oSettings.aoPreSearchCols;
for (var i = 0; i < cols.length; i++) {
var value = cols[i].sSearch;
if (value.length > 0) {
$("tfoot input")[i].value = value;
}
}
},
"bServerSide": false,
"bAutoWidth": false,
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"sDom": 'T<"clear">lfrtip',
"aaData": [
[ "Trident", "Internet Explorer 4.0", "Win 95+", 4, "X" ],
[ "Trident", "Internet Explorer 5.0", "Win 95+", 5, "C" ],
[ "Trident", "Internet Explorer 5.5", "Win 95+", 5.5, "A" ],
[ "Webkit", "Safari 2.0", "OSX.4+", 419.3, "A" ],
[ "Webkit", "Safari 3.0", "OSX.4+", 522.1, "A" ]
],
"aoColumns": [
{ "sTitle": "Engine" },
{ "sTitle": "Browser" },
{ "sTitle": "Platform" },
{ "sTitle": "Version", "sClass": "center" },
{
"sTitle": "Grade",
"sClass": "center",
"fnRender": function(obj) {
var sReturn = obj.aData[ obj.iDataColumn ];
if ( sReturn == "A" ) {
sReturn = "A";
}
return sReturn;
}
}
]
});
$("tfoot input").keyup(function () {
oTable.fnFilter(this.value, $("tfoot input").index(this));
});
var startPosition;
var endPosition;
$("#datatable-wrapper #example tbody").sortable({
cursor: "move",
start:function(event, ui){
startPosition = ui.item.prevAll().length + 1;
},
update: function(event, ui) {
endPosition = ui.item.prevAll().length + 1;
}
});
});
This discussion has been closed.
Sign In
·
Register
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Sign In
Register
Quick Links
Categories
Recent Discussions
Unanswered
Categories
75.4K
All Categories
57
Priority support
24.9K
Free community support
1K
General
15
Announcements
2.6K
DataTables
153
DataTables 2
1.3K
DataTables 1.10
94
DataTables 1.9
35
DataTables 1.8
9
CloudTables
2.3K
Editor
2.9K
Extensions
22
AutoFill
315
Buttons
36
ColReorder
14
ColumnControl
37
DateTime
70
FixedColumns
51
FixedHeader
31
KeyTable
106
Responsive
24
RowReorder
43
Scroller
171
SearchBuilder
202
SearchPanes
109
Select
28
StateRestore
224
Bug reports
68
Feature requests
102
Plug-ins
11
Blog
74
Web-site
Replies
jQuery.fn.dataTableExt.oSort['string-case-asc'] = function (x, y) {
return ((x < y) ? -1 : ((x > y) ? 1 : 0));
};
jQuery.fn.dataTableExt.oSort['string-case-desc'] = function (x, y) {
return ((x < y) ? 1 : ((x > y) ? -1 : 0));
};
$(document).ready(function() {
$('#datatable-wrapper').append('');
$('#example').dataTable( {
"bStateSave":true,
"fnStateSave": function ( oSettings , oData) {
alert("fnSaveState invoked");
localStorage.setItem('DataTables_'+window.location.pathname, JSON.stringify(oData));
},
"fnStateLoad": function (oSettings) {
alert("fnStateLoad invoked");
var data = localStorage.getItem('DataTables_'+window.location.pathname);
return JSON.parse(data);},
"fnInitComplete": function(oSettings) {
var cols = oSettings.aoPreSearchCols;
for (var i = 0; i < cols.length; i++) {
var value = cols[i].sSearch;
if (value.length > 0) {
$("tfoot input")[i].value = value;
}
}
},
"bServerSide": false,
"bAutoWidth": false,
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"sDom": 'T<"clear">lfrtip',
"aaData": [
[ "Trident", "Internet Explorer 4.0", "Win 95+", 4, "X" ],
[ "Trident", "Internet Explorer 5.0", "Win 95+", 5, "C" ],
[ "Trident", "Internet Explorer 5.5", "Win 95+", 5.5, "A" ],
[ "Webkit", "Safari 2.0", "OSX.4+", 419.3, "A" ],
[ "Webkit", "Safari 3.0", "OSX.4+", 522.1, "A" ]
],
"aoColumns": [
{ "sTitle": "Engine" },
{ "sTitle": "Browser" },
{ "sTitle": "Platform" },
{ "sTitle": "Version", "sClass": "center" },
{
"sTitle": "Grade",
"sClass": "center",
"fnRender": function(obj) {
var sReturn = obj.aData[ obj.iDataColumn ];
if ( sReturn == "A" ) {
sReturn = "A";
}
return sReturn;
}
}
]
});
$("tfoot input").keyup(function () {
oTable.fnFilter(this.value, $("tfoot input").index(this));
});
var startPosition;
var endPosition;
$("#datatable-wrapper #example tbody").sortable({
cursor: "move",
start:function(event, ui){
startPosition = ui.item.prevAll().length + 1;
},
update: function(event, ui) {
endPosition = ui.item.prevAll().length + 1;
}
});
});