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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.