uniDBGrid: Save Multi Selection and restore it

[M.Ammar]

Hi

I am Trying to save user selection in a multi selection Grid, and then restore the selection again to the grid.

because after posting some values in the table the selection will be no longer available. 

Best regards.

[Sherzod]

20 hours ago, M.Ammar said:

because after posting some values in the table the selection will be no longer available. 

Hello,

Do you mean an insert operation, or also an edit?

[M.Ammar]

4 hours ago, Sherzod said:

Hello,

Do you mean an insert operation, or also an edit?

Hi

No Insert Operation in this Form, All Edit but I post values to the data source Via Looping Selected Rows  

   try
      FDQry.DisableControls;
      for I := 0 to UniDBGridList.SelectedRows.Count - 1 do
      begin
         FDQry.Bookmark := UniDBGridList.SelectedRows[I];
         FDQry.Edit;
         FDQrydeedTyName.AsString := UniCBDeedTyName.Text;
         FDQry.Post;
      end;
   finally
      FDQry.EnableControls;
      UniDBGridList.Refresh;
   end;

so It Causes the selection to be at the last Selected Row after refreshing Grid

 

[M.Ammar]

Hi Sherzod

I found one old topic that you have provided a solution and it is working but I have 2 issues

procedure TfrmReptTransactionManagment.RestoreSelection();
var
   DBGridJSName: string;
   I: Integer;
begin
   DBGridJSName := UniDBGridList.JSName;
   for I := 0 to SelectionList.Count - 1 do
   begin
      DBGridJSName := UniDBGridList.JSName;
      UniSession.AddJS(DBGridJSName + '.getSelectionModel().select(' + DBGridJSName + '.getStore().data.indexOfKey(' + SelectionList[I] + '), true)');
   end;
end;

1- calling this restore directly after the post action don't work I think because the grid in refresh, I had to use a button to call it after the post, is there is another way to call it after the grid refreshed?

2- I need to unselect any other selected rows before restoring the selection.

Regards

[M.Ammar]

what dose option dgPersistentSelection do?

[mhmda]

hi

[Tokay]

2 hours ago, M.Ammar said:

what dose option dgPersistentSelection do?

You can look at the code, it can happens in the two places:

    if not (dgPersistentSelection in FOptions) then
      FBookmarks.Clear;

[M.Ammar]

3 hours ago, mhmda said:

This is a client-side code and it happens after loading data 😉

thank you mohamed for your help 

procedure TfrmReptTransactionManagment.UniDBGridListAjaxEvent(
   Sender: TComponent; EventName: string; Params: TUniStrings);
begin
   if EventName = 'load' then
      RestoreSelection();
end;

it correctly call the restore procedure as you expected, but for some reason it is not working, but if I called by UniButton it works and I restore all selections.

regards 

[mhmda]

Easy, then call your button from the js code (at load event as shown in picture like this:)

MainForm.mybutton.fireEvent('click',MainForm.mybutton);

Remember for security issue the button should be visible otherwise it will not work (at design time) in order to hide it @ runtime then use UniEvents->beforeInit and set hidden to true:

function beforeInit(sender, config)
{
  config.hidden=true;
}

OR

Put your button on UniHiddenPanel 🙂

[M.Ammar]

17 hours ago, mhmda said:

Easy, then call your button from the js code (at load event as shown in picture like this:)

MainForm.mybutton.fireEvent('click',MainForm.mybutton);

Remember for security issue the button should be visible otherwise it will not work (at design time) in order to hide it @ runtime then use UniEvents->beforeInit and set hidden to true:

function beforeInit(sender, config)
{
  config.hidden=true;
}

OR

Put your button on UniHiddenPanel 🙂

thanks again for your help I am learning a lot from you 🙂

it has the same outcome,  I noticed that the selection is resorted successfully in the grid but it is not visibly selected, if edited again all old selection is modified correctly, the only issue is that only one selection is Visible

I Modified one of the demos to explain.

first select more than one record then click edit button , change category and click again you will see the issue

GridMultiSelect - Checkbox.rar

[Sherzod]

3 hours ago, M.Ammar said:

GridMultiSelect - Checkbox.rar 3.11 MB · 1 download

function store.load(sender, records, successful, operation, eOpts)
{
    Ext.defer(function() {
        ajaxRequest(sender, '_load', [])
    }, 20);
}

procedure TMainForm.UniDBGrid1AjaxEvent(Sender: TComponent; EventName: string;
  Params: TUniStrings);
begin
  if EventName = '_load' then
    RestoreSelection

end;

 

[M.Ammar]

39 minutes ago, Sherzod said:

function store.load(sender, records, successful, operation, eOpts)
{
    Ext.defer(function() {
        ajaxRequest(sender, '_load', [])
    }, 20);
}

procedure TMainForm.UniDBGrid1AjaxEvent(Sender: TComponent; EventName: string;
  Params: TUniStrings);
begin
  if EventName = '_load' then
    RestoreSelection

end;

 

 

I really don't know how to thanks you enough for this one

[mhmda]

You can send me PM 🙂