We have a label map on our landing page showing all the popular labels in our space - it contains a whole bunch of labels that simply don't have pages associated with them. At first I assumed they existed on pages that were in the Trash, but I've since checked and the Trash is empty.
So how do I get rid of these labels? Or are we doomed to have an ever-growing map of unused tags?
That would make the product a lot less useful :(
You could also use the CLI for this:
confluence --action removeLabels --space "zconfluencecli" --title "This is title 0" --labels "testLabel1, testLabel2"
You can also getLabelList. In general that's a great utility for any kind of mass operation.
I completely agree with @Phil Lancaster on this matter. This absolutely needs to become a standard feature of confluence. Actually it seems to be a bug, that labels attached to no content at all, are displayed in popular label lists, etc. But I've browsed some related issues, and there seems to be quite some history with this matter. Unfortunately, the outcome is rather unsatisfying.
I agree with @Phil Lancaster and @Angelo Hannes as well, and think this should be a standard feature. I've seen some plugins, but it makes no sense that a standard Macro would show labels that are not in use. What purpose would that serve other than to clutter the interface.
Is there anyway to stop this, other than find and filter out all the unwanted labels from the macro?
I have exactly the same problem. Labels that are not attached to any page appearing in the labels list macro. Reindexing makes no difference except to inconvenience users while it's happening. I have no intention of using either the CLI or mucking around with the database to fix something that so obviously should just happen. If there are no pages associated with a label, it should disappear. This is a bug and should be just fixed without requiring a use case or 100 people reporting or documenting it. There's far to much of this kind of thing in Atlassian products.
For this case, to get rid of this label I think it will be better to do it from database side. However please bear in mind that this might cause database inconsistency in your Confluence database, thus please shutdown your Confluence and backup your Confluence database and home directory before doing this.
You can delete it by running the following SQL query.
DELETE FROM LABEL WHERE LABELID NOT IN (SELECT LABELID FROM CONTENT_LABEL);
Please reindex after you've done so. Hope it helps.
I've deleted all the labels that I didn't want from the LABEL table, and the corresponding rows from the CONTENT_LABEL table, but the deleted labels are STILL showing up in the popular labels heatmap. How can I purge them from the heatmap as well? I have re-indexed, purged trash, looked for orphaned pages, etc. They are all gone. There are no labels which correspond to these entries. Where else can I go to delete them from the heatmap?
@Mert Karadağlı your solution is faulty.
I bought your add-on because your trial version limits most label management actions. Follow all your steps to get rid of orphaned labels, yet the labels are still showing up on the "popular macros" heat map.
Am I missing something, or are you deceiving customers?
It was really simple, in my case.
Basically, Confluence was saving in the database all the labels for drafts that were still live, under several user accounts.
The solution was to delete these drafts. Then, run the function again, and voila! the voodoo magic worked.
Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...
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