filter many columns on button click
filter many columns on button click
First thanks a lot for this great package.
Second, I have 4 columns, and I prepared a form with 4 text inputs and one button, I want the filtering to start when the button clicked. I searched the forum, I couldn't find anything confirm or deny the possibility of this.
You help is really appreciated n0n
Second, I have 4 columns, and I prepared a form with 4 text inputs and one button, I want the filtering to start when the button clicked. I searched the forum, I couldn't find anything confirm or deny the possibility of this.
You help is really appreciated n0n
This discussion has been closed.
Replies
1. :-) Thanks.
2. All you need to do is have the fnFilter() API function triggered on the 'click' event (i.e. your click event handler will call fnFilter() with whatever values you need for it). The following two links might help:
http://localhost/datatables/dataTables-1.5/examples/api/multi_filter.html
http://datatables.net/api#fnFilter
Regards,
Allan
This is how I did filtering:
[code]
$("#ButtonFilter").click(function() {
oTable.fnFilter( $("#input1").val(), '0' );
oTable.fnFilter( $("#input2").val(), '2' );
oTable.fnFilter( $("#input3").val(), '4' );
});
[/code]
This way filtering won't cause load on my ajax script that used to load table data from database. only when user specify all his filtering criteria and click the button to start filtering.
Thanks again ;)