<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Monaco;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Nothing has changed on this in quite a while.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>See <a href="https://freeswitch.org/confluence/display/FREESWITCH/XML+Dialplan">https://freeswitch.org/confluence/display/FREESWITCH/XML+Dialplan</a> and also checkout the inline=”true” option. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> FreeSWITCH-users <freeswitch-users-bounces@lists.freeswitch.org> <b>On Behalf Of </b>Rick Jarvis<br><b>Sent:</b> Thursday, March 7, 2019 9:18 AM<br><b>To:</b> FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org><br><b>Subject:</b> Re: [Freeswitch-users] Variable no longer showing in channels<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'>Sorry to nudge...<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:black'><br>From: Rick Jarvis <a href="mailto:rick@magicmail.mooo.com"><rick@magicmail.mooo.com></a><br>Reply: Rick Jarvis <a href="mailto:rick@magicmail.mooo.com"><rick@magicmail.mooo.com></a><br>Date: 25 February 2019 at 23:04:17<br>To: FreeSWITCH Users Help <a href="mailto:freeswitch-users@lists.freeswitch.org"><freeswitch-users@lists.freeswitch.org></a><br>Subject: Re: [Freeswitch-users] Variable no longer showing in channels <o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><br><br><o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'>Sorry Mike, can you expand on that? It was all working fine before, so I’m not sure either what “has changed” or what “needs to change”, if you see what I mean!<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:black'><br>From: Mike Jerris <a href="mailto:mike@freeswitch.org"><mike@freeswitch.org></a><br>Reply: FreeSWITCH Users Help <a href="mailto:freeswitch-users@lists.freeswitch.org"><freeswitch-users@lists.freeswitch.org></a><br>Date: 25 February 2019 at 21:08:18<br>To: FreeSWITCH Users Help <a href="mailto:freeswitch-users@lists.freeswitch.org"><freeswitch-users@lists.freeswitch.org></a><br>Subject: Re: [Freeswitch-users] Variable no longer showing in channels<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><br><br><o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'>The dial plan is parsed and extensions created, and then they are run. The ${callsubject} in your log line is evaluated in routing state, before httapi is run in execute state <o:p></o:p></span></p><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><br><br><o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'>On Feb 25, 2019, at 12:08 PM, Rick Jarvis <<a href="mailto:rick@magicmail.mooo.com">rick@magicmail.mooo.com</a>> wrote:<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><o:p> </o:p></span></p><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'>I got this working (with the help of this list) some time ago, but for some reason it seems to have stopped working.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'>I’m setting a variable ‘callsubject’ in the dialplan via httapi, for which I added a column in the channels table:<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.5pt;font-family:"Courier New";color:#333333'>ALTER TABLE channels ADD COLUMN callsubject VARCHAR(256)</span><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#F2F2F2'> </span><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#2FB41D'><o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#F2F2F2'> </span><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#2EAEBB'><action</span><span class=apple-converted-space><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#2FB41D'> </span></span><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#2FB41D'>application="httapi" data="{url=<a href="https://server/$%7Bdestination_number%7D%7D%E2%80%9D/">https://server/${destination_number}}”/</a></span><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#2EAEBB'>> <!-- gets variable callsubject as ’test’, amongst other stuff --></span><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#2FB41D'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#F2F2F2'> <span class=apple-converted-space> </span></span><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#2EAEBB'><action</span><span class=apple-converted-space><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#2FB41D'> </span></span><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#2FB41D'>application="log" data="CRIT callsubject: ${callsubject}”/</span><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#2EAEBB'>> <!-- correctly shows ’test’ --></span><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#2FB41D'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#2EAEBB'><br><br></span><span style='font-size:9.0pt;font-family:"Monaco",serif;color:#2FB41D'><o:p></o:p></span></p></div></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'>And yet, whilst the column shows up in ’show channels’, the leg in question has an empty value.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'>What am I missing, maybe?<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><o:p> </o:p></span></p></div></blockquote></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'><o:p> </o:p></span></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'>_________________________________________________________________________<br>Professional FreeSWITCH Services<br><a href="mailto:sales@freeswitch.com">sales@freeswitch.com</a><br><a href="https://freeswitch.com">https://freeswitch.com</a><br><br>Official FreeSWITCH Sites<br><a href="https://freeswitch.com/oss">https://freeswitch.com/oss</a><br><a href="https://freeswitch.org/confluence">https://freeswitch.org/confluence</a><br><a href="https://cluecon.com">https://cluecon.com</a><br><br>FreeSWITCH-users mailing list<br><a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br><a href="https://freeswitch.com">https://freeswitch.com</a><o:p></o:p></span></p></div></div></blockquote><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif'>_________________________________________________________________________<br>Professional FreeSWITCH Services<br><a href="mailto:sales@freeswitch.com">sales@freeswitch.com</a><br><a href="https://freeswitch.com">https://freeswitch.com</a><br><br>Official FreeSWITCH Sites<br><a href="https://freeswitch.com/oss">https://freeswitch.com/oss</a><br><a href="https://freeswitch.org/confluence">https://freeswitch.org/confluence</a><br><a href="https://cluecon.com">https://cluecon.com</a><br><br>FreeSWITCH-users mailing list<br><a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br><a href="https://freeswitch.com">https://freeswitch.com</a><o:p></o:p></span></p></div></div></blockquote></div></body></html>