Find screen by base table

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'
This entry was posted in Uncategorized and tagged , . Bookmark the permalink.

3 Responses to Find screen by base table

  1. Debbie Coates says:

    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

  2. Debbie Coates says:

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *