Grid Edit on filtered list - Error - No Records Found.

[Schbal]

Hey! 

I have created a basic table with some basic data, then I created a data page with some filter and grid edit capability, and then the following happened: 

I used the filter and got some data that I wanted to modify. I switched to grid edit mode, then made modifications on a record,  I have modified the data that I used to filter by. Then I clicked out from this row, It saved it successfully. It was still in the grid edit list, even though it no longer met the filter criteria. But I clicked back to this row, to make one more modification on a data, but when I tried to click out to save, it threw this error: No record found. 

1. Filter by Search flag:
 

2:  Modified and saved the Test row Search Flag to No (Note: Filtered by search flag to be marked):

3. Clicked back to the second row to modify the Name too. I tried to rename Test to Test1

4. When I tried to save (with clicking out) I have got the error above. 

Is there any workaround to this problem? Well it looks like a bug to me, and already reported this. But maybe somebody have a trick to this.

[cheonsa]

Hello @Schbal,

The result seems to be expected for me. When searched for a record, then modify it, the updated record will not meet the applied criteria anymore. If you try to edit it again on the same grid, it will throw you an error since in the result, it should not be included.

As a workaround, after you modify the record, then if will not meet the criteria, it's better to exit the grid edit option first, then enable it again.

You can also open a support ticket so Caspio's support team can confirm.