Ticket Labels are great, but...
Deleting a ticket with a label doesn't always remove the swlabellink record and skews up the label counts. (referential integrity would have been helpful here) Usually deleting the orphaned record fixes the label count but that trick isn't working in the latest CVS build.
You can find the orphaned labellinks with the following query and then delete them.
Code:
; find orphaned ticket labels
select tll.ticketlabellinkid from swticketlabellinks tll left join swtickets t ON t.ticketid = tll.ticketid where t.ticketid is null
; delete them manually :(
delete from swticketlabellinks where ticketlabellinkid in (xxx, ..., xxx)
Another thing I noticed while trying to fix my label counts is the swticket.islabeld field...
I currently have about 28 tickets labeled, but looking at "select count(islabeled) from swtickets where islabeled = 1" gave me 120! No idea why they are not being un-'islabeled'.
Mass Action to remove labels doesn't work.
Deleting labels is possible, but not intuitive... Like right now, I cant remember where that function is :P
You can't change labels while replying to a ticket.
And most importantly, There is no way to search for tickets using label as a criteria. There is 'Flag' but not label. Maybe you could add labels to the flags dropdown like for mass actions, but I really think it deserves it's own category.
Similar Threads 
Linear Mode
