Re-sorting after inserting/deleting rows

Is there a way of maintaining the grid sort after inserting or deleting rows. I have tried using the following code but it does not work.

Thanks in advance for any help.

function addRow()

{

    var rowData = ["1", "2", "3", "4", "5"];

    myData.push(rowData);



    // re-initialize the data values

    obj.setDataProperty("count", myData.length);



    // re-initialize the row values

    var newCount = obj.getDataProperty("count");

    var rowValues = [];

    var sort_value = obj.getSortProperty("index");

    

    for(var i=0; i < newCount; ++i) { rowValues[i] = i; }

    obj.setRowProperty("values", rowValues);

    obj.setSortProperty("index", -1);

    obj.setSortProperty("index", sort_value);



    // refresh the grid

    obj.refresh();

}

After some experimentation I have solved my problem and though it would be worth sharing my results.

The functions below can be used to maintain the current sort whilst inserting or deleting rows from the grid. It should be noted that when inserting the new row always appears at the end of the grid.

Hope someone finds this useful.

function addRow()

{

    var rowData = ["", "", "", "", ""];



    // Save existing sort values

    var array = obj.getRowProperty("values");



    // Add an extra row

    myData.push(rowData);



    // re-initialize the data values

    obj.setDataProperty("count", myData.length);



    // Reset sort property (does not re-sort propertly if this is not done

    obj.setSortProperty("index", -1);



    // Put back the sort values (new row stays at bottom of grid)

    array.push(myData.length-1);

    obj.setRowProperty("values", array);



    // refresh the grid

    obj.refresh();

}



function removeRow()

{

    var index = obj.getProperty("selection/index");



    if (index != -1 && confirm("Are you sure?"))

    {

        // Get existing sort values, re-number then deleted element

        var array = obj.getRowProperty("values");

        var splice_point=-2;

        var new_selected_row=-1;

 

        for (var i=0;i<array.length;i++)

        {

            if (array[i] == index)

                splice_point=i;



            if (array[i] > index)

                array[i]--;



            if (splice_point == i-1)

                new_selected_row=array[i];

        }



        // Check the values are ok just to be sure

        if (splice_point >= 0)

            array.splice(splice_point,1);

        if (new_selected_row == -1)

            new_selected_row=array[array.length-1];



        myData.splice(index,1);

        obj.setRowProperty("count", myData.length);



        // re-initialize the data values

        obj.setDataProperty("count", myData.length);



        // Put back the sort values

        obj.setRowProperty("values", array);

        obj.setProperty("selection/index",new_selected_row);



        // refresh the grid

        obj.refresh();

    }

}

thanks rag
I don't understand everything but it works perfect.
it answers my last question

you are great

Great job on this add and remove function. I can use this perfectly (thumbs up).

I need to do the same thing, but with multiple rows. I select rows 1,3,4 and then I want to click a button to remove the rows. How can I do that?

Hi

I tried to use the example given by Rag! to insert a new row via javascript in a grid but it doesn't works in my scripts. What I'm doing wrong ?

This is the code:
vArray = split(pResponseText, ";")
obj_data.push(vArray);
obj.setDataProperty("count", obj_data.length);
obj.setRowCount(obj_data.length);
obj.refresh();

When I run the script, I receive the error message: obj_data[...] is null or not an object.

Thank you very much!

Forum search