Unused Mapplets in Mappings

Displays mapplets defined in a folder but not used in any mapping in that folder.


Click on the text to copy the query report to your clipboard.


select "REPOSITORY_NAME",
case when ("MAPPLET_VERSION_STATUS" = 0) then ('Active') else (case when ("MAPPLET_VERSION_STATUS" = 9) then ('Logically Deleted') else (case when ("MAPPLET_VERSION_STATUS" = 10) then ('Physically Deleted') else ('') end) end) end as "Calc_MAPPLET_VERSION_STATUS",
"MAPPLET_DESCRIPTION",
"MAPPLET_NAME",
"MAPPLET_VERSION_NUMBER",
"MAPPLET_LAST_SAVED",
case when ("VALIDFLAG" = 1) then ('Yes') else ('No') end as "Calc_ValidFlag",
case when ("SHORTCUTFLAG" = 1) then ('Yes') else ('No') end as "Calc_IS_SHORTCUT",
"SUBJECT_AREA"
from (SELECT  DISTINCT MAPPLET_REPOSIT_INFO.REPOSITORY_NAME,  ALL_MAPPLETS.SUBJECT_AREA,  ALL_MAPPLETS.MAPPLET_NAME,  ALL_MAPPLETS.MAPPLET_DESCRIPTION        AS MAPPLET_DESCRIPTION,  ALL_MAPPLETS.MAPPLET_VERSION_NUMBER,  ALL_MAPPLETS.MAPPLET_VERSION_STATUS,  ALL_MAPPLETS.MAPPLET_LAST_SAVED,  ALL_MAPPLETS.PARENT_MAPPLET_NAME,  ALL_MAPPLETS.PARENT_MAPPLET_DESCRIPTION AS PARENT_MAPPLET_DESCRIPTION,  ALL_MAPPLETS.PARENT_MAPPLET_VERSION_NUMBER,  ALL_MAPPLETS.PARENT_MAPPLET_VERSION_STATUS,  ALL_MAPPLETS.PARENT_MAPPLET_LAST_SAVED,  ALL_MAPPLETS.PARENT_SUBJECT_AREA,  ALL_MAPPLETS.PARENT_MAPPLET_IS_VALID  as VALIDFLAG,  ALL_MAPPLETS.IS_SHORTCUT as SHORTCUTFLAG,  (COUNT(DISTINCT( MAPPLET_MAPPING_WIDGET_INST.MAPPING_ID)))  AS MAPPING_COUNT,  (COUNT(   CASE    WHEN MAPPLET_WIDGET_INST.WIDGET_TYPE = 1    THEN MAPPLET_WIDGET_INST.INSTANCE_ID   END))                                        AS SOURCE_COUNT,  (COUNT(   CASE    WHEN MAPPLET_WIDGET_INST.WIDGET_TYPE NOT IN (1,   2,   44)    THEN MAPPLET_WIDGET_INST.INSTANCE_ID   END))                                        AS TRANSFORMATION_COUNT  FROM  REP_REPOSIT_INFO MAPPLET_REPOSIT_INFO,  REP_WIDGET_INST MAPPLET_WIDGET_INST,  REP_ALL_MAPPLETS ALL_MAPPLETS    LEFT OUTER JOIN REP_WIDGET_INST MAPPLET_MAPPING_WIDGET_INST    ON ALL_MAPPLETS.REF_WIDGET_ID = MAPPLET_MAPPING_WIDGET_INST.WIDGET_ID    AND   ALL_MAPPLETS.SUBJECT_ID = MAPPLET_MAPPING_WIDGET_INST.SUBJECT_ID AND   MAPPLET_MAPPING_WIDGET_INST.WIDGET_TYPE = 44  WHERE  (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  ALL_MAPPLETS.PARENT_MAPPLET_ID <> MAPPLET_REPOSIT_INFO.REPOSITORY_ID)  GROUP BY  MAPPLET_REPOSIT_INFO.REPOSITORY_NAME,  ALL_MAPPLETS.SUBJECT_AREA,  ALL_MAPPLETS.MAPPLET_NAME,  ALL_MAPPLETS.MAPPLET_DESCRIPTION,  ALL_MAPPLETS.MAPPLET_VERSION_NUMBER,  ALL_MAPPLETS.MAPPLET_VERSION_STATUS ,  ALL_MAPPLETS.MAPPLET_LAST_SAVED,  ALL_MAPPLETS.PARENT_MAPPLET_NAME,  ALL_MAPPLETS.PARENT_MAPPLET_DESCRIPTION ,  ALL_MAPPLETS.PARENT_MAPPLET_VERSION_NUMBER,  ALL_MAPPLETS.PARENT_MAPPLET_VERSION_STATUS,  ALL_MAPPLETS.PARENT_MAPPLET_LAST_SAVED,  ALL_MAPPLETS.IS_SHORTCUT ,  ALL_MAPPLETS.PARENT_SUBJECT_AREA,  ALL_MAPPLETS.PARENT_MAPPLET_IS_VALID) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "MAPPING_COUNT" = 0
order by "REPOSITORY_NAME", "SUBJECT_AREA"

Leave a Comment

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

*
*