For I-don't-know-how-many-years we've had a checkout survey on our TNEW site that generates a CSI that just says "I read the terms and conditions" and serves no purpose other than cluttering up the CSI tab by making any other CSIs unfindable...I finally got the go-ahead to remove the checkout survey, but can anyone tell me how to bulk-delete CSIs? This CSI has its own Category and Activity type so it should be fairly easy to isolate.
Hi Erin thanks for posting! If you're still looking for an answer I'd suggest also cross-posting to the Database Managers community group. Hopefully you'll receive some replies over there.
- Gill Tasker, Community Manager
I believe the safe answer is just use the "Customer Service Issue Closure Utility", if they are not already closed.
However, in the past I wrote python script to call the api "/TessituraService/CRM/Issues/{actionId}" with a DELETE request (for each issue number in a CSV) because that is what the TESS application was doing in the logviewer.But it looks like all WP_MAINTAIN_ACTIVITIES does is:
Delete t_special_activity Where sa_no = @sa_no