SQL Queries - CAST Knowledge Base - Queries on Links - How to get the list of DLM links by object name

Purpose of Query

This page provides a query to list the number of DLM (dynamic link manager) links by object name for non reviewed links.

NOTE : If you have a large amount of DLM links, this query can then produce a large amount of results

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT   cdt1.object_fullname AS caller_name,
         cdt1.object_type_str AS caller_type,
         cdt2.object_fullname AS callee_name,
         cdt2.object_name                   ,
         cdt2.object_type_str AS callee_type
FROM     cdt_objects cdt1,
         cdt_objects cdt2,
         acc a
WHERE    a.prop  = 1
AND      a.idclr = cdt1.object_id
AND      a.idcle = cdt2.object_id
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 a.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

“