08-22-2017 02:47 AM - edited 03-14-2019 05:32 PM
Hi All,
Our Environment is running on UCCE 8.5.
Custom SQL Query : Created a Custom SQL query to produce desired results and it works in Admin workstation.
Problem: in CUIC --> when i run the same query it returns "0 records" .
I have attached Custom query , please review and advise on the same.
Regards,
Srinivas
Solved! Go to Solution.
08-22-2017 02:52 AM
Please find Attached document -- Query & some more details.
Problem: in CUIC --> when i run the same query it returns "0 records" --> Noticed : CUIC is sending e.enterprisename IN 5048 to SQL. Where 5048 is AgentTeamID
When i change search criteria to AgentTeam ID and save report definition --> provide AgentTeamID number and run CUIC report --> it works . Noticed : CUIC is sending e.enterprisename IN 5048 to SQL. Where 5048 is AgentTeamID
08-22-2017 02:52 AM
Please find Attached document -- Query & some more details.
Problem: in CUIC --> when i run the same query it returns "0 records" --> Noticed : CUIC is sending e.enterprisename IN 5048 to SQL. Where 5048 is AgentTeamID
When i change search criteria to AgentTeam ID and save report definition --> provide AgentTeamID number and run CUIC report --> it works . Noticed : CUIC is sending e.enterprisename IN 5048 to SQL. Where 5048 is AgentTeamID
08-22-2017 10:25 AM
What do you put in search criteria when run the report? your defination just works fine in my lab.
08-27-2017 01:07 PM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide