Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Report on Routings

Avatar

Level 2

Has anybody been able to create a report on routings from queue topics?

I am doing some housekeeping within Teams and there are a few people whom have now the business - I don't want to delete/deactivate any Team in case other people (in the team) are still using that routing.

 

Maybe some text mode can help but not sure where to start on that.

 

Thank you!

1 Accepted Solution

Avatar

Correct answer by
Level 9

This is a shot of the headers in my favorite queue-level report, which I think has what you're looking to see. We only use person or team routings, so I've never needed to include role/project options but it could easily be extended to cover that once you have the pattern. 

 

KatherineLa_0-1728568733756.png

displayname=Request Routing Settings (if no Sub-Topics available)
linkedname=defaultRoute
namekey=view.relatedcolumn
namekeyargkey.0=defaultRoute
namekeyargkey.1=defaultTeamID
querysort=defaultRoute:defaultTeamID
textmode=true
valueexpression=concat("Team: ",{defaultRoute}.{defaultTeam}.{name},"\\u000A","Person: ",{defaultRoute}.{defaultAssignedTo}.{name})
valueformat=HTML

 

displayname=Sub-Topic Routing Settings
listdelimiter=<p>
listmethod=nested(queueTopics).lists
textmode=true
type=iterate
valueexpression=concat("Topic Name: ",{name},"\\u000a","Team: ",{defaultRoute}.{defaultTeam}.{name},"\\u000a","Person: ",{defaultRoute}.{defaultAssignedTo}.{name},"\\u000a","Duration (in Minutes): ",{defaultDurationMinutes},"\\u000a","Custom Form: ",{defaultCategory}.{name},"\\u000a","")
valueformat=HTML

 

View solution in original post

2 Replies

Avatar

Correct answer by
Level 9

This is a shot of the headers in my favorite queue-level report, which I think has what you're looking to see. We only use person or team routings, so I've never needed to include role/project options but it could easily be extended to cover that once you have the pattern. 

 

KatherineLa_0-1728568733756.png

displayname=Request Routing Settings (if no Sub-Topics available)
linkedname=defaultRoute
namekey=view.relatedcolumn
namekeyargkey.0=defaultRoute
namekeyargkey.1=defaultTeamID
querysort=defaultRoute:defaultTeamID
textmode=true
valueexpression=concat("Team: ",{defaultRoute}.{defaultTeam}.{name},"\\u000A","Person: ",{defaultRoute}.{defaultAssignedTo}.{name})
valueformat=HTML

 

displayname=Sub-Topic Routing Settings
listdelimiter=<p>
listmethod=nested(queueTopics).lists
textmode=true
type=iterate
valueexpression=concat("Topic Name: ",{name},"\\u000a","Team: ",{defaultRoute}.{defaultTeam}.{name},"\\u000a","Person: ",{defaultRoute}.{defaultAssignedTo}.{name},"\\u000a","Duration (in Minutes): ",{defaultDurationMinutes},"\\u000a","Custom Form: ",{defaultCategory}.{name},"\\u000a","")
valueformat=HTML

 

Avatar

Level 2

Thank you so much - this has provided the information I needed.

I appreciate the swift reply!