SQL Queries - CAST Knowledge Base - Queries on objects - How to get the list of objects analyzed from a file path

Purpose of Query

The query returns the list of objects analyzed from a file path

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 *
FROM   keys k
       JOIN objfilref obj
         ON k.idkey = obj.idobj
       JOIN refpath refp
         ON refp.idfilref = obj.idfilref
WHERE  refp.path = <file_path>

Query result example

3459;``"StationList_Create"``;``""``;``"XXXXXX"``;-1;10360;393224;514;``"???"``;``"1970-01-01 00:00:00"``;``""``;0;``""``;3459;20;3570;20;``"C:\CASTMS\Deploy\application\cpp\src\application\Line.cpp"
3524;``"Add_Line"``;``""``;``"XXXXXX"``;-1;10360;393224;514;``"???"``;``"1970-01-01 00:00:00"``;``""``;0;``""``;3524;20;3570;20;``"C:\CASTMS\Deploy\application\cpp\src\Common\Line.cpp"
3570;``"Line.cpp"``;``""``;``"XXXXXX"``;-1;10310;0;512;``"???"``;``"1970-01-01 00:00:00"``;``""``;0;``""``;3570;20;3570;20;``"C:\CASTMS\Deploy\application\cpp\src\Common\Line.cpp"

Query result interpretation

The query returns the list of analyzed objects

Query for Oracle

SELECT *
FROM   keys k
       JOIN objfilref obj
         ON k.idkey = obj.idobj
       JOIN refpath refp
         ON refp.idfilref = obj.idfilref
WHERE  refp.path = <file_path>

Query result example

Query result interpretation

The query returns the list of analyzed objects

Query for SQL Server

SELECT *
FROM   keys k
       JOIN objfilref obj
         ON k.idkey = obj.idobj
       JOIN refpath refp
         ON refp.idfilref = obj.idfilref
WHERE  refp.path = <file_path>

Query result example

Query result interpretation

The query returns the list of analyzed objects

Notes/comments

Related Pages