SQL Queries - CAST Central Base - Queries on source code - How to get the Rest API URL that retrieve the source code of an object

Purpose of Query

 The query returns the RestAPI URL that retrieve the source code of an object. The query needs <local_schema>: the name of the local schema,<central_schema>: the name of the central schema and <Object full name>: the full name of the object,<Domain name>: the domain name used in the deployment folder

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 '<Domain name>'
       || '/'
       || 'local-sites'
       || '/'
       || ssi.site_id
       || '/'
       || 'file-contents'
       || '/'
       || dsp.local_source_id
FROM   <local_schema>.sys_site ssi,
       <central_schema>.dss_translation_table dtt
       JOIN <central_schema>.dss_objects dob
         ON dtt.object_id = dob.object_id
       JOIN <central_schema>.dss_source_positions DSP
         ON dob.object_id = dsp.object_id
WHERE  object_full_name = '<Object full name>'
Query result example
 AED/local-sites/1019855162/file-contents/23
Query result interpretation
 The REST API URL
Query for Oracle
SELECT 'AED'
       || '/'
       || 'local_sites'
       || '/'
       || ssi.site_id
       || '/'
       || 'file_contents'
       || '/'
       || dsp.local_source_id
FROM   <local_schema>.sys_site ssi,
       <central_schema>.dss_translation_table dtt
       JOIN <central_schema>.dss_objects dob
         ON dtt.object_id = dob.object_id
       JOIN <central_schema>.dss_source_positions DSP
         ON dob.object_id = dsp.object_id
WHERE  object_full_name = '<Object full name>'
Query result example
 AED/local_sites/1019855162/file_contents/23
Query result interpretation
  The REST API URL


Query for SQL server
SELECT 'AED'
       || '/'
       || 'local_sites'
       || '/'
       || ssi.site_id
       || '/'
       || 'file_contents'
       || '/'
       || dsp.local_source_id
FROM   <local_schema>.sys_site ssi,
       <central_schema>.dss_translation_table dtt
       JOIN <central_schema>.dss_objects dob
         ON dtt.object_id = dob.object_id
       JOIN <central_schema>.dss_source_positions DSP
         ON dob.object_id = dsp.object_id
WHERE  object_full_name = '<Object full name>'
Query result example
  AED/local_sites/1019855162/file_contents/23
Query result interpretation
  The REST API URL
Notes/comments
 

  

Related Pages