Purpose of Query
This page provide the Portfolio tree module's ID and name
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.0.x | |
7.3.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS |
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