It's not the same without you
Join the community to find out what other Atlassian users are discussing, debating and creating.
We are using confluence to build up a suite of documentation, is there a neat way to extract a summary of delta information (changes from one version of a page to the next) from all pages within a specified tree ?
Hello Pamela, you can see which pages where updated using the following query.
SELECT spaces.spacename, MAX(content.lastmoddate) FROM content, spaces WHERE content.spaceid = spaces.spaceid GROUP BY spaces.spacename;
Further to it you can compare page versions, looking into the version
column within the content
table from Confluence database, and making a diff between the corresponding content from the other table bodycontent
. For documentation reference you can refer to this.
Hope this can put you on the right track to achieve the desired result.
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.
Read moreHi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...
Connect with like-minded Atlassian users at free events near you!
Find a groupConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.
Start an AUGYou're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.