How to Access the Physical Content of an Artifact
In order to access the content of an artifact such as a wiki page, a dashboard or an image, follow these steps:
1. As a user belonging to the System Administrator user group, go to > .
 |
If the iSql link does not appear, you must enable it using the CB_PAGE_VISIBILITY_ISQL variable. For details, see iSQL.
|
2. Run one of the following database queries:
◦ If the HEAD revision is needed:
select ref.to_id as file_id from object_reference ref
inner join object association on ref.assoc_id=association.id and association.deleted=0
where ref.from_id=<artifact_id>
◦ If a specific revision is needed:
select ref.to_id as file_id from object_reference ref
inner join object artifact on ref.from_id=artifact.id inner join object_revision artifact_rev on artifact.id = artifact_rev.object_id
inner join object association on ref.assoc_id=association.id inner join object_revision association_rev on association.id = association_rev.object_id and artifact_rev.created_at=association_rev.created_at and association_rev.revision=1
where ref.from_id=<artifact_id>
and artifact_rev.revision=<artifact_revision>
|
|
Make sure to replace <artifact_id> and <artifact_revision> with real parameters in the queries.
|
3. Take note of the resulting file_id and compose the relative path to the file from the docs repository folder by dividing the result by 1000. The integer part is the main folder, and the fraction part is the sub folder.
From the docs repository, open the main folder and the sub folder. The artifact content can be found there in a file named 1.
Example: If the resulting file_id is 45678, the path to the artifact content is: /45/678/1.