SQL Queries - CAST Knowledge Base - Queries on artifacts - How to get the list of objects based on module name

Purpose of Query

This query will help to retrieve the contents of the modules based on the module name.

Applicable CAST Version

Release	Yes/No
8.3.x

Applicable RDBMS

RDBMS	Yes/No
CSS

Query for CSS

Query gets the list of objects by module name.

Run the below query in KB:

SELECT ps.module_name, 
       ps.module_id, 
       pso.object_id 
FROM   <your_local>.pmc_subset_objects pso 
       JOIN (SELECT ps.subset_id   AS MODULE_ID, 
                    pm.object_name AS MODULE_NAME 
             FROM   (SELECT pm.object_id, 
                            pm.object_name 
                     FROM   <your_mngt>cms_portf_module pm 
                     WHERE  1 = 1 
                     and pm.Object_Name in ([list of module names]) -- comment out to scan all defined modules 
                    ) pm 
                    JOIN <your_local>.pmc_subsets ps 
                      ON ps.subset_name LIKE 'CMS_MOD__' 
                                             || pm.object_id 
                                             || '_Preparation2') ps 
         ON pso.subset_id = ps.module_id

Query result example

List of objects in a module

Notes/comments

Related Pages