SQL Queries - CAST Knowledge Base - Queries on Links - How to count the external links for each project

Purpose of Query

The query retrieves the number of external links of each project

Applicable CAST Version

Applicable RDBMS

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