Using fetchMoreData/dataReduction for pagination
So, I got a request from my employer to paginate the data tables, but also with a bunch of strange formatting that they like which makes it somewhere between a table and a matrix. That stuff is no big deal, the problem I am running into is the pagination. I wanted to use the fetchMoreData/dataReduction feature to get a window (the size of the page of data) but I can't for the life of me figure out (might be due to lack to sleep at this point) how to get the onclick event of a link to trigger the fetchmoredata and also that method doesn't seem to have an option for fetch previous data so I can get away from loading the whole data set into memory when it isn't needed. Only the current page of data is needed and while I could load that page and then once the visual is rendered load each subsquent page's data and keep it in memory (bleh so wasteful). Can I use a javascript function to tell my visual what the current page number should be so I can index in and out of that dataview? It is just html but I would assume I need to make a server round trip for that extra data.