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.1K
All Categories
57
Priority support
24.6K
Free community support
1K
General
14
Announcements
2.6K
DataTables
128
DataTables 2
1.3K
DataTables 1.10
93
DataTables 1.9
35
DataTables 1.8
9
CloudTables
2.2K
Editor
2.8K
Extensions
20
AutoFill
314
Buttons
34
ColReorder
4
ColumnControl
33
DateTime
68
FixedColumns
51
FixedHeader
31
KeyTable
106
Responsive
24
RowReorder
43
Scroller
168
SearchBuilder
200
SearchPanes
107
Select
27
StateRestore
220
Bug reports
68
Feature requests
101
Plug-ins
11
Blog
73
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;
}
});
});