Purpose of Query

The purpose of this page is to provide a query which can provide the source code for a given object fullname

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(question)
Microsoft SQL Server(question)
CSS3(tick)
CSS2(tick)
Query for CSS

Run the query below on the central database replacing XXX by part of the object fullname (case sensitive field):

SELECT dsp.panel       ,
       dst.source_path ,
       dst.source_text ,
       dsp.start_line  ,
       dsp.end_line    ,
       dsp.start_column,
       dsp.end_column  ,
       dso.object_full_name
FROM   dss_source_positions dsp
       JOIN dss_objects dso
       ON     dso.object_id = dsp.object_id
       JOIN dss_source_texts dst
       ON     dst.local_source_id=dsp.local_source_id
WHERE  dso.object_full_name   LIKE '%XXX%'
Query result example
 2375,'C:\CASTMS\test830_css3\Deploy\webgoat\webgoat\JavaSource\org\owasp\webgoat\lessons\GoatHillsFinancial\Logout.java','<source>',11,76,1,2,'org.owasp.webgoat.lessons.GoatHillsFinancial.Logout'
Query result interpretation
 The query provides the panel id, source path, source, start and end lines, start and end columns, and object fullname
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