Purpose of Query
The query retrieve the number of client server links on the Knowledge base
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
7.3.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 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