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
Hi Community! 2018 was filled with changes for our team, both big and small, and we've taken a lot of time to both celebrate our wins and recognize areas of improvement. One thing that we're a...
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