I am doing some SQL queries in the Confluence database. I have the Pageid and my report wants to use the actual Page name. What database table do I need to look at?
Thanks to Aron Gombas, Midori CEO, Who has some great plugins for Confluence.
He pointed me to the Content table, using Content.contentid = PageID (and qualifying that with Content.contenttype = "Page" so I got the pages and not the attachments). Now I have the page name as Content.Title. And using Content.Spaceid = Spaces.Spaceid I get the space name Spaces.Spacename.
Again thanks Aron for the point in the right direction.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG