Loading Profile...
EMPLOYEE
Where is Scaffolding data stored?
Is it possible to access Scaffolding data directly in the database?
I’m unconcerned
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
-
Inappropriate?Scaffolding data is stored in table OS_PROPERTYENTRY with entity_id as foreign key to CONTENT.contentid. The history/versioning of Confluence leads to many entries with the same OS_PROPERTYENTRY.entity_id. The latest/current version is the entry with OS_PROPERTYENTRY.entity_key = "~metadata." + n, where n = CONTENT.version.
Here is an SQL example to get latest version of a page's Scaffolding data:
select c.contentid, c.title, c.version, o.text_val
from CONTENT c, OS_PROPERTYENTRY o
where c.title='My Page' and c.prevver is NULL and c.contentid=o.entity_id and o.entity_key=concat('~metadata.',c.version)
Contributed by Bernd Lindner.
The company says
this answers the question
