<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<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.03030905.07040104@tw.co.nz"
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 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 class="moz-txt-link-abbreviated" href="mailto:richard@tw.co.nz">richard@tw.co.nz</a>
<a 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>
</body>
</html>