Replies

• kthorngren Posts: 21,558Questions: 26Answers: 4,994

  March 2021

  I created a test case for you with SearchBuilder:
  http://live.datatables.net/qokonicu/1/edit

  After performing a search and reloading the page I see this output from the retrieved state data:

  {time: 1617223013925, start: 0, length: 2, order: Array(1), search: {…}, …}
  columns: (6) [{…}, {…}, {…}, {…}, {…}, {…}]
  length: 2
  order: [Array(2)]
  page: 0
  search: {search: "", smart: true, regex: false, caseInsensitive: true}
  searchBuilder: {criteria: Array(2), logic: "AND"}
  start: 0
  time: 1617223013925
  

  And using console.log(typeof data.page) the result is number.

  Are you storing the data somewhere using stateSaveCallback? If so maybe the the page value is being changed to a string in your storage location or when its retrieved. Can you post a link to your page or a test case showing the issue?
  https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

  Kevin
• Alle_X Posts: 7Questions: 1Answers: 0

  March 2021

  I create the Datatable with that code:

  $.fn.dataTable.moment( 'DD.MM.YYYY HH:mm' );
      table = $('#tabelle').DataTable({
          stateSave: true,
          stateSaveCallback: function (settings, data) {
              tabdata = data;
          },
          dom: 'Qlfrtip',
          "order": [[ 2, "asc" ]]
      });
  

  And onclick I save the tabdata to the database via

  tabdata['filtername'] = $('#tbNeuerFilter').val();
  tabdata['filterid'] = 0;
  (...)
  $.ajax( {
          url: "ajax_savestate.php",
          data: tabdata,
          dataType: "text",
          type: "POST",
          success: function () { 
              alert(ausgabe); 
              location.reload(); 
          }
  } );
  

  and

  $param = array();
  $param[] = $uid;
  $param[] = $filtername;
  $param[] = $filter_json;
  
  $db->query("REPLACE INTO filter values(NULL,?,?,?);",$param,false,false);
  
• kthorngren Posts: 21,558Questions: 26Answers: 4,994

  April 2021

  Have you traced through all the statesave steps to see where the page property is a string ("0")?

  Maybe try the stateLoadParams and stateSaveParams events, like this:

  table = $('#tabelle')
    .on( 'stateSaveParams.dt', function (e, settings, data) {
          console.log('stateSaveParams event', data.page, typeof data.page);
      } )
      .on( 'stateLoadParams.dt', function (e, settings, data) {
          console.log('stateLoadParams event', data.page, typeof data.page);
      } )
      .DataTable({
          stateSave: true,
          stateSaveCallback: function (settings, data) {
              tabdata = data;
          },
          dom: 'Qlfrtip',
          "order": [[ 2, "asc" ]]
      });
  

  Kevin
• Alle_X Posts: 7Questions: 1Answers: 0

  April 2021

  You are right. I lose the int-type by postig the json as an array...

  

  Thank you for your help!