Find all the screens that modify particular table
select pppf.folder_name as [Folder], ppf.folder_name as [Folder], pf.folder_name as [Folder], f.folder_name as [Folder], scr_lang.SCREENNAME, scr_lang.DESCRIPTION, scr.* from OC_SCREENS scr inner join OC_SCREENLANGUAGES scr_lang on scr.SCREENID = scr_lang.SCREENID left join OC_ADMINCONSOLE_FOLDERS f on scr.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 TABLENAME = 'Absence'
Similar to the above code, do you know of any code that will also show the workflow name, and the subject heading?
Thank You
Debbie Coates
Debbie, I’m not sure what you are trying to achieve. This script shows screens for a table. Workflows don’t have base tables and this is not applicable.
Perhaps you can have a look on this list: http://hrnet.trailmax.info/?tag=find_by_sql
If you don’t find what you are looking for there, you can email me on mail@amvcomp.co.uk and I’ll try to help you out.
Cheers,
Max
Thanks Max,
I managed to find what I was looking for :-), I am new to HR net, so I am just finding my feet with it.