Answers

• rmd Posts: 4Questions: 1Answers: 0

  October 2022

  I've finally resolved my own issue:

              var table = $('#mydata').DataTable({
                  buttons: ['searchBuilder',
                      'createState',
                      {
                          extend: 'savedStates',
                          config: {
                              update: false,
                              ajax: stateRestoreAjax,
                              type: 'POST',
                          }
                      },
                  ],
  

  With:

          function stateRestoreAjax(data, callback) {
              console.log(data.action)
              $.ajax({
                  type: "POST",
                  contentType: "application/json; charset=utf-8",
                  url: '{{ url_for('data_savedstates') }}',
                  data: JSON.stringify(data),
                  dataType: "json",
                  success: function (data) {
                      console.log(data)
                      callback(data);
                  }
              });
              callback(data);
          }
  

  On the server side:

  @app.route('/data/savedstates', methods=['POST'])
  def data_savedstates():
      response = make_response(User(current_user.get_id()).process_savedstates(json.loads(request.data.decode('utf-8'))))
      response.mimetype = 'application/json'
      return response
  
  

  and

      def process_savedstates(self, data):
  
          if data['action'] == 'load':
              return self.profile['saved_states']
          elif data['action'] == 'save':
              saved_states = self.profile['saved_states']
              saved_states.update(data['stateRestore'])
              self.profile = dict(saved_states=saved_states)
              return ''
          elif data['action'] == 'remove':
              saved_states = self.profile['saved_states']
              for k in data['stateRestore'].keys():
                  del saved_states[k]
              self.profile = dict(saved_states=saved_states)
              return ''
          elif data['action'] == 'rename':
              saved_states = self.profile['saved_states']
              old, new = list(data['stateRestore'].items())[0]
              saved_states[new] = saved_states.pop(old)
              self.profile = dict(saved_states=saved_states)
              return ''
  
          # TODO: this shouldn't happen - raise an exception
          pprint.pprint(data)
          return data
  
• rmd Posts: 4Questions: 1Answers: 0

  October 2022

  P.S. I'm now experiencing this issue: https://datatables.net/forums/discussion/73990/update-button-not-firing-with-extend-savedstates
• allan Posts: 63,498Questions: 1Answers: 10,470 Site admin

  October 2022

  Thanks for the update - good to hear you have the original issue resolved. I'll take a look at the other thread shortly.

  Allan