SQL Queries - CAST Knowledge Base - Queries on Links - List the dynamic links that have not been reviewed

Purpose of Query

This page help you to get the list of dynamic links not yet reviewed.

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅
8.0.x✅
7.3.x✅

Applicable RDBMS

RDBMSYes/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