<div dir="ltr">Admittedly, I have not tried exactly that, but what I do know is, the first and second legs (seq num 0 and num 1) are written to CCD at the same time (at the end of 0 and at the beginning of 1), and therefore, I would not be able to record the menu presses in either if I did your suggestion. My testing has shown me, that a CCV can only be changed/updated before it's committed to CCD. Does your testing/implementation experience say otherwise?<br><br><div class="gmail_quote"><div dir="ltr">On Tue, Jul 18, 2017 at 5:37 PM Bill Talley <<a href="mailto:btalley@gmail.com">btalley@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto"><div>What if you write the menu options to a placeholder variable, passing the placeholder variable in session info and only set the CCV when the contact terminates?<br><br><span style="background-color:rgba(255,255,255,0)">Sent from a mobile device with very tiny touchscreen input keys. Please excude my typtos.</span></div></div><div dir="auto"><div><br>On Jul 18, 2017, at 4:13 PM, Anthony Holloway <<a href="mailto:avholloway+cisco-voip@gmail.com" target="_blank">avholloway+cisco-voip@gmail.com</a>> wrote:<br><br></div><blockquote type="cite"><div><div dir="ltr">I'm working on a menu selection tracking solution, which survives across transfers between department IVRs. It's not going well. In fact, I'm 99% positive it's not possible, and I might have to look outside of UCCX to solve this. I.e., DB or WS integration<div><br></div><div>Scenario: Caller dials Main Line script, selects option 7 for Help Desk, caller gets transferred via Call Redirect step to the Help Desk script, selects option 2 for password reset, then speaks to an Agent. Each script is writing CCV1 with the menu selections made during the script execution.</div><div><br></div><div>I'm seeing in the callcontactdetail (CCD) table that the Session Seq Num 0 is written immediately after the transfer to the Help Desk, and includes the CCV value of 7.</div><div><br></div><div>However, and here's the unexpected part, the Session Seq Num 1 is also written to the CCD table at the same time, with the same CCV value: 7, despite the call still being active on the second script. Then when the call is disconnected, the CCV does not change or get updated for the Session Seq Num 1, which was already written to the CCD table.</div><div><br></div><div>Example CCD Record Set - This query was ran while the call was active on the second leg (seq num 1) and before the call reached an Agent).</div><div><br></div><div><div><font face="monospace">admin:run uccx sql db_cra select limit 2 startdatetime, sessionid, sessionseqnum, applicationname, applicationtaskid, originatordn, callednumber, customvariable6 from contactcalldetail where originatordn like '%16125551212' order by startdatetime desc</font></div><div><font face="monospace">STARTDATETIME SESSIONID SESSIONSEQNUM APPLICATIONNAME APPLICATIONTASKID ORIGINATORDN CALLEDNUMBER CUSTOMVARIABLE1</font></div><div><font face="monospace">------------------------------------------------------------------------------------------------------------------------------------</font></div><div><font face="monospace">2017-07-18 20:36:57.856 50000326646 1 HelpDesk 47000343967 <a href="tel:(612)%20555-1212" value="+16125551212" target="_blank">+16125551212</a> <a href="tel:(612)%20555-1313" value="+16125551313" target="_blank">+16125551313</a> 7,<br></font></div><div><font face="monospace">2017-07-18 20:36:36.872 50000326646 0 MainLine 47000343963 <a href="tel:(612)%20555-1212" value="+16125551212" target="_blank">+16125551212</a> <a href="tel:(612)%20555-1313" value="+16125551313" target="_blank">+16125551313</a> 7,</font></div></div><div><br></div><div>Recall that both records are written to the CCD table after the transfer from the Main Line to the Help Desk, but while the call is still active on the Help Desk script, and before the call is sent to the Agent.</div><div><br></div><div>Anyway, all of your thoughts, opinions, confirmations and disputes are all welcomed. Thanks.</div></div>
</div></blockquote></div><div dir="auto"><blockquote type="cite"><div><span>_______________________________________________</span></div></blockquote></div><div dir="auto"><blockquote type="cite"><div><br><span>cisco-voip mailing list</span><br><span><a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a></span><br><span><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a></span><br></div></blockquote></div></blockquote></div></div>