ColVis with AJAX Source fetches data each time column is shown/hidden

wengole

Is there anyway to stop this? Changing the visible columns shouldn't require a fetch of the data, should it?

bwpc

I guess that depends. I am looking into this "extra" as well. In my case, my datatables is only configured for the absolute necessary columns to display. So without a doubt, in my case, I need to go back to the server to refetch the data.

What I am looking for is:

1) How do I tell DataTables about ALL my columns, but only give it the data for the columns that are initially visible?

2) Configure ColVis so that it doesn't make the ajax call until the user is finishing making their changes?

3) Is there a way to change the look of ColVis? I'd prefer it to look more like a dialog so that the user knows the changes won't take effect until they close it.

nandhini_hari

Hi,

Have you resolved this issue? Am also facing the same problem.. For every column change in colvis, an ajax request is made.. I have two datatables.. One is working fine, and the other is having this issue..