Skip to main content

Hello ,

 

Can someone help to find the View name that holds the  Presentation Objects name by Navigator..

need the list in excel to define  user permission..

 

for example

need listing which shows as in attached screenshot  like

Application Base Setup - Enterprise - Company - Change Global Company

Application Base Setup - Enterprise - Company - Company

Application Base Setup - Enterprise - Company - Companies

etc….

 

 

View name is “PRES_OBJECT ”. and query executing when you expanding the navigator is like as follows;

SELECT a1.OBJID, a1.OBJVERSION, a1.PO_ID, a1.DESCRIPTION, a1.MODULE, a1.PRES_OBJECT_TYPE_DB, a1.INFO_TYPE, a1.CHANGE_INFO, a1.CHANGE_DATE, a1.ALLOW_READ_ONLY_DB, a1.LAYER_ID
 FROM IFSAPP.PRES_OBJECT a1
 WHERE a1.PO_ID IN ('dlgChangeCompanyFin', 'frmCompany' , 'tbwCompanyOverview' , 'dlgCreateCompany' , 'frmUserFin' , 'frmCompanyGroup' )  


Thank you  @suneth  it does shows all presentation objects..  But the table does not have columns that shows the structure.. What i see on that table is link between presentation object name and module..

but somehow the screen which i show exactly list how the navigator folder is built, i want a listing similar to below.. as it displayed on the navigator..

Application Base Setup - Enterprise - Company - Change Global Company

Application Base Setup - Enterprise - Company - Company

Application Base Setup - Enterprise - Company - Companies

 


Reply