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
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Atlassian market place contains number of Apps/Addons which improves the capability of out of the box Atlassian products. It is good to follow a plugin evaluation process before install add-ons. So t...
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