How to refresh the record list after a "soft delete"?

How do I?
1

Hello,

I have implemented a “soft delete” functionality by adding a IsDeleted field to my table. In y form, I added a condition to the Data Filter to only show records where ‘IsDeleted = 0’.

I created a custom button to perform the soft delete. However, I’m having trouble refreshing the interface:
When I trigger the soft delete, the form closes correctly using five.selectAction(“MyForm”) in the ‘On Finish’ event but the record list still shows the deleted item.

Is there a way that the record disappears from the list as soon as the soft delete function is executed ?

Note: The “undelete” function works fine when using a live query with the data view.

See the following gif. I also included the fdf application sample.

soft-delete

Thank you!

Jean

TestSoftDelete-20260503-224657605906961.fdf (3.4 MB)

2

Hi Jean,

Thank you for bringing up this question and for the details.

The issue you are facing is that the delete is not signalling to the form that a change has been made.

I will provide a workaround. Please let me know if that works.

function RefreshCurrentForm(five, context, result)  {

five.selectMenu('Recyclebin')

five.selectAction("Fruits");

return five.success(result);

}

This will mimic the user leaving the form and returning, and that should give you the refreshed form after you update the table.

Observation:
Just to let you know, in the next version, which we are working on at this moment, you will only need to add the method ‘five.refreshTable(“Fruits”);’ in the function SoftDeleteFruit after you perform the Update, this will force the form and any live query that uses this table to update.

Regards,

Elton S

3

Hi Elton,

Great! works fine on the sample and on my application, thank you!

Regards,

Jean