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