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

Stefan Eike2

Hi,

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

Stefan

Stefan Eike2

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)})
#end

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

{add-label:MYLABEL}

And sometimes a second one to get some Scaffolding data:

{add-label:%data:tools%}

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