Find workflows triggered on particular fields

This blog is not dead! It’s been a while since my last post here, but I’m back with some fresh ideas and scripts. Thanks to my new assignment with HR.Net.

If you would like to find all the workflow triggers that are triggered on a particular field in a particular table, run this sql against hrnet database

select 
	pppf.folder_name as [Folder],  
	ppf.folder_name as [Folder],  
	pf.folder_name as [Folder],  
	f.folder_name as [Folder],  
	tbl.TRIGGERNAME,  
	tbl.description,  
	tbl.ONINSERT,
	tbl.ONUPDATE,
	tbl.ONDELETE
from OC_WORKFLOWTABLETRIGGERS tbl
	inner join OC_WORKFLOWTABLETRIGGERFIELDS flds on tbl.TRIGGERNAME = flds.TRIGGERNAME
	left join OC_ADMINCONSOLE_FOLDERS f on tbl.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 tbl.TABLENAME='JOBDETAIL' and FIELDNAME='DATEOFLEAVING'