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
Joining vicidial_agent_log and vicidial_log
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
4 posts
• Page 1 of 1
Joining vicidial_agent_log and vicidial_log
by vincev » Thu Oct 16, 2008 12:31 pm
- vincev
- Posts: 2
- Joined: Thu Oct 09, 2008 12:03 pm
by mflorell » Fri Oct 17, 2008 3:08 pm
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?
What information are you trying ot get from doing this?
- mflorell
- Site Admin
- Posts: 18406
- Joined: Wed Jun 07, 2006 2:45 pm
- Location: Florida
4 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 450 guests