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';
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG