Flexigrid: selection of rows to survive refresh

Question

I am using flexigrid in a project and I would like to be able to keep the selected rows after the grid is refreshing. I asked the same question on the flexigrid discussion board and I got this answer:

Add a click handler, save the id if the row id of the row selected. On refresh completion, select the row again (if still present)

Not sure how to proceed on this, I don't even know how a function will look like, so that's why I don't have any code to start with.

If someone could point me in the right direction will be greatly appreciated.

Thanks,

Cristian.

score 2 · Answer 1 · answered Sep 30 '11 at 03:51

Flexigrid adds a class called trSelected to selected rows, so whenever a click event happens on the grid you could just look for all the selected rows and save them in some way. Below is just a quick example of what you could do:

var selectedRows = new Array();

$('#myGrid').click(function() {
    selectedRows = new Array();

    $(this).find('tr.trSelected').each(function(i, selectedRow) {
        selectedRows.push($(selectedRow));        
    });
});

score 1 · Accepted Answer · answered Jul 20 '12 at 15:19

I have done small code to keep multi-selection between pagination and also during refresh.

    $("#searchPhonoList").flexigrid($.extend({}, flexigridAttrs, {
        url: './rest/phono/search',
        preProcess: formatSearchPhonoResults,
        onSuccess: successSearchPhono,
        onSubmit: submit,
        method: 'GET',
        dataType: 'json',
        colModel : [
            {display: 'titre', name: 'titre_brut', width : 240,  sortable : true, align: 'left'},
            {display: 'version', name: 'version_brut', width : 60,  sortable : true, align: 'left'}
        ],
        height: "auto",
        sortname: "score",
        sortorder: "desc",
        showTableToggleBtn: false,
        showToggleBtn: false,
        singleSelect: false,
        onToggleCol: false,
        usepager: true, 
        title: "Liste des candidats",
        resizable: true,
        rp:20,
        useRp: true
    }));  

    var searchPhonoListSelection = new Array();

    $('#searchPhonoList').click(function(event){

        $(' tbody tr', this).each( function(){
            var id = $(this).attr('id').substr(3);
            if ( searchPhonoListSelection.indexOf(id) != -1 ) {
                searchPhonoListSelection.splice(searchPhonoListSelection.indexOf(id), 1);
            }
        });

        $('.trSelected', this).each( function(){
            var id = $(this).attr('id').substr(3);
            if ( searchPhonoListSelection.indexOf(id) == -1  ) {
                searchPhonoListSelection.push(id);
            }
        });
    });


    function successSearchPhono() {
        $("#searchPhonoList tbody tr").each( function() {
            var id = $(this).attr('id').substr(3);
            if ( searchPhonoListSelection.indexOf(id) != -1 ) {
                $(this).addClass("trSelected");
            }
        });
    }

Flexigrid: selection of rows to survive refresh

2 Answers2