Delete - Requests

[Salma Sarwar]

Hi 

Is there a way we can bulk delete requests that have a certain summary using SQL script.  

 

Kind Regards,

 

Salma

[James Ainsworth]

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]

@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]

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]

@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