Today my task was to find out what workflows are changing particular field within particular table. I could go through all the workflows and all the data-writers and check. But I have hundreds to choose from, I’ll spend all day trying to do it. And there will be no guarantee that I find them all and not missed anything.
For that task I came up with SQL request that shows you all the workflows, and even folder structure where to find them.
Here you go:
select pppf.folder_name as [Folder], ppf.folder_name as [Folder], pf.folder_name as [Folder], f.folder_name as [Folder], flow.workflowname, flow.description, flow.allowstart from OC_WORKFLOWDATAWRITERFIELDS fields inner join OC_WORKFLOWS flow on fields.workflowid = flow.workflowid left join OC_ADMINCONSOLE_FOLDERS f on flow.folderid = f.folder_id left join OC_ADMINCONSOLE_FOLDERS pf on f.parent_id = pf.folder_id left join OC_ADMINCONSOLE_FOLDERS ppf on pf.parent_id = ppf.folder_id left join OC_ADMINCONSOLE_FOLDERS pppf on ppf.parent_id = pppf.folder_id where fields.tablename = 'JOBDETAIL' and fields.fieldname = 'PRINCIPALJOB' order by flow.workflowname
Obviously you’ll need to replace FIELDNAME and TABLENAME to required to you. I’m sure there would be a better way to find out folder structure, but for this purposes this will be as good as any: quick and dirty.