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
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