<div dir="ltr"><div class="gmail_default"><pre style="word-wrap:break-word"><font color="#000000" face="tahoma, sans-serif"><span style="white-space:pre-wrap">Please have look on this function </span></font><span style="color:rgb(0,0,0);font-family:tahoma,sans-serif;white-space:pre-wrap"><i style="font-weight:bold">getQueryByModuleField </i>in module model</span><font color="#000000" face="tahoma, sans-serif"><span style="white-space:pre-wrap">, You may have to add that if you are using custom module. That what i have done to customize PoupList in Some Module</span></font></pre>
</div><div class="gmail_default" style="font-family:tahoma,sans-serif;color:rgb(68,68,68)"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;color:rgb(68,68,68)"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;color:rgb(68,68,68)">
<a href="http://trac.vtiger.com/cgi-bin/trac.cgi/browser/vtigercrm/branches/6.0.0//modules/Accounts/models/Module.php#L47">http://trac.vtiger.com/cgi-bin/trac.cgi/browser/vtigercrm/branches/6.0.0//modules/Accounts/models/Module.php#L47</a><br>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 28 January 2014 05:10, Richard Hills <span dir="ltr"><<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>></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>Thanks Joe<br>
<br>
I can indeed render the correct popup list by navigating to the
url with the additional parameters
"search_key=ticketstatus&search_value=open". However this does
not stop the user from using the search box again to reset the
filter (this is not a problem for my implementation however I am
sure it will be for some). <br>
<br>
This also does not help with the current Ajax call being made by
uitype 10's which I would prefer users to be making use of over
the popup.<br>
<br>
I have had a quick look at the code now and see models/Record.php
function getSearchResult where I was able to add some
customisation (a specific query which sits within a specific
module if statement) to get the functionality I required. However
I believe that there needs to be a better way of doing this.<br>
<br>
I would love some feedback from the vtiger team as to wether this
can or can not be achieved within the module framework at this
stage. If not then I will settle for this core hack at least until
I find another reason I require the change and spend the time
looking for an ongoing extensible solution.<br>
<br>
Thanks<div><div class="h5"><br>
<br>
<br>
<br>
On 24/01/14 11:49, Joe Bordes wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">
<div>If you can get around the spanish,
this is how we did it in 5.x:<br>
<br>
<a href="http://crmevolutivo.com/doku.php/es:advancedsearch" target="_blank">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 type="cite">
<div>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 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-size:12.727272033691406px;font-family:arial,sans-serif">
<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:part2.06010102.00010700@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 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 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><font color="#888888"><br>
<br>
<br>
-- <br>
Richard Hills<br>
TechnologyWise Ltd, Tauranga, NZ<br>
<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a><br>
<a href="http://www.technologywise.co.nz" target="_blank">www.technologywise.co.nz</a><br>
ph: <a href="tel:%2B64%20%280%297%20571%201060" value="+6475711060" target="_blank">+64 (0)7 571
1060</a><br>
fax: <a href="tel:%2B64%20%280%297%20571%201061" value="+6475711061" target="_blank">+64 (0)7 571
1061</a><br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</font></span></blockquote>
</div>
<br>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
<br>
<pre cols="72">--
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>
<a href="http://www.technologywise.co.nz" target="_blank">www.technologywise.co.nz</a>
ph: <a href="tel:%2B64%20%280%297%20571%201060" value="+6475711060" target="_blank">+64 (0)7 571 1060</a>
fax: <a href="tel:%2B64%20%280%297%20571%201061" value="+6475711061" target="_blank">+64 (0)7 571 1061</a></pre>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
<br>
<pre cols="72">--
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
<a href="mailto:richard@tw.co.nz" target="_blank">richard@tw.co.nz</a>
<a href="http://www.technologywise.co.nz" target="_blank">www.technologywise.co.nz</a>
ph: <a href="tel:%2B64%20%280%297%20571%201060" value="+6475711060" target="_blank">+64 (0)7 571 1060</a>
fax: <a href="tel:%2B64%20%280%297%20571%201061" value="+6475711061" target="_blank">+64 (0)7 571 1061</a></pre>
</div></div></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Muhammed Abdul Salim<br>
</div>