Custom query in Team Popup

[dskanth]

Hai, i need a custom query to show the data in the popup that appears when we click on the Team Select button.
I want to restrict the logged in user to select only 1 team (same team), when he is creating the Lead.

By default, all the teams are shown in the popup. But i want to show the Team of the current user in the popup.
Where can i find the query to get the Teams and modify it to show only the team of the current user ?
Please suggest any solutions.

[eggsurplus]

I'm not sure if this is the case here but sometimes you can simply change their roles permissions so that List is set to Team only so that the popup only shows the 1 team that they are a member of.

[dskanth]

Ok, so we need to set the roles preferences to List as Owner? I want the popup list to show only 1 team (Team of logged in user).
Can we edit the roles of parent team admin and the child team members, such that their "List" is set to Owner ? Is this what you are saying?

[dskanth]

I have edited the role of team admin user, and made the permission "List" to Owner, repaired the Leads module. But when i logged as team admin user and tried to create a Lead, i still see all the teams in the popup that appears. What do i need to do, to show only the team of Admin in the popup ?
Please advice...

[dskanth]

Can we do something in the file ... cache/modules/Leads/EditView.tpl ?
It calls the open_popup() function when we click on the Select button. The function is present in the file: ....include/javascript/sugar_grp1.js
Can we change the "initial_filter" parameter of this function to something like a query ?
I have no idea. Can someone throw a light here ?

[dskanth]

Finally i could get some solution. I modified the _get_where_clause method of the file CETeamsPopupSmarty.php in the CETeams folder of the modules folder. Check http://www.sugarcrm.com/forums/showt...ght=popup+data

[ivolator]

In the latest releases you can set the CETeams behavior to not allow users to see other teams except their own.