hide export buttons based on condition

lenamtl

Hi,

I need to show or hide the export button based on a condition.
I'm wondering what us the best method to achieved this without breaking the Datatables logicial.

Case example

I want to hide all export buttons, but keep the colvis if $showexportbutton = N

$showexportbutton = "<?php echo $buttonvisibility; ?>";

    var table11 = $('#mylist').DataTable({

    "bProcessing": true,

    dom: ' //my settings here ',
        buttons: [
                {
                           extend: 'colvis',
                                // my settings here
                 },
                   {
                    extend: 'excelHtml5',
                                 // my settings here    
                }, .....

colin

Probably the best way would be to just change the buttons object before you initialise the table, something like this: http://live.datatables.net/sumemeha/1/edit

You could also use jQuery's hide(), but a tech-savvy user could unhide those buttons.

Colin

lenamtl

How can I add all the settings to the
buttons.push( 'excelHtml5');

for example this code

{
            extend: 'excelHtml5',
                text: 'Excel',
                titleAttr: 'Excel',
                title: 'Excel',
                exportOptions: {
                    columns: function (idx, data, th) {

                        if ($(th).hasClass('not-export-col')) {
                            return false;
                        }

                        if ($(th).hasClass('hidden')) {
                            return false;
                        }

                        return table.column(idx).visible();
                    },
                },
        }, 

kthorngren

buttons.push( 'excelHtml5');

Replace the 'excelHtml5' with the initialization object you posted. You an push a string onto the array or an object

Kevin

lenamtl

Hi,

Here is the updated code but I still have errors
http://live.datatables.net/seyatuhi/1/edit

Question1: since which Datatables version I can use buttons.push method?

Question2: I may have multiple tables ont the same page,
Set like this
var table1 = $('#mylist').DataTable....
var table2 = $('#mysecondlist').DataTable....
How to push the button per table?

kthorngren

Here is the updated code but I still have errors

Looks like the example works. What are the errors?

Question1: since which Datatables version I can use buttons.push method?

In the example buttons is a Javascript array. It is using Javascript push() to add the buttons to the array. Its not a Datatables specific method.

Question2: I may have multiple tables ont the same page,
How to push the button per table?

If the button configuration is different for each table then use different variables for each table.

Kevin

lenamtl

JSBIN error on Javascript Column.

But I thinks this maybe a cache issue as I cannot reproduce the error on JSfiddle.

Thanks for your help I really appreciate.

Have a great day

kthorngren

I see. Since you are pushing 3 buttons they need to be in an array like this:
http://live.datatables.net/seyatuhi/2/edit

Kevin

lenamtl

I see thanks