search on special characters

rohit99

we need to search on special characters with rang filter.
like: salary type columns "$ 150,000"

allan

If you want to use a range filter, you need to implement a custom search plug-in. If you do that, you could just strip out non-numeric characters.

Allan

rohit99

Thanks for help.

But we have some trouble in

$.fn.dataTable.ext.search.push

If we use multiple table on one page. This method performed on both tables, but we need only one table.

rohit99

We use this, but not working
$.fn.dataTable.ext.search.push(
function (settings, data, dataIndex) {
if (settings.nTable == document.getElementById('tblFlowdown')) {

allan

That should be how to do it. If it isn't working for you, please link to a test case showing the issue.

Allan

rohit99

This is worked, if we use multiple table on one page.
This method performed on both tables, but we need only one table.
We can change $.fn.dataTable.ext.search.push to any other method ?

$.fn.dataTable.ext.search.push(
function (settings, data, dataIndex) {
if (settings.nTable == document.getElementById('tblFlowdown')) {
var _salary = data[8];

                    var _val = $('#filterByValue-FlowDown').val();
                    if (_val == "") {
                        _val = _salary;
                    }
                    _val = _val.replace(/,/g, "").trim();
                    _val = _val.replace("$", "").trim();
                    var searchVal = parseFloat(_val) || 0;

                    _salary = _salary.replace(/,/g, "").trim();
                    _salary = _salary.replace("$", "").trim();
                    var salary = parseFloat(_salary) || 0;


                    if (searchVal >= salary) {
                        return true;
                    }
                    return false;
                }
            });

rohit99

We can change $.fn.dataTable.ext.search.push to any other method. Just like ('#tblFlowdown').DataTable().column(col).

allan

No not yet. That is something that will be added in a future version of DataTables.

At the moment you need to do an id check inside your custom filtering function, just like you have done.

Allan