vicidial.org

Is there a recomended method of joining the calls sent to an agent (in vicidial_agent_log) and the calls reported in the system call log (vicidial_log)?

It seems to me that the uniqueid field from the vicidial_log table should be stored in the corresponding records in the vicidial_agent_log table. Is there a reason this was not done?

In the absence of that field, is there a recommended SQL join that can be used to join the entries in these two tables?

Vince

vicidial.php version and build?

VERSION: 2.0.95 BUILD: 70402-1157

Since there is not a 1 to 1 relationship to those two tables it will not be possible to linke every record to a corresponding one, but the SVN trunk codebase does go a lot farther to link these two together, but not on an exact key link either.

What information are you trying ot get from doing this?