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

Created by Amine Benarbia on Feb 11, 2022
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
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server (question)
Microsoft SQL Server (question)
CSS(tick)
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