• In v2.10, The ajaxProcessing function was updated to only require a total number of rows to be returned, also instead of returning an array of table rows, you can build the table yourself and just return the jQuery object containing those rows. The addon triggers an update.
• {filterList:fcol} was added to the ajaxUrl in version 2.6.
• {sortList:col} was added to the ajaxUrl in version 2.4.5.
• This update to the pager plugin that interacts with a database via ajax was added in version 2.0.32 and can be applied to the original tablesorter.
• The ajaxUrl and ajaxProcessing function are both required options for this interaction to work properly.
• The ajaxUrl contains a replaceable string to send the requested page ({page}), block size ({size}) or sort order ({sortList:name}).
• The ajaxProcessing function is needed to convert your custom JSON format into an array usable by the pager plugin (modified in 2.1.3)
  
  So, given this custom JSON format (this is only an example):

  {
    "total_rows": 80,
  
    "headers" : [
      "ID", "Name", "Country Code", "District", "Population"
    ],
  
    "rows" : [{
      "ID": 1,
      "Name": "Kabul",
      "CountryCode": "AFG",
      "District": "Kabol",
      "Population": 1780000
    }, {
      "ID": 2,
      "Name": "Qandahar",
      "CountryCode": "AFG",
      "District": "Qandahar",
      "Population": 237500
    }, {
      ...
    }, {
      "ID": 25,
      "Name": "Haarlemmermeer",
      "CountryCode": "NLD",
      "District": "Noord-Holland",
      "Population": 110722
    }]
  }

  The ajaxProcessing function can return the data in the following format [ total, rows, headers (optional) ], or in version 2.9+ [ rows, total, headers (optional) ],
  or in v2.10, return a jQuery object [ total, $rows ], or just [ total ]:

  [
    // total # rows contained in the database
    80,
    // row data: array of arrays; each internal array has the table cell data for that row
    [
      [ 1, "Kabul", "AFG", "Kabol", 1780000 ],                 // [ "row1cell1", "row1cell2", ... "row1cellN" ],
      [ 2, "Qandahar", "AFG", "Qandahar", 237500 ],            // [ "row2cell1", "row2cell2", ... "row2cellN" ],
       ...
      [ 25, "Haarlemmermeer", "NLD", "Noord-Holland", 110722 ] // [ "rowNcell1", "rowNcell2", ... "rowNcellN" ]
    ],
    [ "ID", "Name", "Country Code", "District", "Population" ] // [ "Header1", "Header2", ... "HeaderN" ] (optional)
  ]

• The table header and footer text will be updated to match the JSON "header column #" text; but there is an issue with the table rendering improperly if the number of columns in the HTML and the number of columns in the JSON don't match.
• Limitations of this demo:
  • This demo will not work when viewing it locally due to communication restrictions between the browser and your desktop.
  • The record size is limited to 25 records because this demo is not interacting with an actual database, but with four JSON files containing 25 records each.
  • Sorting of columns is enabled in this demo by setting the serverSideSorting option to false after initialization. It only sorts the current table contents because there is no server to return sorted data.
  • The filters will only update the "Current Ajax url" because again, we're just working with JSON files here.

* If you have a different JSON format and need help with the processing code, please ask the question on StackOverflow or message me directly (gmail; wowmotty). Please don't open an issue for help with code.