SQL Queries - CAST Knowledge Base - Queries on Links - How to get the list of projects and unreviewed DLM links

Purpose of Query

This page provides a query to list the projects and associated unreviewed DLM (dynamic link manager) links.

Applicable CAST Version

Release	Yes/No
8.3.x
8.2.x
8.1.x
8.0.x

Applicable RDBMS

RDBMS	Yes/No
Oracle Server
Microsoft SQL Server
CSS2

Query for CSS

SELECT     n.fullname "DLM Project Name",
           COUNT(*) "Unreviewd Links"
FROM       cdt_objects a
           INNER JOIN acc c
           ON         c.idclr = a.object_id
           INNER JOIN cdt_objects b
           ON         c.idcle = b.object_id
           INNER JOIN objfulnam n
           ON         c.idpro = n.idobj
WHERE      c.Prop             = 1
  AND      c.AccKnd 		  = 0
GROUP BY   1
ORDER BY   2 DESC;

This query is for non-reviewed links. This can be modified for other types of links by changing the where clause of c.prop to the appropriate value. Please see the following page for more information: SQL Queries - CAST Knowledge Base - Queries on Links - How to determine DLM status

Query result example

"ch_app";221

Query result interpretation

The first column is the DLM project name; The second column is the number of unreviewed links.

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Related Pages