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 the full name of the object,
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 '<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