Generating Current Workflow Reports

Overview

 

This article provides the SQL query that you need to run to generate a report of the current workflows that are assigned to particular pages of a site.

 


Process

 

Go to Settings > SQL Console and run the following query:

SELECT DISTINCT Tabname, t.PortalID, CASE 
    WHEN WorkFlowName is Nukk THEN (SELECT WorkflowName from ContentWorkflows where WorkFlowID IN (Select TOP 1 SettingValue from PortalSettings where SettingName = 'DefaultTabWorkflowKey')) 
    ELSE WorkFlowName 
END AS WorkFlowName 
FROM Tabs t INNER JOIN ContentItems c on  c.tabid = t.TabID 
LEFT OUTER JOIN ContentWorkflowStates cws on  c.StateID = cws.StateID 
LEFT OUTER JOIN ContentWorkflows cw on cw.workflowid = cws.WorkflowID 
where  C.moduleid = -1 order by t.TabName, t.PortalID 

mceclip0.png

 

back to top

Comments

0 comments

Please sign in to leave a comment.