Bulk label removal

Tim Brigham May 13, 2012

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.

2 answers

0 vote

Rodrigo Adami Atlassian Team May 07, 2013

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