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 | |
8.2.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS |
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
"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