In our large confluence instance we want to delete strange/unwanted labels which have been created by unknown occasion/reason but to delete then manually from the pages is a tedieus task.
Is this prossible with sql, directly on the database or other plugin/option?
Because of the foreign key, you'd need to remove the relevant entries form the content_label table first. For example:
DELETE FROM content_label WHERE labelid IN (SELECT labelid FROM label WHERE name = 'labelname');
Then follow that with:
DELETE FROM label WHERE name = 'labelname';
Please keep in mind this has not been tested, so be sure you back up your database first, or better yet, test this on a dev instance.
Labels are stored in the LABEL table, so you could use SQL to remove the labels that way. The other option would be to use the Command Line Interface plugin as this will also allow you to manage and delete the labels stored in your Confluence instance.
All the best,
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
Wherever you are in your team’s journey , our goal is to support your big ambitions. We’re a cloud-first company with the mission of unleashing the potential of every team, and to address the range ...
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