nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Querying when restrictions were added or removed

Kathryn Reddie

Hi all,

Is there a way I can find when restrictions were added or removed using the database? I've looked at CONTENT_PERM but I can't work out how to query a page id.

My skills in SQL are limited to basic queries I'm afraid.

Thanks,
Kathryn.

Accepted answers

Dave LIAO_mt3mrn

@Kathryn Reddie - unfortunately Confluence doesn't track when page restrictions were removed, just when they're initially applied (as you can see in Page Information for a given page).

This has been a pain point, and I believe there are multiple suggestion tickets for this, including https://jira.atlassian.com/browse/CONFSERVER-19721

All comments

Dave LIAO_mt3mrn

@Kathryn Reddie - unfortunately Confluence doesn't track when page restrictions were removed, just when they're initially applied (as you can see in Page Information for a given page).

This has been a pain point, and I believe there are multiple suggestion tickets for this, including https://jira.atlassian.com/browse/CONFSERVER-19721

Kathryn Reddie

Thanks @Dave LIAO ,

Could I query when the restrictions were applied by page id via SQL?

Thanks,
Kat.

Dave LIAO_mt3mrn

Hi Kat! I presume you can, but I'm unsure what the exact SQL query would be.

This is partially relevant - these are queries to return pagesthat have restrictions:

https://confluence.atlassian.com/confkb/how-to-list-pages-with-restrictions-951412334.html

For reference, here's info on Confluence's data model, that might help you craft a SQL query: https://confluence.atlassian.com/doc/confluence-data-model-127369837.html

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server