Editor server Ajax override with a function.

naspersgasp

Hi,

Good day.

We use an SDK to make requests to our API endpoints (https://aws-amplify.github.io/amplify-js/media/api_guide#post). I have most of it working correctly. The issue is that searching does not seem to work. This is my override:
Editor:

ajax: function(data, callback, settings, success, failure) {
                  let apiName = 'Admin';
                  let path = '/categories';
                  let init = {
                    body: settings
                  };
                  API.post(apiName, path, init).then(response => {
                    success(response);
                  }).catch(error => {
                    console.error(error);
                    failure(error)
                  });
                },

Datatable:

ajax: function(data, callback, settings) {
                  let apiName = 'EatInAdmin';
                  let path = '/categories';
                  let init = {
                    body: data
                  };

                  API.post(apiName, path, init).then(response => {
                    callback(response);
                  }).catch(error => {
                    console.error(error)
                  });
                },

Any ideas? I can see the requests go through, but the results are not filtered as when I'm just using the ajax url parameter instead.

Regards.

colin

Hi @naspersgasp ,

It would be worth running the debugger on that page so we can see the table configuration.

Cheers,

Colin

naspersgasp

Hi,

Good day.

I've upload the table configuration https://debug.datatables.net/ahifuf.

Let me know if there's anything else you require?

So, I'm using server side processing, search request:

curl 'http://localhost:3000/categories' -H 'Pragma: no-cache' -H 'Origin: http://localhost:4201' -H 'Accept-Encoding: gzip, deflate, br' -H 'Accept-Language: en-US,en;q=0.9,af;q=0.8,de;q=0.7,ko;q=0.6,zh;q=0.5' -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36' -H 'Content-Type: application/json' -H 'Accept: application/json, text/plain, */*' -H 'Cache-Control: no-cache' -H 'Referer: http://localhost:4201/categories' -H 'Connection: keep-alive' --data-binary '{"draw":1,"columns":[{"data":"Category","name":"","searchable":true,"orderable":true,"search":{"value":"","regex":false}}],"order":[{"column":0,"dir":"asc"}],"start":0,"length":25,"search":{"value":"","regex":false}}' --compressed

Regards.

allan

Could you log what data you are sending into the callback function when it is executed and show us please? The debugger can't do that unfortunately in this case since you are overriding the default Ajax operation.

Allan

naspersgasp

Hi,

Good day.

The callback?, not sure if that is the issue? Or I'm misunderstanding.

The payload.

The response that comes back is:

Also, the sever setup is straight forward:

    let editor = new Editor(db, 'Categories').fields(
            new Field('Category').validator(Validate.notEmpty()),
        );
    await editor.debug(true).process(req.body);
    res.json(editor.data());

Regards.

allan

This part:

callback(response);

If you add console.log( response ); before that is what I was getting at (which actually it looks like you've more or less got from the network panel).

If filtering isn't working (the JSON response above looks fine), it suggests the server-side script isn't doing the filtering. Can you do a console.log( req.body ); on the server-side and we can see what Editor is attempting to process?

Thanks,
Allan

naspersgasp

Maybe the object is different when using the ajax override function? I found this to be true with all my other crud functions. Seems what use to be arrays coming through are now all objects? Could that be the issue? And how would I fix that? Thanks.

{ draw: 1,
  columns:
   [ { data: 'Category',
       name: '',
       searchable: true,
       orderable: true,
       search: [Object] } ],
  order: [ { column: 0, dir: 'asc' } ],
  start: 0,
  length: 25,
  search: { value: '', regex: false } }

allan

That looks okay to me there. Could you give me a link to the page - send me a PM by clicking my name and then Send message if you don't want it to be public.

Allan