Repository Type Exploration

The Repository Type Exploration analytic workflow displays all repository types in the metamodel and enables you to explore its contents, such as its packages and repository instances.


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


select "ORIGINATOR_NAME",
"REPO_TYPE_NAME",
"REPO_TYPE_DESC",
"PRODUCT_TYPE"
from (SELECT  DISTINCT MMR_IMA_REPO_TYPE.PRODUCT_TYPE,  MMR_IMA_ORIGINATOR.ORIGINATOR_NAME,  MMR_IMA_REPO_TYPE.REPO_TYPE_ID,  MMR_IMA_ORIGINATOR.ORIGINATOR_ID,  MMR_IMA_REPO_TYPE.REPO_TYPE_NAME,  MMR_IMA_REPO_TYPE.REPO_TYPE_DESC  FROM  IMA_REPO_TYPE MMR_IMA_REPO_TYPE,  IMA_REPO_PACKAGE MMR_IMA_REPO_PACKAGE,  IMA_PACKAGE MMR_IMA_PACKAGE,  IMA_ORIGINATOR MMR_IMA_ORIGINATOR  WHERE  (MMR_IMA_REPO_PACKAGE.REPO_TYPE_UID = MMR_IMA_REPO_TYPE.REPO_TYPE_UID AND  MMR_IMA_REPO_PACKAGE.PACKAGE_UID = MMR_IMA_PACKAGE.PACKAGE_UID AND  MMR_IMA_PACKAGE.ORIGINATOR_UID = MMR_IMA_ORIGINATOR.ORIGINATOR_UID)) "query"
order by "PRODUCT_TYPE", "ORIGINATOR_NAME", "REPO_TYPE_NAME"

Leave a Comment

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

*
*