Find all documents in process awaiting user input

Created by Jeremy Burgess, Modified on Wed, 15 Jul, 2020 at 11:17 PM by Jeremy Burgess

The following query will give a full list of documents in process where user input is required.

ORDER BY ud.DocGUID ensures that all actions relating to a single document are grouped together.

SELECT	ud.ProcessName,
		p.Name as StepName, 
		ud.IdentityName as ProcessUser,
		doc.*,  
		ud.*
FROM	UserDocs ud
INNER JOIN FD_Documents doc ON ud.DocGUID = doc.GUID
INNER JOIN ProcessManagement p ON p.ID = ud.ProcessDefID AND p.Step = ud.ProcessStep
WHERE	ud.ActionResponse = -1 
AND	ud.Deleted <> 1
ORDER BY ud.DocGUID, ud.ProcessName