Report on Routings | Community
Skip to main content
Level 3
October 10, 2024
Solved

Report on Routings

  • October 10, 2024
  • 1 reply
  • 606 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by KatherineLa

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. 

 

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

 

1 reply

KatherineLa
Community Advisor
KatherineLaCommunity AdvisorAccepted solution
Community Advisor
October 10, 2024

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. 

 

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

 

Level 3
October 10, 2024

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

I appreciate the swift reply!