Question about assignments/tasks
Comments
-
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. -
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.
-
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.
Howdy, Stranger!
Categories
- 4.4K All Categories
- 81 General
- 13 Training
- 209 Installation / Setup
- 1.2K Flows
- 110 Rules
- 270 Administration
- 213 Portal
- 497 General Q & A
- 711 Forms
- 346 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 187 Pages
- 5 Process Mining
- New Features
- 186 Datastructures
- 70 Repository
- 230 Integrations
- 29 Multi-Tenant
- 27 SDK
- 81 Modules
- 59 Settings
- 26 Active Directory
- 12 Version 7
- 35 Version 8
- 143 Lunch And Learn Questions