Counting Dispos for the day

Discussions about development of VICIDIAL and astGUIclient

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Counting Dispos for the day

Postby Acidshock » Tue Aug 02, 2011 7:45 pm

Does anyone have a recommended query to add up all the statuses that an agent has dispositioned for the day? I am looking to modify the realtime report and have it list the total of each status that the agent has dispo'd for the report. I have been trying to make sense of how its being done currently in the Agent Performance Detail but the SQL query is rather complex and pulls a lot of other data that may not be needed.

SQL is not my strongest language but I must say thanks to VICI I have become a lot more proficient at it.


VERSION: 2.4-310a
BUILD: 110506-1537
Acidshock
 
Posts: 428
Joined: Wed Mar 03, 2010 3:19 pm

Postby mflorell » Tue Aug 02, 2011 9:01 pm

How exactly were you wanting to have this displayed on the Real-time screen? Do you have a mock-up?

Just raw tallies of statuses for calls handled should be a fairly simple query against the vicidial_agent_log table for entries that have a lead_id populated.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby williamconley » Tue Aug 02, 2011 10:46 pm

There is one specific section of the agent detail report that pulls that data, and another that loads it into the viewer. but i agree with matt that for the realtime screen it would probably be simpler to run a fresh query directly against the agent log if all you want is raw status counts. matt could option that in fairly well (and guarantee that it stays in the code for the next upgrade! and likely even gets prettier in future releases! LOL)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Counting Dispos for the day

Postby bobbymc » Tue Jul 10, 2012 6:10 am

you have to be careful not to lock up that table by doing tons of read if the realtime screen gets refreshed often by multiple admins
bobbymc
 
Posts: 425
Joined: Fri Jan 05, 2007 12:26 am


Return to Development

Who is online

Users browsing this forum: No registered users and 36 guests