Filtering by "Assigned To" not working

[mrmmm]

I tagged this along to another thread but decided it would be better to post as a separate one (hopefully not against the rules).
In Advance Search for Opportunities I have a box "Assigned to" with a select button. When I click the select button, I get a window with all the users in the system and when I click on one, it gets entered into that box. However, whenever I click search I always get no results even though I have opportunities assigned to that user. I have tried manually entering user IDs, but also no results are returned.

In /usr/local/www/data-dist/sugarcrm/custom/modules/Opportunities/metadata/searchdefs.php i have the following:
'assigned_user_name' =>
array (
'label' => 'LBL_ASSIGNED_TO_NAME',
'width' => '10',
'name' => 'assigned_user_name',
)


Sugar: Open Ssource 5.0b

Thank you.

[Superman]

That is a Sugar bug.
Use this:

 array('name' => 'assigned_user_id', 'type' => 'enum', 'label' => 'LBL_ASSIGNED_TO', 'function' => array('name' => 'get_user_array', 'params' => array(false))) 
  

[mrmmm]

Farkhad,
Thanks for the tip. That did the job. The only difference is that now instead of a select button and a window where I can type, I have a multiselect box. Which is an improvement functionality-wise but just looks bad.

Thank you!
Maxim

[paulgig]

Hello,

ok, have you found a way to change, in the Opportunity list view, the "Assigned to ID" to display the actual name?

thanks.

P

[mrmmm]

If I am not mistaken you set that up in the Admin section. I don't have the system in front of me right now, but there is a setting that says "Display Full User Name instead of User ID".

[mipapage]

Thanks superman, this worked for me.