How to Delete records from production Database server ?
Application Type
Mobile, Reactive
Platform Version
11.14.1.34396

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:

  1. Maintain one flag in table as "Is Visiable" - you can hide the record by this flag.
  2. Create one Dummy entry on the production env. and consider it as a "False- Positive"
  3. Create one entry with exiting data.

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

mvp_badge
MVP

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.

Thank you Everyone for your Responses.


I am sharing few other ways to overcome this scenarios:

  1. Maintain one flag in table as "Is Visiable" - you can hide the record by this flag.
  2. Create one Dummy entry on the production env. and consider it as a "False- Positive"
  3. Create one entry with exiting data.
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.