Hi, I am looking for an overview of all pages within one space which contains the title, the version and the last updated date.
Hi @Daniel Seegräber
Confluence's Databases is your answer
You can get all the pages in your space into a database quite easily (see this debate for details ), then it's just about configuring fields.
Hello @Daniel Seegräber
For the overview of all pages, you can use the Child Pages macro in confluence which will display only the title of the pages. For displaying the contributions, you would use the Contributors macro, where you would check Show Last Contribution time.
As a result, you would get something like this:
So these macros would need to go separately.
Thanks, but then I'd still need the page version...
Awesome! Thank you.
Confluence's Databases indeed was the answer. Issue solved!
As an alternative solution to Confluence's Databases proposed by @Kristian Klima you can take a look at our app User Macro for Confluence Cloud
Pros
Cons
Your solution might look like the following.
1. Adding a macro to a page
2. See the result on a View page
Here is how the template will look like for your use case.
1. Get Pages in the current space2. Create a table3. Iterate through pages and add rows with data in the required format
## get pages in the current space#set($spaceId = $space.id )#set($sort = "-modified-date") ## order by modified date DESC#set($status = "current") ## skip archived, deleted, and drafted#set($limit = 250) ## increase pages limit to maximum#set($url = "/wiki/api/v2/spaces/${spaceId}/pages?sort=${sort}&status=${status}&limit=${limit}")#set($response = $ConfluenceManager.get($url))## Use of Atlassian UI (AUI) sortable table<table class="aui aui-table-sortable"> <thead> <tr> <th>Title</th> <th>Version</th> <th>Last updated</th> </tr> </thead> <tbody> ## iterate through results of pages #foreach($page in $response.results) <tr> <td>${page.title}</td> ## "aui-badge" will put number in a grey circle <td><span class="aui-badge">${page.version.number}</span></td> ## Convert datetime to date ## "2024-02-13T12:12:31.528Z" -> "2024-02-13" #set($createdAt = $StringUtils.substringBefore($page.version.createdAt, "T")) <td>${createdAt}</td> </tr> #end</tbody></table>
Regards,Roman from Wombats Corp
It looks like you're new here. Sign in or register to get started.