How can i make table.ajax.reload(callback,resetflag) Synchronus.

lycan

I want to maintain row selection even after making table.ajax.reload(callback,false). Callback function has logic to highlight selected row. But in my case callback is getting executed before table refresh. As a result unable to maintain row selection after reload.

jLinux

If you're using just arrays as the data sources (as opposed to objects, where you can use the rowId), then you can use this example I just created. All it does is wait for select and deselect, then save the row indexes, then when the table is re-drawn (via the ajax reload), it re-selects them all.

However, I ran into a problem with this... I had it setup so you could delete an "item" from the table, it would send the ajax call to delete the item, then just reload the table via ajax.reload(), the problem I ran into, is if rows were selected, then when the other rows that got deleted were removed (which were above the selected row(s)), the indexes all got changed, so when the table reloaded, different rows were selected...

So, in short.. use objects in your ajax data source, then it should work just fine, (example here)

jLinux

By the way.. that 2nd example I sent you, I didnt find that until I replied to your comment...

I ran into the same problem you had, because event though I was using objects in my data source, I didnt specify the rowId, so I created my own way of doing it...

tools = {
    selected_ids: function($dt, unlocked_only){
        "use strict";

        // Get all selected
        var ids = $dt.rows( { selected: true } );

        // If only need unlocked, get the unlocked out of the above ids
        if(unlocked_only)
            ids = $dt.rows(ids.indexes().filter(function(idx){
                return ! $dt.row(idx).data()['status'];
            }));

        if( ! ids.any()) return false;

        // Return an array of the IDs as integers
        return ids.ids().toArray().map(function(id, idx, ids){
            return parseInt(id);
        });
    }
};

var selected_ids = [];

table
    // When rows are selected ..
    .on( 'select', function ( e, dt, type, indexes ) {
        // Update the selected rows
        selected_ids = tools.selected_ids($dt);
    } )

    // When rows are Deselected ..
    .on( 'deselect', function ( e, dt, type, indexes ) {
        // Update the selected rows
        selected_ids = tools.selected_ids($dt);
    } )

    // When the DT is redrawn .. (Deletes, sorts, etc)
    .on( 'draw.dt', function () {
        $dt.rows( _.map(selected_ids, function(a_id){ return '#'+a_id; }) ).select();
    } );

And now that I see it was all pointless, had I just seen that example I linked you... I hate myself for not looking harder >.< lol

allan

Yup - if you are using the Select extension for your row selection, then it should actually be handled automatically - as long as the rowId option is used to specify a unique id for each row (this will work for arrays as well as objects - DOM sourced data as well if you happen to then want to replace it with Ajax sourced data).

Allan

lycan

Thanks for your responses. But i am using version 1.10.7 and it is giving me an error of
Object doesn't support property or method 'ids' When i try select as an extension.

jLinux

Upgrade your datatables

allan

Yes - as the documentation for rows().ids() notes, that method was introduced in 1.10.8. 1.10.9 is the current release.

Allan

lycan

Thanks everyone. I upgraded to 1.0.9 and with some tweaks i got what i wanted.