Datatable list of visible columns on server side from stateSave

karmendra

I want to get the list visible columns from the front-end when a page with dataTables is loaded.
This will help me decide what query to run to fetch only those columns.

First time user sees the page, he will see the data with default columns, but if he chooses to not show certain columns this information gets saved in stateSave, next time he visits the page I should get the information about what are the visible columns and I update run different query to fetch only those visible columns.

colin

Hi @karmendra ,

colums().visible() can be used to get the visible status of the columns,

Cheers,

Colin

karmendra

I need this information colums().visible() on server side when the ajax request get/post is called to fetch data.

I use Yajra Laravel datatables plugin, may be I need to ask if there is an option to modify ajax request to include visible columns or the entire saveState object.

Thanks,
Karmendra

colin

Hi @karmendra ,

Yep, you can add custom properties to the Ajax request as demonstrated in this example here, so that could easily include the visible columns,

Cheers,

Colin

karmendra

Thanks colin, This is what I was looking for.