Modifing Sql query for Contact popup

[prajeesh]

Hi

I added a custom relate field 'primary contact' in the EditView of opportunities. This relate field will popup all the contacts in the system. But I would like to get only the contacts which are associated with the selected 'Account Name' in the same screen. I want to change the sql query so that contacts are shown based on this condition. Please guide me.

Thanks,
Prajeesh

[mvngti]

In short, what you are trying to do can not be done standard in SugarCRM. There is not simple way to alter the query run by the popup windows and there is no logic hook that fires under those conditions.

You best bet is to add some code to the bottom of the popupdefs.php for that module and then make the file immutable so sugar can not overwrite it.

M

[mvngti]

If you look at the teams_logic.php file of my CETeams module, there is a method limit_list_access that does something similar based on teams.

You can limit the list by setting some values into $_REQUEST that will then get included in the query.

M