Viewing all used Tags - FogBugz Knowledge Exchange

Viewing all used Tags

2010-01-25T12:09:39Z

Is there an easy way to see all tags used in the system?

We use tags to classify support cases and are after an easy way to see how many cases with each tag have been received/entered in the system.

At the moment finding this out involves listing all tickets grouped/ordered by tag and then going through and counting each one.

2010-01-25T13:09:42Z

It would be nice if the XML API had a listTags command for this, but I can't see one.

If you have access to the database, you can use the following SQL:

SELECT sTag, count(ixBug) FROM tag t JOIN tagassociation a ON t.ixTag = a.ixTag GROUP BY a.ixBug;

To get the names of the cases for each tag:

SELECT sTag, b.ixBug, sTitle FROM tag t JOIN tagassociation a ON t.ixTag = a.ixTag JOIN bug b ON b.ixBug = a.ixBug;

And to just get the list of tags:

SELECT sTag FROM tag t;

2010-02-08T04:40:03Z

Click on "Reports". At the bottom of the list you'll find "Tags."

There, you'll find all of the tags in the system with an intelligent searching field and other cool features.