[CLOSED] How to access the original data/rows bound to the GridPanel which are invisible after applying filter.

[Tarun_Chand]

Hi Team,

I have a GridPanel in which i have a CheckColumn.
When there is change in the check box selection of any rows, I have to run a logic which should read the the whole store and based on the some columns data it will select checkboxes of those rows also. To do this i have a checkchange listner on this column which go and check other column for some data and select the checkboxes of those rows.

==== C# code =========

colSW.Listeners.CheckChange.Handler = "onColumnCheckChange(column, rowIndex, record, #{" + grid.ID + "});";

===================

========== Java Script =============

  var onColumnCheckChange = function(column, rowIndex, record, grid) {
                var gridStore = record.store;

                gridStore.each(function(curRecord, index) {
                    if (index !== rowIndex) {
                        //check/uncheck(based on current action) the checkboxes of the all the other rows which has submitflag = "Y"
                       if(curRecord.data.submitflag =="Y")
                                curRecord.data.SUBMIT_TO_WORKFLOW_FLAG = record.data.SUBMIT_TO_WORKFLOW_FLAG;
                    }

                });
                           
                gridStore.commitChanges();

         }

===============================

It works fine when I check any column which will read the whole store and check for other rows which satisfy the required condition and select checkboxes of those rows also.

But when there is a filter applied and after that if i select some checkbox in the rows left, i am not able to read those other rows which arent visibile because of the filter applied, so when i remove the filter those related column which satisfy the required condition will remain un-checked.

I need your help to know how to access the whole store(GridPanel rows data, including rows which are not visible because of the applied filter) when there is a filter applied.

Please refer some screenshots attached.

And also what is the best method to save the store of a perticular row (after check/uncheck of a column) without losing the focus on the row where user has checked the checkbox.

[Vladimir]

Hi,

Try this

var onColumnCheckChange = function(column, rowIndex, record, grid) {
    var gridStore = record.store,
        temp;

    if(gridStore.snapshot){
        temp = gridStore.data;
        gridStore.data = gridStore.snapshot;
    }
 
    gridStore.each(function(curRecord, index) {                 
        // make required actions with records
    });

    if(temp){
        gridStore.data = temp;
    }
                          
    gridStore.commitChanges(); 
};

[Vladimir]

And also what is the best method to save the store of a perticular row (after check/uncheck of a column) without losing the focus on the row where user has checked the checkbox.

What do you mean "save"? Do you mean apply changes to grid? If yes then grid rerender row (element in the grid) to display changes therefore focus can be lost

You can reselect row to return focus (may be need to clear selection before)

grid.view.getSelectionModel().select(indexOfRow);
grid.view.el.focus();

[Tarun_Chand]

Hi,

Try this

var onColumnCheckChange = function(column, rowIndex, record, grid) {
    var gridStore = record.store,
        temp;

    if(gridStore.snapshot){
        temp = gridStore.data;
        gridStore.data = gridStore.snapshot;
    }
 
    gridStore.each(function(curRecord, index) {                 
        // make required actions with records
    });

    if(temp){
        gridStore.data = temp;
    }
                          
    gridStore.commitChanges(); 
};

Vladimir,

It works as expected, thanks for the quick solution, I appreciate.

[Tarun_Chand]

What do you mean "save"? Do you mean apply changes to grid? If yes then grid rerender row (element in the grid) to display changes therefore focus can be lost

You can reselect row to return focus (may be need to clear selection before)

grid.view.getSelectionModel().select(indexOfRow);
grid.view.el.focus();

Vladimir,

I want the row on which initial checkbox event was triggered, to be focused(not selected) after changing/committing the store changes.

[Daniil]

to be focused(not selected)

Please clarify what exactly do you mean under "focused"?

[Tarun_Chand]

Please clarify what exactly do you mean under "focused"?

Daniil,

Thanks for responding, please check this attached screenshot where I have explained the scenario and the expected result with grid images.



Thanks for your time.

[Daniil]

Thank you for the explanation.

I think the focusRow method can help.
http://docs.sencha.com/ext-js/4-1/#!...ethod-focusRow

Example

App.GridPanel1.getView().focusRow(index);

[Vladimir]

Try to set PreserveScrollOnRefresh="true" for GridView
See http://docs.sencha.com/ext-js/4-1/#!...crollOnRefresh

[Tarun_Chand]

Thank you for the explanation.

I think the focusRow method can help.
http://docs.sencha.com/ext-js/4-1/#!...ethod-focusRow

Example

App.GridPanel1.getView().focusRow(index);

Daniil,

This is what I really wanted. Thank you Daniil.