I was wondering if i can could get help with the information on the plugin - https://marketplace.atlassian.com/plugins/org.andya.confluence.plugins.metadata/server/overview
I need to find all pages where any macros of this plugin are present. As I see there is quite a number of those and there is a big change of missing them. I found that some info might be stored in os_propertyentry table. Like "metadata.XXX". But I’m not sure If I can select all macros using this syntax. As using the instruction I saw only description for finding metadata-list macro (see here - https://community.atlassian.com/t5/Answers-Developer-Questions/confluence-4-x-understanding-where-quot-metadata-quot-is-stored/qaq-p/496305).
Can anyone tell me the way (SQL in ideal way) I would be more than happy. Or I’d like to see some documentation on the plugin database structure if possible. Thank you.
You can just run "macroName: <macro>" in the search to get a list of pages it's used on.
With SQL, you're into searching the bodycontent table text for snippets of text referring to the macro, then joining with other tables to try to establish more information about the pages.
Indeed. Searching for each macro in Confluence earch tool was quite effective and too simple =)
I as still wondering if there is a way to search all macros from a particulat plugin without referring to each of the macro separately. Like as I don't know how many macros a particular plugin supports.
Anyway it is more of a food for thought. Thanks!
Hi there Alex,
If you want to use SQL to find the macros you still have to know the macro names. The SQL is in this kb: How to find all pages and spaces that use a specific macro via SQL
The macros are listed on this page: Metadata macros.
Hope that helps,
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