Purpose of Query
The query gives the name of the project and the type of the project for a given link
Applicable CAST Version
Release | Yes/No |
---|---|
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
SELECT ac.idacc as "ID OF THE LINK", k1.keynam as "NAME OF THE CALLER", k2.keynam as "NAME OF THE CALLEE", kt.keynam as "NAME OF THE PROJECT", t.typdsc as "NAME OF THE TYPE OF PROJECT" FROM acc ac JOIN keys k1 ON k1.idkey = ac.idclr JOIN keys k2 ON k2.idkey = ac.idcle JOIN Keys kt ON kt.idkey = ac.idpro JOIN typ t ON t.idtyp = kt.objtyp WHERE k1.keynam like '%<NAME OF THE CALLER OBJECT>%' AND k2.keynam like '%<NAME OF THE CALLEE OBJECT>%'
Notes/comments
Related Pages