Mass report deletion
Currently we are having a clean up process in our Archer environment.
We have around 1600 reports that needs to be deleted permanently(most of them from archived applications and questionnaire).
Are there any SQL query to perform the deletion task (based on the report ID, application ID etc)
Or do we have any other method to perform this bulk deletion.
version : 6.9 sp1 p2
Can the applications and questionnaires be marked as "Retired" instead of "Archived"? This removes all traces of the application, including reports and content, from the UI while leaving it intact in the system in case it were to need to be restored.
When the Master Reports page was replaced, some internal API calls were exposed and can be taken advantage of including the ability to delete report based on report id.
Delete a specific report:
To get a list of global reports with ids and names:
URL: /api/V2/internal/MasterReports?$select=SolutionName,ModuleName,ReportTypeDisplayColumnString,Id,Name,LastUpdatedBy&$filter=ReportType eq 2&$count=true&$orderby=SolutionName,ModuleName,Name