How do I reset the database after testing data insertion in a published application?

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á

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


Solution

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!


Kind regards,

Rui Barradas

Solution

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-