All Objects used in mapplet
Displays all transformations used in a mapplet by repository and folder.
Click on the text to copy the query report to your clipboard.
from (SELECT DISTINCT MAPPLET_REPOSIT_INFO.REPOSITORY_NAME as REPOSITORY_NAME, ALL_MAPPLETS.SUBJECT_AREA as SUBJECT_AREA, ALL_MAPPLETS.MAPPLET_NAME as MAPPLET_NAME, MAPPLET_WIDGET_INST.WIDGET_TYPE_NAME as WIDGET_TYPE_NAME, MAPPLET_WIDGET_INST.INSTANCE_NAME as INSTANCE_NAME, MAPPLET_WIDGET_INST.DESCRIPTION as DESCRIPTION FROM REP_ALL_MAPPLETS ALL_MAPPLETS, REP_REPOSIT_INFO MAPPLET_REPOSIT_INFO, REP_WIDGET_INST MAPPLET_WIDGET_INST WHERE (ALL_MAPPLETS.PARENT_MAPPLET_ID <> MAPPLET_REPOSIT_INFO.REPOSITORY_ID AND ALL_MAPPLETS.PARENT_MAPPLET_ID = MAPPLET_WIDGET_INST.MAPPING_ID AND ALL_MAPPLETS.PARENT_MAPPLET_VERSION_NUMBER = MAPPLET_WIDGET_INST. VERSION_NUMBER AND ALL_MAPPLETS.PARENT_SUBJECT_ID = MAPPLET_WIDGET_INST.SUBJECT_ID)) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "MAPPLET_NAME" in ('<Mapplet_Name>')
order by "REPOSITORY_NAME", "SUBJECT_AREA"