How to Access the Physical Content of an Artifact
In order to access the content of an artifact (wiki page, dashboard, image, etc.) after the 10.0 upgrade, perform the following steps:
1. As a user belonging to the System Administrator user group, go to > > .
2. Run one of the following 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
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
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 set the artifact_id and artifact_revision parameters.
|
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, then the path to the artifact content is: /45/678/1