SQL Queries - CAST Knowledge Base - Queries on objects - How to get the count of objects per project

Purpose of Query

The query listed in this page when executed will provide you with the number of objects per project.

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS(tick)
Query for CSS
SELECT   ot.ObjTypStr,
         k.KeyNam    ,
         COUNT(1)
FROM     ObjTypStr ot,
         Keys k      ,
         ObjPro op
WHERE    op.IdPro  = k.IdKey
AND      ot.ObjTyp = k.ObjTyp
GROUP BY ot.ObjTypStr,
         k.KeyNam
Query result example
"Java Project";"_android_d44a4795_";3507
"Universal Project";"Shell_34067";114
"Oracle Project";"ANALYTICS_2649";369
"JSP Application";"userManagement_54451dea";3025
Query result interpretation
 There are 4 projects.

The Java project contains 3507 objects,

The Shell project contains 114 objects,

The Oracle Project contains 369 objects.

The JSP Application Project contains 3025 objects

Query for Oracle

Query result example

Query result interpretation


Query for SQL server

Query result example

Query result interpretation

Notes/comments



Related Pages