Answers

• allan Posts: 63,523Questions: 1Answers: 10,473 Site admin

  October 2020 Answer ✓

  The issue at the moment is that "url":"fetch.php?filter="+filter, is only ever evaluated once. What you want is that every time you reload the data for the table (which you would do using ajax.reload() is for the filter value to re-evaluated. For that, use ajax.data:

  ajax: {
    url: 'fetch.php',
    data: function (d) {
      d.filter = $('#filter').val();
    },
    dataSrc: '',
    type: 'GET'
  }
  

  Also make sure you assign the DataTable to a variable:

  var table = $('#table').DataTable({
  

  And in your change event handler call ajax.reload():

  table.ajax.reload();
  

  Job done

  Allan
• hellow0rld Posts: 2Questions: 1Answers: 0

  October 2020

  Brilliant! It worked first time thanks. In this example:

  1. I looked in the documentation for ajax reload but I did not understand "data.json" in the first example. Where is this data coming from? Does it just represent the data which would be used in a full example?
  2. In ajax.reload, is ajax a classname without an instantiated object? Is there a way to get back a list of classnames & methods which are available? Maybe in the browser or VS Code. I'm just trying to figure out what is available to me.

  Javascript syntax never gets any easier
• allan Posts: 63,523Questions: 1Answers: 10,473 Site admin

  October 2020

  I looked in the documentation for ajax reload but I did not understand "data.json" in the first example. Where is this data coming from?

  It just an example file name. You could have /my/really/long/path/to/myData or anything else - as long as it returns valid JSON.

  In ajax.reload, is ajax a classname without an instantiated object?

  Not it isn't a "class" in the technical term - it is just an object with properties attached to it. The full list is in the reference.

  Our latest package of DataTables has typescript typings in it, so if you are using TypeScript it should auto complete when everything is setup and working.

  Allan