[OpenSIPS-Users] Best way to retrieve a data from location database

[Bogdan-Andrei Iancu]

and what is the data you are looking for ?

look at the attr_avp param too :
http://www.opensips.org/html/docs/modules/1.11.x/registrar.html#id293909

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 19.06.2014 12:56, Miguel Oyarzo wrote:
>
> Hi Bodgan,
>
> Oh yes, but this function (lookup) doesn't seems to return the data 
> what I'm looking for inside of this specific table.
> At least, the documentation you mentioned doesn't show an example.
>
> Is there any way to retrieve data from that table? I need specifically 
> the contact info stored into location, for the specif user.
>
> Thanks,
>
>
>
>
> On Thu, Jun 19, 2014 at 7:52 PM, Bogdan-Andrei Iancu 
> <bogdan at opensips.org <mailto:bogdan at opensips.org>> wrote:
>
>     Hi Miguel,
>
>     Have you looked at the lookup() function from the registrar module ?
>     http://www.opensips.org/html/docs/modules/1.11.x/registrar.html#id294366
>
>     Regards,
>
>     Bogdan-Andrei Iancu
>     OpenSIPS Founder and Developer
>     http://www.opensips-solutions.com
>
>     On 19.06.2014 12:48, Miguel Oyarzo wrote:
>>     Hi,
>>
>>     What is the best way to read a data from the location database?
>>     I'm using postgreSQL.
>>
>>
>>     E.g. Assuming there is a registered user:
>>
>>     if (is_method("INVITE")) {
>>         $var(x)=read_data_from_location(" select contact where
>>     user='71000' ");
>>         ...
>>         // do something with $var(x)
>>         ..
>>         ..
>>     }
>>
>>     Thanks,
>>
>>     -- 
>>     "Efficiency is doing things right; effectiveness is doing the
>>     right things(Peter Drucker)"
>>
>>     Miguel Oyarzo
>>     DevOps & VoIP Engineer
>>     Linux User: # 483188 - counter.li.org <http://counter.li.org>
>>     http://au.linkedin.com/in/mikeaustralia
>>     Melbourne, Australia
>>
>>
>>     _______________________________________________
>>     Users mailing list
>>     Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
>
> -- 
> "Efficiency is doing things right; effectiveness is doing the right 
> things(Peter Drucker)"
>
> Miguel Oyarzo
> DevOps & VoIP Engineer
> Linux User: # 483188 - counter.li.org <http://counter.li.org>
> http://au.linkedin.com/in/mikeaustralia
> Melbourne, Australia

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140619/9bd32213/attachment.htm>