Bulk label removal

Question

I would like to remove a specific label from all pages it is currently applied to. This label is tied to a workflow which is being separated into multiple smaller segments and needs to be removed from many pages in a hurry.

There is apparently not a way to do so via the UI so I am looking into the necessary commands to do so via the SQL interface. We are running a MySQL back end.

It would appear from http://confluence.atlassian.com/pages/viewpage.action?pageId=179439242 that all I need to do would be:

select * from label where name='draft-workflow';

delete from content_label where labelid=<label id="" from="" above="">;

Please verify if there is anything more required to do this.

Mert Karadağlı _ Köstebek Teknoloji _ · Answer

Hi,

You could do it with Label Manager for Confluence plug in.https://marketplace.atlassian.com/plugins/com.kostebekteknoloji.plugins.confluence.confluence-label-manager
You could search for similar labels in a space and then merge them into one standard label.
You could also do bulk operations like appending , adding and removing labels.
Documentation is here:http://www.confluence.kostebekteknoloji.com/display/PLUG/Label+Manager+for+Confluence
Regards,

Rodrigo Girardi Adami · Answer

Hello Tim,

AFAIK, you are in the correct path already. :)

The connection bewteen the pages and labels is the table content_label, so if you remove the offending label from this table, it will remove the page labels as well.

I hope this help. note to perform backups of your database before attempting this type of modification. just my 5 cent ;)

Regards,

Rodrigo