access number of Filters Active

montoyam

at the top of a SearchPane there is a count of how many filters are selected. I can't find any documentation that shows how we can grab that count. Is it possible?

colin

There isn't an API to get it, but you can count the rows with the classes like this:

$('.dtsp-searchPanes tr.selected').length

Colin

montoyam

That will work, as long as they only select one for each filter, which appears to be what the 'Filters Active' count at the top is doing anyway...I didn't realize that.

Thanks.

montoyam

I am having trouble with the syntax for detecting when a filter item is clicked. I have tried the 'normal' ones but they don't work

    //$('div.dtsp-searchPanes table tr').on("click", function () {
    $('div.dtsp-searchPanes tbody').on('click', 'td.dtsp-nameColumn', function () {
        console.log($('.dtsp-searchPanes tr.selected').length);
    });

allan

Try:

$(document).on('click', ''div.dtsp-searchPanes tbody td.dtsp-nameColumn', ...

Allan

allan

Out of interest, why do you need to do that? I'm wondering if you might be better using draw on the main table.

Allan

montoyam

I have a select input and button that is going to do some record updates for the records that are showing. However, I need to make sure they have filtered the records using each of the three searchPane filters so they don't accidently update ALL the records in the dataset. So, I am disabling the button until they have selected 3 filter items.

allan

Ah - very interesting. I was wondering if we should be triggering an event or making that kind of thing available through an API method. What we might look at doing is making an API method which exposes the DataTables that SearchPanes is using, then you can listen for events on them, etc.

Allan

montoyam

this didn't seem to work either...

    $(document).on('click', 'div.dtsp-searchPanes tbody td.dtsp-nameColumn', function () {
        console.log($('.dtsp-searchPanes tr.selected').length);
    });

colin

This one seems to work, see here:

      $('div.dtsp-searchPanes tbody td.dtsp-nameColumn').on('click', function () {
        console.log($('.dtsp-searchPanes tr.selected').length);
      });

montoyam

thank you. I have decided instead to let the user click the update button, but stop/inform them if they did not have the correct number of filters. This way I don't have to clutter the page with any instructions.

But, thank you, as I'm sure i will use the .on(click) method in the future and it could benefit others.

And thank you Allan, for such an awesome product and your dedication to continually adding new functionality to it.

        if ($('.dtsp-searchPanes tr.selected').length < 2) {
            alert('You must select at least two filters above to make this update');
        } else {
            if ($('#newRate').val() == 0) {
                alert('You must select a new Rate to assign to these records');
            } else {

allan

Thank you