PDF Button - Error on filter all (zero records)

rodriformiga

Hello @allan

The pdf have a error on click and the datasource is empty.
In my case, I filtered the records on search field (wrote something to return zero records) and click in the button to export.
You can see this in the example: https://datatables.net/extensions/buttons/examples/initialisation/export.html

rodriformiga

someone?

tangerine

This seems to apply to all the "export" Buttons; they don't recognize that there is no data.
I suppose there may be circumstances in which someone might want to print an empty table, for example, to have a copy of the table structure. But is this intentional?

colin

I'd say that was a bug - I'll get it raised and linked to this topic.

Cheers,

Colin

kthorngren

If you want to protect against exporting 0 records you can use something like drawCallback to check for the number of records using page.info() to determine the number of records. Then use button().disable() and button().enable() as desired.

Kevin

allan

Thanks all! Fixed here and will be in the next release of Buttons which I think we should push out fair soon - its been a while!

Allan

Charley

Hmm... my comment is missing. Maybe I deleted it?

I had someone who didn't want the buttons enabled at all if there was no data in the view (even though it didn't error out due to the bug fix above). I enable/disable the export buttons with the code below.

var datatablesConfig = {
    "drawCallback": function( settings ) {
        var api = new $.fn.dataTable.Api( settings );
        var info = api.page.info();
        var showExportButtons = false;
        try{
            if(info.recordsDisplay > 0){
                showExportButtons = true;
            }
        } catch (err){}
        if(showExportButtons){
            api.buttons( '.buttons-html5' ).enable()
        } else {
            api.buttons( '.buttons-html5' ).disable()
        }
    }

};

var table = $('#example').DataTable(datatablesConfig);

allan

Perfect - thanks for your reply. That looks like it could be a useful addition for others. Actually, I'm wondering if it should go into the core library...

Allan