Find all documents in process awaiting user input

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