Purpose of Query
This page help you to get the list of dynamic links not yet reviewed.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Query for CSS
To get the list of the links that are not reviewed run the following query
SELECT ac.idacc AS "ID OF THE DYNAMIC LINK", k1.idkey AS "ID OF THE CALLER", k1.keynam AS "NAME OF THE CALLER", k2.idkey AS "ID OF THE CALLEE", k2.keynam AS "NAME OF THE CALLEE", k3.idkey AS "ID OF THE PROJECT", k3.keynam AS "NAME OF THE PROJECT" FROM acc ac JOIN keys k1 ON k1.idkey = ac.idclr JOIN keys k2 ON k2.idkey = ac.idcle JOIN keys k3 ON k3.idkey = ac.idpro WHERE prop = 1 and AccKnd = 0;
To get the list of projects for which the links are still not reviewed :
SELECT k3.idkey AS "ID OF THE PROJECT", k3.keynam AS "NAME OF THE PROJECT", count(1) AS "NUMBER OF UNREVIEWED LINKS" FROM acc ac JOIN keys k3 ON k3.idkey = ac.idpro WHERE prop = 1 GROUP BY k3.idkey, k3.keynam
Notes/comments
Related Pages