Data Table Should Stay on Current Page After Deleting a Row

Scenario Description

By default, after deleting a row in a data table, it resets to the first page. In some business scenarios, it is necessary to keep the current page number unchanged after deletion.

Implementation Steps

1. Create two numeric variables: wantPagNo, changePagNo

   • wantPagNo: default page number, default value is 1, the data table's page number property is bound to this variable.

   • changePagNo: stores the current page number, default value is 1, its value is updated by the data table's pagination event trigger assignment.

     

2. Bind the data table's page number to the variable wantPagNo, set to

3. In the data table pagination event, assign the current page number to the variable changePagNo.

4. Execute the expression method in the data table's delete row button

({ event }) => {
  // Reset the default page number to 1
  $w.page.dataset.state.wantPagNo = 1;
  // Reassign the default page number
  $w.page.dataset.state.wantPagNo = $w.page.dataset.state.changePagNo;
};