Where is the data stored for addon-avono-read-confirmation-plugin

[Greg Bernhardt]

I want to see which pages have had read confirmation requests, and their status, and I don't see a way through the plugin to do that.

I was wondering where the data is stored (assuming it's in the confluence schema), so I can query on it.

[RaphaelD · Accepted solution]

"Content Properties" is the API Name for this kind of storage in Confluence ;-) The table currently used by Confluence for "Content Properties" is os_propertyentry

You can retrieve all read confirmation data with this SQL:

select entity_id as pageId, text_val as recoXml from os_propertyentry where entity_key = 'com.avono.plugins.readconfirmation.ReadConfirmationMacro';

[RaphaelD]

Sorry for the delay...

The plugin data is stored as XML in content properties. In future releases Active Objects will probably be used.

[Greg Bernhardt]

Hmm, the following SQL in my confluence DB returns nothing, so is there a specific table name you're referring to:

select * from CONTENTPROPERTIES;