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
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Hi Community! me again 🙂 If you’re a marketing team using Confluence, we want to hear your story! How did you start using Confluence? What are your use cases? What have been some of the benefits?...
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