We're trying to determine which pages will be affected by a plugin update.
Is there a search we can run in confluence or a query we can run against the database to find which pages use a macro (in this case, table-plus macro)?
Hi Ron, I believe this question was asked previously on Answers, check out this link:
...specifically Sando's comment:
or Sarah's link:
Hope this helps!
That's possible by running a database query indeed.
in mysql, you can use this query (If you are using another database, you may need to ask the DBA to tweak a bit the query):
SELECT c.title, s.spacename
FROM content c
INNER JOIN bodycontent b ON b.contentid = c.CONTENTID
INNER JOIN spaces s ON c.spaceid = s.spaceid
WHERE b.body like '%macro_syntax%';
This will show you the space name and page title of the affected page by the macro. Hope that helps :D
Hello Community, Jessica here from the Confluence product marketing team! Today I wanted to get your takes on project planning –– what works, what doesn’t, how do you know if you’re doing it r...
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