SQL Queries - CAST Central Base - Queries on modules - How to get the ID of the technical module associated to the functional module of the portfolio tree

Purpose of Query

This page provide the ID(s) of technical module(s) associated to functional module(s) of the portfolio tree run following query. The functional module can be a user defined module or a module generated by analysis job

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT   object_id, 
         object_type_id, 
         object_name, 
         object_description, 
         object_full_name 
FROM     dss_objects 
WHERE    object_name LIKE '%SUBSET%' 
ORDER BY 3

Query result example

54;107502;“application_new full content_CPP_SUBSET”;"";“application_new full content_CPP_SUBSET”

Query result interpretation

In this example the 54 is the id of technical module associated to the functional module “application_new full content_CPP_SUBSET”

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Related Pages