Thank you again, 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.
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. Leandro Il giorno 26/set/2012 00:03, "Stephen Collier" <stephen.coll...@foxaus.com> ha scritto: > I use the following in func_odbc.conf > > [FINDEXTN] > dsn=asterisk > readsql=SELECT ${ARG1} FROM extension_map as em left join sip_devices as > sd on s > d.id = em.name_id WHERE em.extension ='${ARG2}' and name_id IS NOT NULL > > this is for our own extension_map table which is part of our mapping to > our Avaya users. > > A simple one would be > [FINDEXTN] > dsn=asterisk > readsql=SELECT ${ARG1} FROM sip_devices as sd WHERE sd.name ='${ARG2}' > > This allows pulling any field from sip_devices which is our realtime sip > table. > > You could pull some of the other data you are looking for. > > Cheers > Stephen > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users