Mapplet Transformations
This is a subreport in the Mapplet Composite Report. This report displays transformations used in a mapplet by repository and folder.
Click on the text to copy the query report to your clipboard.
select "WIDGET_DESCRIPTION",
case when ("WIDGET_VERSION_STATUS" = 0) then ('Active') else (case when ("WIDGET_VERSION_STATUS" = 9) then ('Logically Deleted') else (case when ("WIDGET_VERSION_STATUS" = 10) then ('Physically Deleted') else ('') end) end) end as "Calc_WIDGET_VERSION_STATUS",
case when ("PARENT_WIDGET_IS_REUSABLE" = 1) then ('Yes') else ('No') end as "Calc_PARENT_WIDGET_IS_REUSABLE",
"WIDGET_VERSION_NUMBER",
"SUBJECT_AREA",
"REPOSITORY_NAME",
case when ("IS_SHORTCUT" = 1) then ('Yes') else ('No') end as "Calc_IS_SHORTCUT",
"WIDGET_TYPE_NAME",
"WIDGET_NAME",
"MAPPLET_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_ALL_TRANSFORMS.WIDGET_TYPE_NAME AS WIDGET_TYPE_NAME, MAPPLET_ALL_TRANSFORMS.WIDGET_NAME AS WIDGET_NAME, MAPPLET_ALL_TRANSFORMS.WIDGET_DESCRIPTION AS WIDGET_DESCRIPTION, MAPPLET_ALL_TRANSFORMS.WIDGET_VERSION_NUMBER AS WIDGET_VERSION_NUMBER, MAPPLET_ALL_TRANSFORMS.WIDGET_VERSION_STATUS AS WIDGET_VERSION_STATUS, MAPPLET_ALL_TRANSFORMS.PARENT_WIDGET_IS_REUSABLE AS PARENT_WIDGET_IS_REUSABLE, MAPPLET_ALL_TRANSFORMS.IS_SHORTCUT AS IS_SHORTCUT FROM REP_ALL_MAPPLETS ALL_MAPPLETS, REP_REPOSIT_INFO MAPPLET_REPOSIT_INFO, REP_WIDGET_INST MAPPLET_WIDGET_INST, REP_ALL_TRANSFORMS MAPPLET_ALL_TRANSFORMS 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 AND MAPPLET_ALL_TRANSFORMS.PARENT_WIDGET_ID = MAPPLET_WIDGET_INST.WIDGET_ID AND MAPPLET_ALL_TRANSFORMS.SUBJECT_ID = MAPPLET_WIDGET_INST.SUBJECT_ID AND MAPPLET_ALL_TRANSFORMS.WIDGET_TYPE_ID = MAPPLET_WIDGET_INST.WIDGET_TYPE )) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "MAPPLET_NAME" in ('<Mapplet_Name>')
order by "REPOSITORY_NAME", "SUBJECT_AREA"