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!
Solved! Go to Solution.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Thank you so much - this has provided the information I needed.
I appreciate the swift reply!
Views
Replies
Total Likes