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

Created by Amine Benarbia on Feb 11, 2022
Purpose of Query

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

Applicable CAST Version

 

Release
Yes/No
8.3.x (tick) 
8.2.x (tick) 
8.1.x (tick) 
8.0.x (tick) 
Applicable RDBMS

 

RDBMS
Yes/No
Oracle Server (tick) 
Microsoft SQL Server (tick) 
CSS2 (tick) 


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
 

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 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
 

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
Notes/comments
 

 

 

Related Pages