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

Purpose of Query

The query retrieve the number of client server links on the Knowledge base

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 returned the count of client server 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