Snippets

Login

Knowledge Sharing

Home

Code Snippets

Snippets

Cleanup All Workflows using SQL

Written by James Azarja

Tuesday, 17 February 2009 15:59

DELETE FROM dm_workflow_s
DELETE FROM dm_workflow_r
DELETE FROM dmi_workitem_s
DELETE FROM dmi_workitem_r
DELETE FROM dmi_package_s
DELETE FROM dmi_package_r
DELETE FROM dmi_queue_item_s

Make sure you've create a backup, before try to run this SQL statements

Add Comment (1)

Get All User's Group

Written by Administrator

Monday, 09 February 2009 23:23

1	SELECT group_name FROM dm_group WHERE any i_all_users_names = '<username>'

Add Comment (0)

Getting User Task From Workqueue

Written by Administrator

Monday, 09 February 2009 19:10

	public IWorkQueueMgmt createWorkQueueService(IDfSessionManager paramIDfSessionManager, 
              String paramString)
	throws DfException
	{
		IWorkQueueMgmt localIWorkQueueMgmt = (IWorkQueueMgmt)new DfClientX().
                    getLocalClient().newService(IWorkQueueMgmt.class.getName(), paramIDfSessionManager);
		localIWorkQueueMgmt.setDocbase(paramString);
		return localIWorkQueueMgmt;
	}
 
	public IDfId getNextTask(String username)
	{
		Object userQueue;
		IDfId localIDfId1 = null;
		try
		{
 
			IWorkQueueMgmt workqueueManagement = createWorkQueueService(
                                 session.getSessionManager(), 
                                 session.getDocbaseName());
			userQueue = workqueueManagement.getUserQueue(username);
			IDfId taskId = ((IUserQueue)userQueue).pullNextTaskEx(null);
			if (taskId == null)
			{
				System.out.println("No Workqueue Task");
			}
			else
			{
				IDfWorkitem localIDfWorkitem = (IDfWorkitem)session.getObject(taskId);
				localIDfId1 = localIDfWorkitem.getQueueItemId();
			}
		}
		catch (DfException localDfException1)
		{
			localDfException1.printStackTrace();
		}
		return ((IDfId)localIDfId1);
	}