Column Filter in Fixed Column data table with Horizontal Scroll
Column Filter in Fixed Column data table with Horizontal Scroll
salil
Posts: 10Questions: 0Answers: 0
I am refering the example http://datatables.net/release-datatables/extras/FixedColumns/col_filter.html
Here instead of the Text filters I am using Select filter and want to have the filter option in the Header insted of the footer.
I am able to get the Select Filter in the Header of the data table by using the built in Column Filter. I am having numerous columns for which I am using Fixed Column js file to get 3 fixed left columns along with Horizontal Scroll.
I am using the below code to create the Data Table
var oTable = $('#tblSourceDataMapp').dataTable({
"oLanguage": { "sSearch": "Search Data Mapping Grid:" },
"iDisplayLength": 10,
"aaSorting": [[0, "asc"]],
"sScrollY": "300px",
"sScrollX": "100%",
"sScrollXInner": "300%",
"bScrollCollapse": true
})
new FixedColumns(oTable, {
"iLeftColumns": 3,
"iLeftWidth": 225
});
I am having 3 issues now,
1. The Filter dropdowns appear for all the columns. However the filters for the non fixed columns appear below the first 3 fixed columns. When I filter any column, these 3 filters non fixed filters disappear.
2. I get an error at the line,
if (bIgnoreEmpty == true && sValue.length == 0) continue;
I am using --> $("thead td").each(function (i) {
to create the select dropdowns in header
3. The filter and Sort come together in the same row. Is it possible to seperate these features in 2 diff rows
Here instead of the Text filters I am using Select filter and want to have the filter option in the Header insted of the footer.
I am able to get the Select Filter in the Header of the data table by using the built in Column Filter. I am having numerous columns for which I am using Fixed Column js file to get 3 fixed left columns along with Horizontal Scroll.
I am using the below code to create the Data Table
var oTable = $('#tblSourceDataMapp').dataTable({
"oLanguage": { "sSearch": "Search Data Mapping Grid:" },
"iDisplayLength": 10,
"aaSorting": [[0, "asc"]],
"sScrollY": "300px",
"sScrollX": "100%",
"sScrollXInner": "300%",
"bScrollCollapse": true
})
new FixedColumns(oTable, {
"iLeftColumns": 3,
"iLeftWidth": 225
});
I am having 3 issues now,
1. The Filter dropdowns appear for all the columns. However the filters for the non fixed columns appear below the first 3 fixed columns. When I filter any column, these 3 filters non fixed filters disappear.
2. I get an error at the line,
if (bIgnoreEmpty == true && sValue.length == 0) continue;
I am using --> $("thead td").each(function (i) {
to create the select dropdowns in header
3. The filter and Sort come together in the same row. Is it possible to seperate these features in 2 diff rows
This discussion has been closed.