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

Purpose of Query

This page provides the query to list all the functional modules and their IDs in the Central database.

Applicable CAST Version

ReleaseYes/No
8.2.x✅
8.1.x✅
8.0.x✅
7.3.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server❓
Microsoft SQL Server❓
CSS2✅

Query for CSS

SELECT   object_id as module_id ,
         object_name as module_name
FROM     dss_objects 
WHERE    object_type_id = 20000

Query result example

54;“application_new full content_CPP”

Query result interpretation

In this example 54 is the id of functional module - application_new full content_CPP

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