Answers

• colin Posts: 15,152Questions: 1Answers: 2,587

  October 2023

  It's working as expected in this example. Is your XXResult the same as stored, which you used to get the values?

  We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

  Colin
• PabloCamara Posts: 16Questions: 4Answers: 0

  October 2023

  XXResult. yes and no is the same. Before loading it it is the same (or so I think). The thing is that I save the filter in a file and it saves it this way: "{""criteria"":[{""criteria"":[{""condition"":""="","" data"":""Sub Product"",""origData"":""IDSPROD"",""type"":""num"",""value"":[""0204""]}, {""condition"":""="",""data"":""Sub Product"",""origData"":""IDSPROD"",""type"":""num"", ""value"":[""0401""]}],""logic"":""OR""}],""logic"":""AND""}";

  I don't know the double quotes, but before loading it I remove them. and it loads it fine, but when I have a second level of grouping it does not move the fields to the right, I will surely have some inappropriate value.

  this is my code

  $('#BtGuarda').on('click', function() {
      table = $('#table_b').DataTable();
      var arr_tabla = [];
      var arr_visible = [];
      var Arr_resultado = [];
      var contador = 0;
      var valor = 0;
  
  
      stored = table.searchBuilder.getDetails();
      $('#CadenaCriterio').val(JSON.stringify(stored));
  
      arr_tabla = table.colReorder.order();
  
      for( i=0 ; i < arr_tabla.length;i++) {
         if ( table.column(i).visible()) {
              arr_visible.push(arr_tabla[i]);
         }
      }
  
      $('#CadenaCampos').val(arr_tabla);
      $('#CadenaVisibles').val(arr_visible);
  
  });
  
  $('#BtRestore').on('click', function() {
      var x  = document.getElementById("msin");
      var e  = document.getElementById("msrn");
  
      var valor = x.options[e.selectedIndex].value;
  
      var Resultado = valor.replaceAll('&#34;','"');
      var table = $('#table_b').DataTable();
  
      x.options[e.selectedIndex].value
  
  
      if ( Resultado != ' ' ) {
          XXResultado = JSON.parse(Resultado);
          table.searchBuilder.rebuild(XXResultado);
          table.columns.adjust().draw( true );
      }
      table.buttons(0,0).enable(true);
      table.buttons(0,1).enable(true);
      table.buttons(0,2).enable(true);        
      $('#BtGuarda').prop('disabled' , false);
  }); 
  

  Now I'm confused, since when I tried to get an example, and enlarge the screen it was refreshed and corrected. In short, it is something that I think needs a refresher.

  Thanks anyway and sorry for not giving an example, but I'm too new to this.
• colin Posts: 15,152Questions: 1Answers: 2,587

  October 2023 Answer ✓

  It sounds like those double quotes are being inserted by whatever is saving the string to a file. This would definitely mess up the load, since it's not expecting it.

  Without seeing the issue, it's hard to debug. Here's an example that you can modify. If you can provide steps on how to reproduce there (and feel free to update it), we can take a look.

  Colin