The exportOption 'columns' => ':visible' do not work

[Arkhas]

Summary of problem or feature request

When exporting, the param :

'exportOptions' => [
                          'columns' => ':visible
                      ],

Do not work

it should enable the option to only export the visible columns and not all.

System details

• Operating System
  Debian wheezy
• PHP Version
  PHP 7.1.8
• Laravel Version
  Laravel Framework 5.5.19
• Laravel-Datatables Version

yajra/laravel-datatables-buttons      v3.1.0             Laravel DataTables Buttons Plugin.
yajra/laravel-datatables-html         v3.2.1             Laravel DataTables HTML builder plugin for Laravel 5.4+.
yajra/laravel-datatables-oracle       v8.3.2             jQuery DataTables API for Laravel 4|5

[yajra]

Can you please link me to the datatables.net example of how this is done? This option is a bit new to me. Thanks!

[Arkhas]

Sure :

https://datatables.net/extensions/buttons/examples/print/columns.html

[yajra]

I see, this demo is for printing on client-side implementation. For server-side, unfortunately it's not supported.

[HadrienKulik]

@yajra do you think this feature will be implemented in a future version?

It is a bit weird that the printing on the server side takes into account the visibility of the columns, but the xls exporting does not. Is there a reason for the different behavior?

[yajra]

AFAIK, colvis is not also available on server-side implementation on the JS side so it might a bit difficult to implement atm.

For exporting, you can just set exportable to false. Here are some column config the you can use:

  'orderable'      => false,
  'searchable'     => false,
  'exportable'     => false,
  'printable'      => true,
  'visible'        => true,

[AmirTallap]

Any work around this issue or feature yet?

[AmirTallap]

@yajra I think we might pass a variable to _buildParams I'm not sure how to do that yet, but I request you might give me a hint :)

[FabienLucini]

Indeed a workaround is to add a parameter to the function _buildParams
And then cath it in the 'getColumns' method on server side.
I just made a PR for that : yajra/laravel-datatables-buttons#78

[AmirTallap]

Well, now we know how to catch the parameter on the server side, aka backend, but how to send it in the actual dt ajax request? what js we need to edit?

[FabienLucini]

It's in the file changed in the PR :
https://github.com/yajra/laravel-datatables-buttons/pull/78/files

[AmirTallap]

Doesn't work with print! @FabienLucini, only with postcsv visible. not even pdf!