Search is filtering to much
Search is filtering to much
Hello,
I´m using Datatables with web2py and in my application i´m trying to use the Search function.
For some strange reason the search is filtering to much. You can have a look at the application at the address: http://test-kal.nudata.fi/init/saleplace if you look at the list you can see three rows that start with Espoo. If I type espoo in the Search field only one rows is displayed.
I´m using this to display everything. The idea is to hide the first column when I get everything to work.
$(document).ready(function() {
$('#example').dataTable( {
"bServerSide": false,
"bProcessing": true,
"bFilter": true,
"bPaginate": false,
"bInfo": true,
// "bStateSave": true,
"aoColumns": [
{ "bSearchable": true, "bVisible": true },
{ "bSearchable": true, "sWidth": '150px' },
{ "bSearchable": false, "sWidth": '200px' },
{ "bSearchable": false },
{ "bSearchable": false },
{ "bSearchable": false },
{ "bSearchable": false }
],
"sAjaxSource": "{{=URL(r=request, c='saleplace', f='readdata')}}"
} );
} );
The source for this can be seen at address:
http://test-kal.nudata.fi/init/saleplace/readdata
Kenneth
I´m using Datatables with web2py and in my application i´m trying to use the Search function.
For some strange reason the search is filtering to much. You can have a look at the application at the address: http://test-kal.nudata.fi/init/saleplace if you look at the list you can see three rows that start with Espoo. If I type espoo in the Search field only one rows is displayed.
I´m using this to display everything. The idea is to hide the first column when I get everything to work.
$(document).ready(function() {
$('#example').dataTable( {
"bServerSide": false,
"bProcessing": true,
"bFilter": true,
"bPaginate": false,
"bInfo": true,
// "bStateSave": true,
"aoColumns": [
{ "bSearchable": true, "bVisible": true },
{ "bSearchable": true, "sWidth": '150px' },
{ "bSearchable": false, "sWidth": '200px' },
{ "bSearchable": false },
{ "bSearchable": false },
{ "bSearchable": false },
{ "bSearchable": false }
],
"sAjaxSource": "{{=URL(r=request, c='saleplace', f='readdata')}}"
} );
} );
The source for this can be seen at address:
http://test-kal.nudata.fi/init/saleplace/readdata
Kenneth
This discussion has been closed.