I tried to create a jobstlist cleaner which will clean up the jobslist and the related audits, tasks and processattributes. However some of the provided custom resources do not support looping through a table, deleting rows or updating the table.
I want to clean this up because by testing the workflowprocess in forms the jobslist has grown a lot.
Is there a way to clean up the jobslist and the related items?
Cleaning the jobslist
Moderators: Jon, Steve, Ian, Dave
-
- Ebase User
- Posts: 97
- Joined: Thu Sep 13, 2007 6:07 am
- Location: The Netherlands
- Wai
- Moderator
- Posts: 165
- Joined: Wed Sep 12, 2007 9:04 am
- Location: Sandy, UK
- Contact:
You can remove them from the UFSREPOSITORY database tables by creating and executing a SQL script with the following statements:
delete from workflow_attribute_values;
delete from workflow_history;
delete from workflow_job;
delete from workflow_nodeenactment;
delete from workflow_workitem;
delete from workflow_workstream;
These statements will remove all your jobs, so only use in a development or testing environment.
You can alter the statements to include the Process Name/ID or the Job ID in the Where clause.
Hope that helps.
delete from workflow_attribute_values;
delete from workflow_history;
delete from workflow_job;
delete from workflow_nodeenactment;
delete from workflow_workitem;
delete from workflow_workstream;
These statements will remove all your jobs, so only use in a development or testing environment.
You can alter the statements to include the Process Name/ID or the Job ID in the Where clause.
Hope that helps.
0 x
-
- Ebase User
- Posts: 97
- Joined: Thu Sep 13, 2007 6:07 am
- Location: The Netherlands
-
- Moderator
- Posts: 1342
- Joined: Wed Sep 12, 2007 12:49 pm
Who is online
Users browsing this forum: No registered users and 8 guests