Question about assignments/tasks

Unknown

Question about assignments/tasks

Unknown

Unknown

The table in the database where these are stored is entity_assignment. Are you trying to clear all current assignments? If so the queries you can use would be:

select * from entity_assignment where state = current

Run the select query to make sure you have all the rows you want selected, and then use the bellow delete query. Please note: This will delete ALL current assignments for everyone, so if you may need to modify these queries to select a smaller set of data. Id be happy to jump on a call to help get the proper assignments deleted if you want.

delete from entity_assignment where state = current
Where all these assignments generated in error? If a process is accidentally creating thousands of assignments, Id be glad to help troubleshoot and figure out why so this issue doesnt keep reoccurring for you.

Unknown

That helped greatly! I found out what was happening – we did a bulk run of our workflows and one API that we call all the time was failing.

Unknown

Hello,

Is there any way to delete these assignments out of the decisions database?? The gui is not rendering because of the amount out there.

Thank you.