We need to be able to query page properties report information from the database and export it into an CSV or excel file. How can we do this? We would be using a postgres database.
Hey there Natalie, you can generally get a lot of metadata about pages simply by querying the content table for the page in question (using the page ID or page title), and even by joining the content table to other tables like the content_label table for example, to see what labels are applied to the page.
And Postgres allows you to export the output of a query to CSV, using something like the process described in this blog post.
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs