Question about assignments/tasks
Comments
-
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. -
Hi,
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.
Thank you.