It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can I assign labels for child nodes (by SQL query)?

Stefan Eike Nov 05, 2012


I use a very strict labelling in our Confluence instance. I have a node with hundreds of child nodes. To create some new reports and filters (site has label xy or has not label yz queries) I need some new labels. (How) can I create a batch process for that (e.g. by SQL query)? Also interesting is to know, how can I do it the other way round?

Best regards


2 answers

1 accepted

0 votes
Answer accepted
Stefan Eike Feb 12, 2013

Hi Anselmo,

because many sites I neededto relabel used a live-template (Customware), I simply used a macro to do that. First, I removed all labels with a small user macro:

#set($currentlabels = $content.getLabels())
#foreach($label in $currentlabels)
#set($success = ${action.labelManager.removeLabel($content, $label)})

After I removed everything from that pages, I removed the user macro. Then I put an add-label macro in my live-template:


And sometimes a second one to get some Scaffolding data:


That did it for me, maybe it is helpful for you as well. Have fun and good luck!

0 votes
Anselmo Feb 10, 2013

I see, what this kind of query by labels is good for and want to use the same. But I want to do it without SQL.

The best I can imagine is a LabelManager, which shows all used labels in a hierarchy an gives the opportunity to apply them on certain levels of the hierarchy (assigning it to all children at once optionally).

Also replacing different spelling of labels should be possible. On top an undo function might make the solution perfect.

It's a long time to Christmas from now. Let's see, what Santa will have for us.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

I attended  Atlassian Summit 2019  and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...

2,504 views 11 28
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you