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