vicidial.org

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

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.

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)

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