title: Handsontable sort data from backend database over json/ajax
body: <p>I want to make use of the Handsontable column sorting and direction indicators to send a sort request to my DB and display the corresponding results.</p>
  
  <p>The Handsontable sort plugin works nicely (allows clicking on a column header) but only sorts the currently loaded data, as per their <a href="https://docs.handsontable.com/pro/1.11.0/demo-sorting.html" rel="nofollow noreferrer">docs</a></p>
  
  <pre><code>var hot = new Handsontable(document.getElementById('example'), {
    columnSorting: true
  });
  </code></pre>
  
  <p>How can I trigger my own method when the user clicks on a column header?</p>
  
  <p>I understand I can use jQuery to catch the click and work out the column and direction and trigger my own method but this seems clumsy if it's already being listened to and tracked by Handsontable.</p>
  
  <p>I'd prefer to overwrite the method or hook into the table somehow so Handsontable keeps track of the state of the sorting (column and direction) and I use that information to fetch data from the DB.</p>