Answers

• colin Posts: 15,177Questions: 1Answers: 2,590

  October 2021 Answer ✓

  Glad you like the extension. Unfortunately, that is a known issue. We're about to release a new extension that and adds more meat to state saving, StateRestore, and that also has the same limitation with server-side SearchPanes. It is something we aim to address, but it's unlikely to be before the end of the year.

  Colin
• georgen Posts: 3Questions: 1Answers: 0

  October 2021

  @colin I assume the searchBuilder has the same issue as well? Haven't tried it yet, but don't want to spend hours implementing it only to find out it doesn't work either.

  And a suggestion on Searchpanes and SearchBuilder: It would be nice if you could actually pass filters and options that are not part of the table itself. For example, I have a table of products that I want to filter using their attributes (colors, types, etc). Those attributes are not part of the table itself and are not part of the AJAX response. I did bypass that by adding dummy columns to the table (setting visible: false and defaultContent = '') but it would be nice to do away with such hacks...

  In any case, I will definitely continue using DataTables! It's by far the best of its kind!
• colin Posts: 15,177Questions: 1Answers: 2,590

  October 2021

  No, SearchBuilder should be fine - this problem only relates to server-side SearchPanes.

  You might be able to use orthogonal data for those attribute issue - see example here.

  And nice, glad you like!

  Colin
• georgen Posts: 3Questions: 1Answers: 0

  October 2021

  OK, for anyone else looking for something similar, I figured out a workaround when using server-side processing and state load/save to get the selections back in the SearchPanes:

  $.each(table.state.loaded().searchPanes.selectionList, function(index, list) {
      if (list.rows.length > 0) {
          $.each(list.rows, function(key, value) {
              $('#DataTables_Table_'+index+'_wrapper table').DataTable().row(value.index).select().draw();
          })
      }
  });
  

  Your data should already be filtered by the server at this point so you only need to select the relevant options again. This method is hacky, but it gets the job done.