I have data coming from the server in pages of 10 records each (limit clause). However I would like to have a one-row footer that shows totals for the entire dataset (not just the limit 10).
I have handled it server-side and can serve up a JSON response with a “footerrow” object (actually part of the same response that brings back the 10 rows).
How best to map this JSON response into the footer for all columns? (not just 1-2 columns - I could have 20+). I did not see an example of this in the docs.
I could name the JSON keys in the footerrow object to be the same as the column ids if that helps.
Thanks for any help