Search all pages with Metadata plugin used in it.


I was wondering if i can could get help with the information on the plugin -

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 -  

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.

2 answers

1 accepted

1 vote
Accepted answer

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! 

Ann Worley Atlassian Team Jun 28, 2017

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,


1 vote
Davin Studer Community Champion Jun 28, 2017

If you are using Confluence 5.10+ there is a Macro Usage page in Confluence Admin that shows you all the macros used in your system and groups them by add-on.

Ann Worley Atlassian Team Jun 28, 2017

Well said! Thank you for mentioning that.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Monday in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

101 views 3 4
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you