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
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.0.x(tick)
7.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server (question)
Microsoft SQL Server (question)
CSS(tick)
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