Get page URL through SQL query

[Francisco Cohen]

I have a select from content table where I get all current pages.

I would like to get an additional column where I could get each page URL.

What is the table I have to join with the content to get those URLs?

Thank you,

FC.

[DPKJ]

@Francisco Cohen

Go through this knowledge base article, urls are not stored in database but can be generated programmatically.

https://confluence.atlassian.com/confkb/the-differences-between-various-url-formats-for-a-confluence-page-278692715.html

The page id based URL is straightforward,

<CONFLUENCE_BASE_URL>/pages/viewpage.action?pageId=<PAGE_ID>

If you are looking for tiny urls,

https://confluence.atlassian.com/confkb/how-to-programmatically-generate-the-tiny-link-of-a-confluence-page-956713432.html