Query to Find Batch Processing Order

Issue

Where to find the batch priority of what will be processed next?

Solution

The following query will find batches in Kofax Capture database and will sort them based on what will be processed next in the queue:

SELECT b.BatchName, b.processID, f.Name, b.State, b.Priority, b.ProbablyInUse, b.CreationDate, b.DequeueTime
FROM BatchCatalog b
JOIN Processes f on f.ProcessID = b.ProcessID
WHERE b.CreationDate > '2017-01-20 7:50 am'
ORDER BY b.Priority, b.ProbablyInUse, b.CreationDate desc

Level of Complexity 

Moderate

Applies to  

References

Add any references to other internal or external articles