Purpose of Query
The query retrieves the number of external links of each 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, CASE accknd WHEN 0 THEN 'normal' ELSE 'classic' END, Count(1) FROM objtypstr ot, keys k, objpro op, acc a WHERE a.idpro = k.idkey AND k.objtyp = ot.objtyp AND a.idcle = op.idobj AND op.idpro != a.idpro GROUP BY ot.objtypstr, k.keynam, accknd
Query result example
"Linker Project Type";"LINKER_11934Db_13827_C";"normal";113
"C++ Project";"NB_TEST_13828_Cpp";"normal";28
"Linker Project Type";"LINKER_5506NetworkBuild_13826_Cpp";"normal";7
"Linker Project Type";"LINKER_87695NB_TEST_13828_Cpp";"normal";12
"Linker Project Type";"LINKER_3410Common_13824_Cpp";"normal";39
"C++ Project";"NetworkBuild_13826_Cpp";"normal";194
"Linker Project Type";"LINKER_777GUI_13822_Cpp";"normal";3
"Linker Project Type";"LINKER_88262CapTA_lib_13829_Cpp";"normal";70
Query result interpretation
The query return the count of external links for each project
Query for Oracle
Query result example
Query result interpretation
Query for SQL server
Query result example
Query result interpretation
Notes/comments
Related Pages