filtering datatable with checkboxes, column value 'S' appear value 'N' dont

andrebertonha

I´m trying this question that i founded here, but with no success

$(document).ready( function () {
  var table = $('#dataTableClientes').DataTable();
  
 $('input:checkbox').on('change', function () {
   //build a regex filter string with an or(|) condition
        var origens = $('input:checkbox[name="orig"]:checked').map(function() {
          return '^' + this.value + '$';
        }).get().join('|');   

        //filter in column 5, with an regex, no smart filtering, not case sensitive
        table.column(5).search(origens, true, false, false).draw(false);
        table.column(6).search(origens, true, false, false).draw(false);
        table.column(7).search(origens, true, false, false).draw(false);
        table.column(8).search(origens, true, false, false).draw(false);   

  });

} );

kthorngren

You posted a similar question in this thread:
https://datatables.net/forums/discussion/53671/how-can-i-use-multiple-checkbox-filter#latest

Its hard to say what the problem is without seeing the full picture of what you have. Please post a link to your page or a test case replicating the issue.
https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

The example I posted in the other thread does work. I'm not sure why the same solution doesn't work for you without seeing it.

Kevin

andrebertonha

It´s a combination of checkboxes and one select
When click just refresh datatable result with the selected value
I will post some picture, thanks

andrebertonha

kthorngren

Its difficult to help with your code without actually seeing it in action. Can you post a link to your page or a test case replicating the issue?
https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

Kevin

andrebertonha

https://jsfiddle.net/w8oyfdub/1/
is not working, here i could filter by first checkbox
so the logic to filter the 4 checkboxes, i dont now if this is correct way yo do
thanks for helping

andrebertonha

https://jsfiddle.net/9vxmcfLs/13/

kthorngren

Thanks for the test case. That will help us to get you going. You may need to use a Search Plugin for this depending on how you want it to behave.

I understand you have four columns which can have either S or N values. If you check Site for example then you want to search the S column for S or if unchecked for N. You have the same for the other 3 columns.

Do you want this to be an and or an or search?

How do you want to reset the search to show the whole table? Meaning how do you want to show both N and S in the Site column?

Maybe you need two checkboxes for each column; one for S and one for N.

Let us know what you want to do then we can help you adjust your code. If you want two checkboxes for each column please adjust your test case and post the new link.

Kevin

andrebertonha

I want to be an and search. If the 4 checkboxes are checked then will show only registers who have this match
When the user uncheck some of check boxes so I have to show the match result of others with S value
When uncheck all checkboxes the entire datatable must to be shown

André

andrebertonha

https://jsfiddle.net/8h3ujegb/

kthorngren

Not sure if this is exactly what you want but it should get you started:
https://jsfiddle.net/tnvf2aLq/2/

It uses the search plugin. Inside the function its just a matter of Javascript code to determine if the row should be displayed (return true) or not displayed (return false). Hopefully you can workout any JS changes needed to reach your solution.

Kevin

andrebertonha

Almost there, I´m trying to use .map function so when hidden 'S' value by other checkbox can be shown in users click

kthorngren

Not sure I understand what you want to do with the .map function but you will want it in the click event not the search plugin function since the plugin is called for each row.

Kevin

andrebertonha

Thanks for helping Kevin so i reach the result that I want

$(function() {
  otable = $('#dataTableClientes').dataTable();
});

function filterme() {
  
  var types = $('input:checkbox[name="site"]:checked').map(function() {
    return this.value === 'on' ? 'S' : 'N';
  }).get().join('|');  
  otable.fnFilter(types, [5], true, false, false, false);
  
  var valueBoca = $('input:checkbox[name="boca"]:checked').map(function() {
    return this.value === 'on' ? 'S' : 'N';
  }).get().join('|');  
  otable.fnFilter(valueBoca, [6], true, false, false, false);  
  
  var valueFace = $('input:checkbox[name="face"]:checked').map(function() {
    return this.value === 'on' ? 'S' : 'N';
  }).get().join('|');  
  otable.fnFilter(valueFace, [7], true, false, false, false);  
  
  var valueIndica = $('input:checkbox[name="indica"]:checked').map(function() {
    return this.value === 'on' ? 'S' : 'N';
  }).get().join('|');  
  otable.fnFilter(valueIndica, [8], true, false, false, false);
  
}   

not sure if ih the best solution but it´s working fine
so as soon as possible i will update one fiddle showing how it´s working
and get some feedback
Thanks for all

andrebertonha

https://jsfiddle.net/andrebertonha/xk4hwvo7/30/
A feedback will be welcome