cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
523
Views
4
Helpful
1
Replies

CUIC - Old Agent Names show up in the filter lists

solomonluke
Level 4
Level 4

CUIC v10.5 - Old Agent Names show up in the filter lists. I am trying to create Collection Query to list only active agents based on this workaround for bug CSCug62201

https://bst.cloudapps.cisco.com/bugsearch/bug/CSCug62201/?reffering_site=dumpcr

Add the following Collection Query to the UCCX_AgentName Value List:

SELECT DISTINCT resourcename AS ID, resourcename AS VALUE FROM Resource WHERE active=

Add a collection called 'Active' to the UCCX_AgentName Value List of type 'Identifier' with the identifier defined as 't'.

When I test this I get SQL error (see attached). I have no experience with SQL

Is this SQL Query correct?

Thanks

Solomon

1 Reply 1

solomonluke
Level 4
Level 4

So I was missing the 't' at the end of the statement.

SELECT DISTINCT resourcename AS ID, resourcename AS VALUE FROM Resource WHERE active='t'

This is now working!

Solomon