The query retrieves the number of internal links on the Knowledge base.
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS |
SELECT ot.objtypstr, k.keynam, CASE accknd WHEN 0 THEN 'classic' ELSE 'escalated' 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
"C++ Project";"GUI_13822_Cpp";"classic";732
"C++ Project";"Db_13827_C";"classic";28821
"C++ Project";"A_lib_13829_Cpp";"classic";947
"C++ Project";"NetworkBuild_13826_Cpp";"classic";233
"C++ Project";"NB_TEST_13828_Cpp";"classic";29
"C++ Project";"Common_13824_Cpp";"classic";484
The query return the count of internal links for each project
SELECT ot.objtypstr, k.keynam, CASE accknd WHEN 0 THEN 'classic' ELSE 'escalated' 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
"C++ Project";"GUI_13822_Cpp";"classic";732
"C++ Project";"Db_13827_C";"classic";28821
"C++ Project";"A_lib_13829_Cpp";"classic";947
"C++ Project";"NetworkBuild_13826_Cpp";"classic";233
"C++ Project";"NB_TEST_13828_Cpp";"classic";29
"C++ Project";"Common_13824_Cpp";"classic";484
The query return the count of internal links for each project
SELECT ot.objtypstr, k.keynam, CASE accknd WHEN 0 THEN 'classic' ELSE 'escalated' 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
"C++ Project";"GUI_13822_Cpp";"classic";732
"C++ Project";"Db_13827_C";"classic";28821
"C++ Project";"A_lib_13829_Cpp";"classic";947
"C++ Project";"NetworkBuild_13826_Cpp";"classic";233
"C++ Project";"NB_TEST_13828_Cpp";"classic";29
"C++ Project";"Common_13824_Cpp";"classic";484