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

Applicable RDBMS

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