November Happy Hour will be moved to Thursday December 5th.

Clearing OrderReportData

Vote:
 

Commerce 13.3.1

With the introduction of 

IReportDataGenerator

Is there an exposed API that would allow us to clear down the table without creating a sproc? We're trying to sanitize PII data when bringing down production databases and while we're able to delete/obfuscate orders, contacts etc I am unable to find anything that would allow us to remove this data.

Any tips?

#206448
Aug 21, 2019 14:25
Vote:
 

Once you obfuscated order data, if you run the collect report data again it should generate new report data and overwrite existing one. If that is not the case then it is safe to truncate the table.

There is currently no api to clear report data, but we might look into it

#206449
Aug 21, 2019 14:52
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.