<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix"><tt>and what is the data you are looking
        for ?<br>
        <br>
        look at the attr_avp param too :<br>
           
        <a class="moz-txt-link-freetext" href="http://www.opensips.org/html/docs/modules/1.11.x/registrar.html#id293909">http://www.opensips.org/html/docs/modules/1.11.x/registrar.html#id293909</a><br>
        <br>
        Regards,<br>
      </tt>
      <pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
      On 19.06.2014 12:56, Miguel Oyarzo wrote:<br>
    </div>
    <blockquote
cite="mid:CA+d2mV-tSY2ciM2u8J3ZCXsvw8dETBgD4V7YvukDiQsaLBH3WA@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div>
          <div>
            <div>
              <div><br>
              </div>
              Hi Bodgan,<br>
              <br>
            </div>
            Oh yes, but this function (lookup) doesn't seems to return
            the data what I'm looking for inside of this specific table.<br>
          </div>
          <div>At least, the documentation you mentioned doesn't show an
            example.<br>
          </div>
          <div><br>
          </div>
          Is there any way to retrieve data from that table? I need
          specifically the contact info stored into location, for the
          specif user.<br>
          <br>
        </div>
        Thanks,<br>
        <div><br>
          <br>
        </div>
      </div>
      <div class="gmail_extra">
        <br>
        <br>
        <div class="gmail_quote">On Thu, Jun 19, 2014 at 7:52 PM,
          Bogdan-Andrei Iancu <span dir="ltr">&lt;<a
              moz-do-not-send="true" href="mailto:bogdan@opensips.org"
              target="_blank">bogdan@opensips.org</a>&gt;</span> wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div bgcolor="#FFFFFF" text="#000000">
              <div><tt>Hi Miguel,<br>
                  <br>
                  Have you looked at the lookup() function from the
                  registrar module ?<br>
                      <a moz-do-not-send="true"
href="http://www.opensips.org/html/docs/modules/1.11.x/registrar.html#id294366"
                    target="_blank">http://www.opensips.org/html/docs/modules/1.11.x/registrar.html#id294366</a><br>
                  <br>
                  Regards,<br>
                </tt>
                <pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
                <div>
                  <div class="h5"> On 19.06.2014 12:48, Miguel Oyarzo
                    wrote:<br>
                  </div>
                </div>
              </div>
              <blockquote type="cite">
                <div>
                  <div class="h5">
                    <div dir="ltr">
                      <div>
                        <div>
                          <div>
                            <div>Hi,<br>
                              <br>
                            </div>
                            What is the best way to read a data from the
                            location database?<br>
                          </div>
                          <div>I'm using postgreSQL.<br>
                            <br>
                          </div>
                          <div><br>
                          </div>
                          E.g. Assuming there is a registered user:<br>
                          <br>
                          if (is_method("INVITE")) {<br>
                        </div>
                            $var(x)=read_data_from_location(" select
                        contact where user='71000' ");<br>
                            ...<br>
                      </div>
                          // do something with $var(x)
                      <div>    ..<br>
                            ..<br>
                        }<br>
                        <div> <br>
                          <div>
                            <div>
                              <div>
                                <div>
                                  <div>
                                    <div>Thanks,<br clear="all">
                                    </div>
                                    <div><br>
                                      -- <br>
                                      <div dir="ltr">
                                        <div><span
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">"Efficiency

                                            is doing things right;
                                            effectiveness is doing the
                                            right things</span><span
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
                                              (Peter Drucker)</span>"<br>
                                          </span></div>
                                        <br>
                                        <div><span
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Miguel

                                            Oyarzo</span><br
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
                                          <span
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">DevOps

                                            &amp; VoIP Engineer</span><br
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
                                          <span
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Linux

                                            User: # 483188 - </span><font
                                            color="#888888" face="arial,
                                            sans-serif"><a
                                              moz-do-not-send="true"
                                              href="http://counter.li.org"
                                              target="_blank">counter.li.org</a></font><br
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
                                          <span
                                            style="background-color:rgb(255,255,255)"><font
                                              color="#888888"
                                              face="arial, sans-serif"><a
                                                moz-do-not-send="true"
                                                href="http://au.linkedin.com/in/mikeaustralia"
                                                target="_blank">http://au.linkedin.com/in/mikeaustralia</a> </font><br>
                                            <font color="#888888"
                                              face="arial, sans-serif">Melbourne,
                                              Australia</font></span> </div>
                                      </div>
                                    </div>
                                  </div>
                                </div>
                              </div>
                            </div>
                          </div>
                        </div>
                      </div>
                    </div>
                    <br>
                    <fieldset></fieldset>
                    <br>
                  </div>
                </div>
                <pre>_______________________________________________
Users mailing list
<a moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
              </blockquote>
              <br>
            </div>
          </blockquote>
        </div>
        <br>
        <br clear="all">
        <br>
        -- <br>
        <div dir="ltr">
          <div><span
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">"Efficiency
              is doing things right; effectiveness is doing the right
              things</span><span
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
                (Peter Drucker)</span>"<br>
            </span></div>
          <br>
          <div><span
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Miguel
              Oyarzo</span><br
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
            <span
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">DevOps
              &amp; VoIP Engineer</span><br
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
            <span
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Linux
              User: # 483188 - </span><font color="#888888" face="arial,
              sans-serif"><a moz-do-not-send="true"
                href="http://counter.li.org" target="_blank">counter.li.org</a></font><br
style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
            <span style="background-color:rgb(255,255,255)"><font
                color="#888888" face="arial, sans-serif"><a
                  moz-do-not-send="true"
                  href="http://au.linkedin.com/in/mikeaustralia"
                  target="_blank">http://au.linkedin.com/in/mikeaustralia</a> </font><br>
              <font color="#888888" face="arial, sans-serif">Melbourne,
                Australia</font></span>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
  </body>
</html>