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.
"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';
Sorry for the delay...
The plugin data is stored as XML in content properties. In future releases Active Objects will probably be used.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hmm, the following SQL in my confluence DB returns nothing, so is there a specific table name you're referring to:
select * from CONTENTPROPERTIES;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.