<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">try $(fU{s.escape.common})</div><br class=""><div><blockquote type="cite" class=""><div class="">On Jan 25, 2016, at 4:09 PM, Travis Manson-Drake <<a href="mailto:travism@simplybits.com" class="">travism@simplybits.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="WordSection1" style="page: WordSection1; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Hello everyone,<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">I can’t seem to find any documentation on how to format my Query while using the {s.escape.common} transformation.<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">I tried setting it up as follows:<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">select MAC FROM `phone_registrations` where auth_userid = '$fU{s.escape.common}'))", "$avp(PBX)")<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">however the query just returns the value PV $fU with {s.escape.common} in the return, for example 7117test{s.escape.common}<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">where should I apply the transformation? Can someone give me an example?<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Thank you for your time.<o:p class=""></o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" width="312" style="width: 3.25in;"><tbody class=""><tr class=""><td width="308" valign="top" style="width: 231pt; padding: 0in;" class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 15.399999618530273px;" class=""><span style="font-size: 13pt; line-height: 18.200000762939453px; font-family: 'Segoe UI', sans-serif; color: rgb(24, 132, 198); letter-spacing: -0.75pt;" class="">Travis Manson-Drake<br class=""></span><span style="font-size: 13pt; line-height: 18.200000762939453px; font-family: 'Segoe UI', sans-serif; color: rgb(247, 147, 33); letter-spacing: -0.75pt;" class="">Voice Systems Analyst<o:p class=""></o:p></span></div></td></tr></tbody></table><p class="MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;"></p><table class="MsoNormalTable" border="1" cellspacing="3" cellpadding="0" width="312" style="width: 3.25in; border-style: solid none none; border-top-color: windowtext; border-top-width: 2.25pt;"><tbody class=""><tr style="height: 1.35pt;" class=""><td width="308" style="width: 231pt; border: none; padding: 0.75pt; height: 1.35pt;" class=""><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 15.399999618530273px;" class=""><span style="font-size: 13pt; line-height: 18.200000762939453px; font-family: 'Segoe UI', sans-serif; color: rgb(24, 132, 198); letter-spacing: -0.75pt;" class="">Simply Bits, LLC<br class=""></span><span style="font-size: 10pt; line-height: 14px; font-family: 'Segoe UI', sans-serif; letter-spacing: 1pt;" class="">T:</span><span style="font-size: 10pt; line-height: 14px; font-family: 'Segoe UI', sans-serif; color: rgb(31, 73, 125); letter-spacing: 1pt;" class=""><span class="Apple-converted-space"> </span></span><span style="font-size: 10pt; line-height: 14px; font-family: 'Segoe UI', sans-serif; color: rgb(27, 132, 199); letter-spacing: 1pt;" class="">520.545.0311 <span class="Apple-converted-space"> </span></span><span style="font-size: 10pt; line-height: 14px; font-family: 'Segoe UI', sans-serif; color: rgb(45, 45, 45); letter-spacing: 1pt;" class="">F:</span><span style="font-size: 10pt; line-height: 14px; font-family: 'Segoe UI', sans-serif; color: rgb(31, 73, 125); letter-spacing: 1pt;" class=""><span class="Apple-converted-space"> </span></span><span style="font-size: 10pt; line-height: 14px; font-family: 'Segoe UI', sans-serif; color: rgb(27, 132, 199); letter-spacing: 1pt;" class="">520.545.7252<br class=""></span><span style="font-size: 10pt; line-height: 14px; font-family: 'Segoe UI', sans-serif; letter-spacing: 1pt;" class="">E:</span><span style="font-size: 10pt; line-height: 14px; font-family: 'Segoe UI', sans-serif; color: rgb(31, 73, 125); letter-spacing: 1pt;" class=""><span class="Apple-converted-space"> </span></span><span style="font-size: 10pt; line-height: 14px; font-family: 'Segoe UI', sans-serif; color: rgb(27, 132, 199); letter-spacing: 1pt;" class=""><a href="mailto:email@simplybits.com" style="color: rgb(149, 79, 114); text-decoration: underline;" class=""><span style="color: rgb(5, 99, 193);" class="">email@simplybits.com</span></a> <br class=""></span><span style="font-size: 10pt; line-height: 14px; font-family: 'Segoe UI', sans-serif;" class="">5225 N. Sabino Canyon Road<br class="">Tucson, AZ 85750<br class=""></span><span style="font-size: 10pt; line-height: 14px; font-family: 'Segoe UI Semibold', sans-serif;" class="">Support Hotline: 520.545.0333</span><span style="font-size: 10pt; line-height: 14px; font-family: 'Segoe UI Semibold', sans-serif; color: rgb(118, 113, 113);" class=""><o:p class=""></o:p></span></div></td></tr></tbody></table><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div></div><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">_______________________________________________</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Users mailing list</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><a href="mailto:Users@lists.opensips.org" style="color: rgb(149, 79, 114); text-decoration: underline; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">Users@lists.opensips.org</a><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" style="color: rgb(149, 79, 114); text-decoration: underline; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></div></blockquote></div><br class=""></body></html>