Cleaning the jobslist

Post any question regarding setting up, running or configuring Verj.io Workflow

Moderators: Jon, Steve, Ian, Dave

Vircos
Ebase User
Posts: 97
Joined: Thu Sep 13, 2007 6:07 am
Location: The Netherlands

Cleaning the jobslist

#1

Postby Vircos » Mon Nov 12, 2007 10:40 am

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?
0 x
What's the meaning of Justice...

User avatar
Wai
Moderator
Moderator
Posts: 165
Joined: Wed Sep 12, 2007 9:04 am
Location: Sandy, UK
Contact:

#2

Postby Wai » Mon Nov 12, 2007 2:57 pm

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.
0 x

Vircos
Ebase User
Posts: 97
Joined: Thu Sep 13, 2007 6:07 am
Location: The Netherlands

#3

Postby Vircos » Tue Nov 13, 2007 9:41 am

It does, I didn't thought about working directly in the SQL database.

Thanks again Wai :)
0 x
What's the meaning of Justice...

Jon
Moderator
Moderator
Posts: 1342
Joined: Wed Sep 12, 2007 12:49 pm

#4

Postby Jon » Tue Jan 29, 2013 9:28 am

Also need to add:

delete from workflow_table_attr_values;
0 x


Who is online

Users browsing this forum: No registered users and 2 guests