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
Comments
0 comments
Please sign in to leave a comment.