<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">If you can get around the spanish, this
      is how we did it in 5.x:<br>
      <br>
      <a class="moz-txt-link-freetext" href="http://crmevolutivo.com/doku.php/es:advancedsearch">http://crmevolutivo.com/doku.php/es:advancedsearch</a><br>
      <br>
      In case that helps.<br>
      Joe<br>
      TSolucio<br>
      <br>
      <br>
      El 23/01/14 23:43, Richard Hills escribió:<br>
    </div>
    <blockquote cite="mid:52E19B16.2070906@tw.co.nz" type="cite">
      <meta content="text/html; charset=ISO-8859-1"
        http-equiv="Content-Type">
      <div class="moz-cite-prefix">Thanks Jonathan<br>
        <br>
        I see a getListQuery in the assets module still so it seems
        likely this is still the correct method.<br>
        <br>
        I will give it a go and confirm.<br>
        <br>
        <br>
        On 24/01/14 11:33, Jonathan Sardo wrote:<br>
      </div>
      <blockquote
cite="mid:CAKDtaCbe-3MU7mNXvKwCNQM2kB7HvmStunhgLfQ1vPMP_gWs+g@mail.gmail.com"
        type="cite">
        <div dir="ltr">Hello,
          <div><br>
          </div>
          <div>I don't know exactly with Vtiger 6, but with Vtiger 5.4
            you have to edit the function getListQuery() in your file
            /modules/ModuleName/ModuleName.php</div>
          <div>There you can look at URL parameters ($_REQUEST) to know
            the source module (eg. Filter records with status 'closed'
            only if the source module is Project) and you can custom the
            SQL query as you want.</div>
          <div class="gmail_extra"><br clear="all">
            <div>
              <div dir="ltr">
                <div
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.727272033691406px;background-color:rgb(255,255,255)">
                  <div>Regards,<br>
                  </div>
                  <div><br>
                  </div>
                  <div>
                    <div><font color="#666666">Jonathan SARDO</font></div>
                    <div style="color:rgb(136,136,136)"><img
                        src="cid:part1.03050703.02020606@tsolucio.com"
                        alt="Images intégrées 5"><br>
                    </div>
                    <div style="color:rgb(136,136,136)"><span
                        style="color:rgb(0,0,0);font-family:arial;font-size:small">Tél. <a
                          moz-do-not-send="true" value="+33699455047"
                          style="color:rgb(17,85,204)">06 99 45 50 47</a></span></div>
                  </div>
                </div>
              </div>
            </div>
            <br>
            <br>
            <div class="gmail_quote">2014/1/23 Richard Hills <span
                dir="ltr"><<a moz-do-not-send="true"
                  href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>></span><br>
              <blockquote class="gmail_quote" style="margin:0 0 0
                .8ex;border-left:1px #ccc solid;padding-left:1ex"> I
                have a custom module using a uitype 10 relation field.<br>
                <br>
                I want to restrict this fields view of the ticket module
                so that it will only show tickets with a certain status
                (as example).<br>
                <br>
                Can anyone tell me the method with which this can be
                handled?<br>
                <br>
                Thanks<span class="HOEnZb"><font color="#888888"><br>
                    <br>
                    <br>
                    -- <br>
                    Richard Hills<br>
                    TechnologyWise Ltd, Tauranga, NZ<br>
                    <a moz-do-not-send="true"
                      href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a><br>
                    <a moz-do-not-send="true"
                      href="http://www.technologywise.co.nz"
                      target="_blank">www.technologywise.co.nz</a><br>
                    ph: <a moz-do-not-send="true"
                      href="tel:%2B64%20%280%297%20571%201060"
                      value="+6475711060" target="_blank">+64 (0)7 571
                      1060</a><br>
                    fax: <a moz-do-not-send="true"
                      href="tel:%2B64%20%280%297%20571%201061"
                      value="+6475711061" target="_blank">+64 (0)7 571
                      1061</a><br>
                    <br>
                    _______________________________________________<br>
                    <a moz-do-not-send="true"
                      href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
                  </font></span></blockquote>
            </div>
            <br>
          </div>
        </div>
        <br>
        <fieldset class="mimeAttachmentHeader"></fieldset>
        <br>
        <pre wrap="">_______________________________________________
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
      </blockquote>
      <br>
      <br>
      <pre class="moz-signature" cols="72">-- 
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:richard@tw.co.nz">richard@tw.co.nz</a>
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="http://www.technologywise.co.nz">www.technologywise.co.nz</a>
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061</pre>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
    </blockquote>
    <br>
  </body>
</html>