Summary of revision information / Delta Information

Question

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 ?

Pamela Sheridan · Answer

Hey thanks for the rapid response, really appreciated, Ill give that a try

Rgds

Pam

Guilherme Nedel · Answer

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.