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.


select "MAPPLET_NAME",
"SUBJECT_AREA",
"REPOSITORY_NAME",
"INSTANCE_NAME",
"DESCRIPTION",
"WIDGET_TYPE_NAME"
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"