I want to completely control the server side sorting of my grid. Meaning, when I click a column header, I don't want the grid to do anything - I want to catch the sorting event, update some local parameters in my app, and use a fetch function that I have in my app.
All I want the column header to do is to present the arrow in the relevant direction.
I don't want to use transport.read and serverSorting=true because I seems to have no control over when this function is called.
I'm building my columns from the data received so I need to separate the data fetch from the grid's initial creation.
I tired solving this by catching a change event on the dataSource, and if the event.sender.sort() exists with the relevant parameters, it works, other than the fact that first the grid still sorts the data at client side, and only then it fetches my server side data, which causes a delay, bad performance (~1000 records/30 columns), and unnecessary sorting. event.preventDefault() doesn't stop the client side sorting from happening.
I'm currently using ui-grid (open source angular grid) which allows me to do so - just control the sorting functionality completely. Is that achievable with kendo grid?