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'