Salma Sarwar Posted February 9, 2023 Posted February 9, 2023 Hi Is there a way we can bulk delete requests that have a certain summary using SQL script. Kind Regards, Salma
James Ainsworth Posted February 9, 2023 Posted February 9, 2023 Hi Salma, Thanks for your post. There is no access to run SQL. Because of the relationship between entities, it would be very dangerous to run SQL, and a likelihood of corrupting the database. From the Request List, you can filter requests by summary and then select the requests that you don't want and cancel them in bulk. Canceling will remove all active tasks and also cancel the workflow. Just deleting a request would leave the activities and bpm in place. Is there a particular reason why you feel these need to be deleted rather than canceled?
Salma Sarwar Posted February 10, 2023 Author Posted February 10, 2023 @James Ainsworth thank you for your reply as we have managed to created 900 requests incorrectly, I needed a mechanism to delete these requests. Kind Regards, Salma
James Ainsworth Posted February 10, 2023 Posted February 10, 2023 Hi Salma, You may want to reach out to our services team to have a look. They have tools that would allow them to do this.
Martyn Houghton Posted February 14, 2023 Posted February 14, 2023 @Salma Sarwar You can use the Hornbill Clean Utility as detailed in the wiki. Just make sure you run in dry run mode to check what its going to delete first as there is no way back. https://wiki.hornbill.com/index.php?title=Hornbill_Clean_Utility Cheers Martyn
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now