Get PAGEID and URLS for particular SPACE

[Mark Jennings]

Hi,

Is there a way in Scriptrunner in Confluence I can get the the Title, URL and PAGEID of all pages in a particular space?

Thanks

[Lee Wonnacott]

Hi Mark! 

You can get these values with the following script: 

import com.atlassian.confluence.pages.PageManager
import com.atlassian.confluence.spaces.SpaceManager
import com.atlassian.sal.api.component.ComponentLocator
import com.atlassian.confluence.setup.settings.SettingsManager


PageManager pageManager = ComponentLocator.getComponent(PageManager)
SpaceManager spaceManager = ComponentLocator.getComponent(SpaceManager)
SettingsManager settingsManager = ComponentLocator.getComponent(SettingsManager)

def space = spaceManager.getSpace("<your_space>")
def homePage = space.getHomePage()

def listOfPages = homePage.getDescendants() 
listOfPages.add(homePage)
String baseUrl = settingsManager.getGlobalSettings().getBaseUrl();

listOfPages.each {
log.warn "Page title: " + it.getTitle()
log.warn "Page Url: " + baseUrl + it.getUrlPath()
log.warn "PageID: " + it.getContentId()
}

Thanks,
Lee 

[Mark Jennings]

Thanks, managed to get what i needed from a SQL script and lots of Excel Manipulation

[Sunny Kanade]

Hi Mark, Worked for me as well. It is just an improvement to use string null and empty check before using it to avoid null exceptions.