FlowMatrix Admin Panel -- Subset of jobs in a paricular state -- Requirement to make them visible to users by moving job states.
Quick Action (If the moved state is in the same process queue):
Below is an example of moving a job from QD_Recycle_Bin to QD_Validation_Work_List. It can be classified as a quick action as all handlings is done in the Admin panel.
- Suspend the job in question first.
- Double click and open the job
- Untick the "Locked" checkbox
- Select the dropdown and pick "QD_Validation_Work_List"
- Click the "Apply" button to set it into the new workflow state.
- Close and resume the job again.
Scenario:
- A job is partway in process and stuck in a state where it can't be shifted at all unless manually moved.
- A job was accidentally deleted and needs pushing back into MailRoom or in QuickDrop.
Note: No automated errors are likely to arise from this and will probably be manually raised by the client.
Action (If it is not and has to be done via SQL):
For more involved issues (for instance a job is stuck in a QuickDrop workflow section but needs pushing back to MailRoom) The order of actions would be the following:
- Suspend the job/s in question.
- Open up SQL Management Studio
- From here the UPDATE query on the FlowMatrix.Jobs table:
UPDATE [FlowMatrix].[dbo].[Jobs]
SET [process_id] = 'REQUIRED_PROCESS_ID'
,[workflow_id] = 'REQUIRED_WORKFLOW_ID'
,[queue_id] = 'REQUIRED_QUEUE_ID'
WHERE [job_id] = 'JOBID1' OR [job_id] = 'JOBID2' ... OR [job_id] = 'JOBIDn'
Will need to be run. The id's for all three of the fields different from customer site to site and will need to (if not known) be looked at and found first before running (possibly doing a SELECT query on an existing job in the desired
state already will be the more efficient way of doing so).
- Once run the suspended jobs can then be resumed; they will resume in the desired workflow queue states.