Answers

• rahfikimane Posts: 3Questions: 1Answers: 0

  December 2023

  Will also just add that despite Hiding the columns on a page with a particular pageURL string, SearchPanes is still bringing them in. Could it also have to do with the timing of when I initially hide the columns?
• kthorngren Posts: 21,343Questions: 26Answers: 4,954

  December 2023 edited December 2023 Answer ✓

  There are a few options columnDefs.targets that can be used. See the docs for all options. You can pass a variable to columnDefs.targets, something like this:

  If (pageURL.includes('variable1')) {
    showPanes = [0, 1, 2];
    hidePanes = [3, 4, 5];
  }
  else if ( pageURL.includes('variable2')) {
    showPanes = [3, 4, 5];
    hidePanes = [0, 1, 2];
  }
  
      $('#example').DataTable({
          dom: 'Plfrtip',
          columnDefs: [
              {
                  searchPanes: {
                      show: true
                  },
                  targets: showPanes
              },
              {
                  searchPanes: {
                      show: false
                  },
                  targets: hidePanes
              }
          ]
      });
  

  Hiding the columns on a page with a particular pageURL string, SearchPanes is still bringing them in

  I don't believe the columns.visible setting will affect the display of the SearchPanes. By default the display of the SearchPanes is controlled by searchPanes.threshold as shown in this example. You can override this with the columns.searchPanes.show as shown in the example you linked to.

  Kevin
• rahfikimane Posts: 3Questions: 1Answers: 0

  December 2023

  Just ran through your solution and it worked perfectly. Passing those variables to the targets is a great feature. Thank you!