Hello! How do I reset the database after testing data insertion in a published application?
I made an application to register new products in a table, but after inserting the products and having tested the application, I can't delete it to start the application without data. I'm new to outsystems and haven't found this information here yet.
In advance, thank you very much for those who help me.
Kind regards,
Luiz Jucá
Hello Luiz,
There are several ways to do that.
Usually, I do it using a Web Screen (that can be deleted afterwards) with a button. The button is going to call a Server Action with an SQL statement on it.
Please refer to this documentation that shows exactly the referred method:
https://success.outsystems.com/Documentation/How-to_Guides/Data/How_to_delete_data_from_Entities
Hope that this helps you!
Rui Barradas
Hi Luiz,
See below forum post-
https://www.outsystems.com/forums/discussion/64942/how-to-remove-all-records-from-datatable/
Hope this will help you.
Regards
Rahul
Hi Louis,
I see the below forge component as a good tool to cleanup your environment . Please see if it can be
https://www.outsystems.com/forge/component-overview/5018/db-cleaner-on-steroids
Regards,
-PJ-