Hello,i am doing smoke testing on the Live production database. after my testing i want to delete my testing record from database of the production server.
i have read the document from outsystem- https://success.outsystems.com/Support/Enterprise_Customers/Maintenance_and_Operations/Access_the_database_of_your_OutSystems_Cloud
but its not working for me.
please suggest me the correct solution ?
Thank you Everyone for your Responses.
I am sharing few other ways to overcome this scenarios:
Hi Bhushan,
Please check below documentation. You can execute delete query using SQL widget.
https://success.outsystems.com/Documentation/How-to_Guides/Data/How_to_delete_data_from_Entities
Thanks
Vinod
Hi,
You can use https://www.outsystems.com/forge/component-overview/5900/sql-sandbox to run delete or bulk delete SQL statements (at your own risk) on any OutSystems environment, including production.
Access to the features of this application can be governed by assigning roles to users or user groups.
Regards,
Daniel
Hi,I consider the SQL Sandbox a good way to do it, but the best way to do it, in my opinion, althought not the fastest way, is requesting access to the DB.
Anyway, why you are performing tests in production?
Cheers,
JS.