<p>Thanks</p>
<div class="gmail_quote">On Oct 22, 2013 8:30 PM, "Jeff Pyle" <<a href="mailto:jpyle@fidelityvoice.com">jpyle@fidelityvoice.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hello,<div><br></div><div>You can set a dialog flag with <a href="http://www.opensips.org/html/docs/modules/devel/dialog.html#id295687" target="_blank">set_dlg_flag()</a>. That flag will show up in the DB table if you have <a href="http://www.opensips.org/html/docs/modules/devel/dialog.html#id293698" target="_blank">db_mode</a> set to 1. The flags you set will appear as a bitmapped integer in the <a href="http://www.opensips.org/html/docs/modules/devel/dialog.html#id294602" target="_blank">script_flags</a> column.</div>
<div><br></div><div>So, if you set_dlg_flag("10") for inbound calls and set_dlg_flag("20") for outbound calls, you'll see either 1024 for inbound or 1048576 for outbound in the DB. You'll want to pick values that make sense for you.</div>
<div><br></div><div class="gmail_extra">Another option is to use dialog profiles. You could assign dialogs to profiles named "inbound" and "outbound", for example, then count them with an MI command. This way the database is unrelated, and depending on server load, greatly enhance efficiency compared to realtime dialog updates to the DB. The profile name itself may appear in the DB record also; you'll want to test that one if you think it might be useful for you.</div>
<div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><div><div dir="ltr"><div>- Jeff</div><div><br></div></div></div>
<br><br><div class="gmail_quote">On Tue, Oct 22, 2013 at 1:12 PM, Schneur Rosenberg <span dir="ltr"><<a href="mailto:rosenberg11219@gmail.com" target="_blank">rosenberg11219@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Hi, I'm trying to pull the active calls from the dialog table to output on a client portal, I would like to know if I can set some kind of flag in my script that will change a field in the db table, so I can do a query on that field.</div>
<br></blockquote></div><br></div></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div>