<p>Thank you again,<br>
The problem in this setup is the inability to isolate a group of extensions from others. I mean, if all hints are in the same context, each extension can subscribe to any of the hints. The reason I prefer a completely realtime hints was I'd like to dynamically create hints in dynamically created context to jail an extension to only the hints I decide. </p>
<p>I have tried to contact Digium on this topic and I am ready to setup a bounty to have a true realtime hints management coded if not already available.</p>
<p>Leandro</p>
<div class="gmail_quote">Il giorno 26/set/2012 00:03, "Stephen Collier" <<a href="mailto:stephen.collier@foxaus.com">stephen.collier@foxaus.com</a>> ha scritto:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I use the following in func_odbc.conf<br>
<br>
[FINDEXTN]<br>
dsn=asterisk<br>
readsql=SELECT ${ARG1} FROM extension_map as em left join sip_devices as sd on s<br>
<a href="http://d.id" target="_blank">d.id</a> = em.name_id WHERE em.extension ='${ARG2}' and name_id IS NOT NULL<br>
<br>
this is for our own extension_map table which is part of our mapping to our Avaya users.<br>
<br>
A simple one would be<br>
[FINDEXTN]<br>
dsn=asterisk<br>
readsql=SELECT ${ARG1} FROM sip_devices as sd WHERE <a href="http://sd.name" target="_blank">sd.name</a> ='${ARG2}'<br>
<br>
This allows pulling any field from sip_devices which is our realtime sip table.<br>
<br>
You could pull some of the other data you are looking for.<br>
<br>
Cheers<br>
Stephen<br>
<br>
<br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
<br>
<br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</blockquote></div>