select only rows in the visible part of the table

Maikel

Hey,

i have buttons like 'select all', 'deselect all', 'invert selection'
but i want these buttons to only work on the visible part of the tables, so after filtering and paging.

How do i do this?

Maikel

kthorngren

Maybe something this will work in your button config:

exportOptions: {
  rows: ':visible'
}

Kevin

Maikel

what i currently have:

                select: {
                    info:     true,
                    style:    'os',
                    selector: 'td:not(:has(div.details-control), .details-control), th'
                },

i tried adding :visible in there but it doesn not seem to work

allan

You'll need a custom button to do what you are looking for. Something like:

{
  text: "Select visible",
  action: function ( dt ) {
    dt.rows( { page: 'current' } ).select();
  }
}

What Kevin was looking at was when exporting data with buttons such as excel.

Allan

eJed

I had to modify allans code to get it to work. I'm not a javascript expert but maybe it will help someone.

{
    text: "Select Page",
    action: function ( e, dt, button, config ) {
        dt.rows( { page: 'current' } ).select();
    }
},

allan

Doh! I forgot about the e parameter. Thanks for pointing that out.

Allan

shujaatkulvi

Thnx eJed. It works like magic

Jatin

Can you provide full example?

colin

@Jatin : here you go,

Colin