Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Find spaces in confluence that use specific plugin (Confluence 5.1)

karthikys April 9, 2014

Hi,

Can anyone help with the below query to retrieve the list of spaces/pages in Confluence that uses community forum macro.

we tried using following keywords(community, forum, forum:) but nothing helped us.

Select CONTENT.CONTENTID, Title, SpaceID, CREATOR, LASTMODDATE
from CONTENT, BODYCONTENT
WHERE
PREVVER IS NULL
AND (CONTENTTYPE = 'PAGE') 
AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID 
AND CONTENT_STATUS = 'current'
AND (BODY like '%{macroName%')

Thank you.

3 answers

1 accepted

1 vote
Answer accepted
FelipeA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 9, 2014

Hi Karthik

This is what I did:

Select CONTENT.CONTENTID, Title, SpaceID, CREATOR, LASTMODDATE
from CONTENT, BODYCONTENT
WHERE
PREVVER IS NULL
AND (CONTENTTYPE = 'PAGE') 
AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID 
AND CONTENT_STATUS = 'current'
AND ((BODY like '%ac:name=\”communities\”%') OR (body LIKE '%ac:name=\"user-info\"%'));

Basically you'll have to list all Community Bubbles macros. The above query will return just pages with {communities} OR {user-info}, so you'll have to extend this OR to include all macros listed on that page.

Best regards,

Felipe Alencastro

0 votes
Shaun Dyble May 1, 2014

Hi guys, Im using Python to perform the above query and Im finding its taking a very long time to return any results. Is this to be expected?

Honeywell JIRA Admin May 10, 2014

Yes, this is expected. Mostly depends on the no. of spaces it needs to go through.

karthikys May 10, 2014

Yes, this is expected. Mostly depends on the no. of spaces it needs to go through.

0 votes
FelipeA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 9, 2014

Hi Karthik,

They're not stored as {macroName} on the database. This is what they look like on storage format:

<ac:structured-macro ac:name"macroName">

Please let me know if the below query works for you:

Select CONTENT.CONTENTID, Title, SpaceID, CREATOR, LASTMODDATE
from CONTENT, BODYCONTENT
WHERE
PREVVER IS NULL
AND (CONTENTTYPE = 'PAGE') 
AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID 
AND CONTENT_STATUS = 'current'
AND (BODY like '%ac:name=\”macroName\”%');

Kind Regards,

Felipe Alencastro

karthikys April 9, 2014

Hi Felipe,

Thanks for taking time to respond.

We have already tried this way but we couldn't make the query work for Community bubbles macro, maybe because of 25 sub macro that comes along with this macro.

Could you please let us know the storage format of this macro or any suggestions on how to query this !!

Regards,

Karthik

Honeywell JIRA Admin April 9, 2014

Hi Felipe,

Thanks for taking time to respond.

We have already tried this way, but we couldn't make the query work for Community Bubbles Macro maybe because of 25 sub-macros included with this macro.

Could you please let us know the storage format of Community bubbles Macro or any suggestions on how to query !!

Regards,

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, loom, loom for training, loom for teaching, video training, async learning, online education, screen recording, loom tutorials, loom use cases, atlassian learning, team training tools, instructional video, virtual training tools

🛗 Elevate Your Training and Enablement with Loom

Join us June 26, 11am PT for a webinar with Atlassian Champion Robert Hean & Loom’s Brittany Soinski. Hear tips, stories, and get your burning questions answered. Learn how Loom makes training and enablement easier. Don’t miss it!

Register today
AUG Leaders

Atlassian Community Events