06-04-2012 08:23 AM - edited 03-14-2019 09:59 AM
HI All
Does anyone happen to know how the crystal reports in the uccx 8.5 historial reports work? For example, I opened the agent summary report and it seems to be calling a stored procedure called sp_agent_summary however I don't see any select statements in the function. So how does it pull the data from the database?
Thanks
Solved! Go to Solution.
06-11-2012 04:39 PM
Hi,
sp_agent_summary is a stored procedure. All select statements will be contained in the stored procedure itself. Crystal Reports will just invoke the SPL with the appropriate arguments and it will do the queries in the DB and then just return the results in table form.
If you want to see the actual queries in the SPL you can connect to the DB Informix instance with something like Squirrel or AGS with uccxhruser, you can read the SPLs and see the actual commands. More info on this is in the HR Admin and Dveloper guide.
-Ryan
This post was made from the TSC at CiscoLive 2012!
06-12-2012 12:33 AM
Hi
You'll need to look a bit closer at the function - it sounds like you have opened the function and seen the SQL?
Somewhere in the code are references to 'getAgentSummary' which is another function/procedure that is called from within this function. There's a lot of this done in the standard reports, one function might call another that may call several other utility functions so it's a fun learning experience.
Regards
Principal Engineer at Logicalis UK
Please rate helpful posts...
06-11-2012 04:39 PM
Hi,
sp_agent_summary is a stored procedure. All select statements will be contained in the stored procedure itself. Crystal Reports will just invoke the SPL with the appropriate arguments and it will do the queries in the DB and then just return the results in table form.
If you want to see the actual queries in the SPL you can connect to the DB Informix instance with something like Squirrel or AGS with uccxhruser, you can read the SPLs and see the actual commands. More info on this is in the HR Admin and Dveloper guide.
-Ryan
This post was made from the TSC at CiscoLive 2012!
06-12-2012 12:33 AM
Hi
You'll need to look a bit closer at the function - it sounds like you have opened the function and seen the SQL?
Somewhere in the code are references to 'getAgentSummary' which is another function/procedure that is called from within this function. There's a lot of this done in the standard reports, one function might call another that may call several other utility functions so it's a fun learning experience.
Regards
Principal Engineer at Logicalis UK
Please rate helpful posts...
06-12-2012 04:17 PM
The procedure I needed was called getTotalCalls that gave me the info for calls presented and handled.
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