[Vtigercrm-developers] Vtiger 6 - UIType 10 - Additional filters

[Richard Hills]

Thanks Joe

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).

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.

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.

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.

Thanks



On 24/01/14 11:49, Joe Bordes wrote:
> If you can get around the spanish, this is how we did it in 5.x:
>
> http://crmevolutivo.com/doku.php/es:advancedsearch
>
> In case that helps.
> Joe
> TSolucio
>
>
> El 23/01/14 23:43, Richard Hills escribió:
>> Thanks Jonathan
>>
>> I see a getListQuery in the assets module still so it seems likely 
>> this is still the correct method.
>>
>> I will give it a go and confirm.
>>
>>
>> On 24/01/14 11:33, Jonathan Sardo wrote:
>>> Hello,
>>>
>>> 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
>>> 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.
>>>
>>> Regards,
>>>
>>> Jonathan SARDO
>>> Images intégrées 5
>>> Tél. 06 99 45 50 47
>>>
>>>
>>> 2014/1/23 Richard Hills <richard at tw.co.nz <mailto:richard at tw.co.nz>>
>>>
>>>     I have a custom module using a uitype 10 relation field.
>>>
>>>     I want to restrict this fields view of the ticket module so that
>>>     it will only show tickets with a certain status (as example).
>>>
>>>     Can anyone tell me the method with which this can be handled?
>>>
>>>     Thanks
>>>
>>>
>>>     -- 
>>>     Richard Hills
>>>     TechnologyWise Ltd, Tauranga, NZ
>>>     richard at tw.co.nz <mailto:richard at tw.co.nz>
>>>     www.technologywise.co.nz <http://www.technologywise.co.nz>
>>>     ph: +64 (0)7 571 1060 <tel:%2B64%20%280%297%20571%201060>
>>>     fax: +64 (0)7 571 1061 <tel:%2B64%20%280%297%20571%201061>
>>>
>>>     _______________________________________________
>>>     http://www.vtiger.com/
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>
>>
>> -- 
>> Richard Hills
>> TechnologyWise Ltd, Tauranga, NZ
>> richard at tw.co.nz
>> www.technologywise.co.nz
>> ph: +64 (0)7 571 1060
>> fax: +64 (0)7 571 1061
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>
>
>
> _______________________________________________
> http://www.vtiger.com/


-- 
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
richard at tw.co.nz
www.technologywise.co.nz
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140128/6c6a7207/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 4223 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140128/6c6a7207/attachment.png>