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"

Leave a Comment

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

*
*