SQL Queries - CAST Central Base - Queries on modules - How to get the ID and the name of Portfolio tree module

Purpose of Query

This page provide the Portfolio tree module’s ID and name

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT doi.object_id, 
       doi.object_name, 
       doi.object_type_id 
FROM   dss_objects doi, 
       dss_object_types dot 
WHERE  doi.object_type_id = dot.object_type_id 
AND    dot.object_group = 1

Query result example

53;“application_new IFPUG module”;20051
54;“application_new full content_CPP_SUBSET”;107502

Query result interpretation

This example returns 2 Portfolio tree module’s with the id’s 53 and 54 and name’s “application_new IFPUG module” and “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