Mapplet Source Field details

Displays column names for all sources by repository, folder, and mapplet. It also displays properties for these columns such as datatype, length, and precision.

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


select "SOURCE_FIELD_PRECISION",
"SOURCE_FIELD_SCALE",
"SOURCE_FIELD_DATATYPE",
"MAPPLET_NAME",
case when ("SOURCE_FIELD_NULLTYPE" = 1) then ('Yes') else ('No') end as "Calc_SOURCE_FIELD_NULLTYPE",
"SOURCE_FIELD_NAME",
"SOURCE_NAME",
"SUBJECT_AREA",
"SOURCE_FIELD_KEY_TYPE",
"SOURCE_FIELD_DESCRIPTION",
"SOURCE_FIELD_BUSINESS_NAME",
"REPOSITORY_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_SOURCES.SOURCE_NAME AS SOURCE_NAME,    MAPPLET_ALL_SOURCE_FLDS.SOURCE_FIELD_NUMBER AS SOURCE_FIELD_NUMBER,    MAPPLET_ALL_SOURCE_FLDS.SOURCE_FIELD_NAME AS SOURCE_FIELD_NAME,    MAPPLET_ALL_SOURCE_FLDS.SOURCE_FIELD_BUSINESS_NAME AS SOURCE_FIELD_BUSINESS_NAME,    MAPPLET_ALL_SOURCE_FLDS.SOURCE_FIELD_DESCRIPTION AS SOURCE_FIELD_DESCRIPTION,    MAPPLET_ALL_SOURCE_FLDS.SOURCE_FIELD_DATATYPE AS SOURCE_FIELD_DATATYPE,    MAPPLET_ALL_SOURCE_FLDS.SOURCE_FIELD_PRECISION AS SOURCE_FIELD_PRECISION,    MAPPLET_ALL_SOURCE_FLDS.SOURCE_FIELD_SCALE AS SOURCE_FIELD_SCALE,    MAPPLET_ALL_SOURCE_FLDS.SOURCE_FIELD_KEY_TYPE AS SOURCE_FIELD_KEY_TYPE,       MAPPLET_ALL_SOURCE_FLDS.SOURCE_FIELD_NULLTYPE AS SOURCE_FIELD_NULLTYPE   FROM    REP_ALL_MAPPLETS ALL_MAPPLETS,    REP_REPOSIT_INFO MAPPLET_REPOSIT_INFO,    REP_WIDGET_INST MAPPLET_WIDGET_INST,    REP_ALL_SOURCES MAPPLET_ALL_SOURCES,    REP_ALL_SOURCE_FLDS MAPPLET_ALL_SOURCE_FLDS    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_SOURCES.PARENT_SOURCE_ID = MAPPLET_ALL_SOURCE_FLDS.    PARENT_SOURCE_ID AND    MAPPLET_ALL_SOURCES.PARENT_SOURCE_VERSION_NUMBER = MAPPLET_ALL_SOURCE_FLDS.    PARENT_SOURCE_VERSION_NUMBER AND    MAPPLET_ALL_SOURCES.PARENT_SOURCE_ID = MAPPLET_WIDGET_INST.WIDGET_ID AND    MAPPLET_ALL_SOURCES.SUBJECT_ID = MAPPLET_WIDGET_INST.SUBJECT_ID AND   MAPPLET_WIDGET_INST.WIDGET_TYPE = 1)) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "MAPPLET_NAME" in ('<Mapplet_Name>')
order by "REPOSITORY_NAME", "SUBJECT_AREA", "MAPPLET_NAME"