Create a report that shows projects grouped by Topic Group.

Question

I need to create a report that lists all projects/templates. Ideally I would like all of the topic groups and queue topics listed but I would settle for grouped by Topic Group. My goal is to find all of the projects that are using specific Topic Groups/Queue Topics that are outdated and need to be updated.

The closest I got was to run an issue report > make a column for the project > and then it gives the option for Parent Topic Group. Unfortunately the one I am looking or is rarely the Parent Topic Group. Is there a way to edit the code to include any topic group and not just the parent one?

imgrund · Answer

Hi Tracy - you can do both a Queue Topic report (which has a Parent Topic Group field you can group by). There is also a Topic Group report itself as well.

The biggest think is that both need some text mode to display the project name. (which is the same for both object types)

displayname=Project

querysort=queueDef:project:name

textmode=true

valuefield=queueDef:project:name

valueformat=HTML

I don't think this will apply to FCB, but just remember that if there are only queue topics, the Topic Group is the project name so the report sometimes looks a little weird. LOL!

Hope that helps :)

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded