employees in assigned_user_id missing

[johnnyo]

in advanced search the field assigned_user_id is empty - no emplyees listed, And i tlooks like a text field rather than a dropdown field now. I've made no changes. Any ideas?????????
Thanks
5.0

[HolmesA]

Hi

Sugar 5.0 doesn't have any 'assigned_user_id' field in the 'Employees' module by default.

What module are you speaking about?

[johnnyo]

Thanks HolmesA
I could swear at one point there was a user_assigned_id dropdown in advanced search for several modules.
This would allow to search records by using my own employees names (userid's)
What I see now is an Assigned User field with no dropdown for my employees names to search records with.
No matter what I type in this field the search results are empty.

[HolmesA]

Hi

Can you point us to exact module in which you spotted this issue?
I have checked several modules when 'user_assigned_id' field exists and found out that everywhere a multiselect box is used for this field in advanced search.

[johnnyo]

Thanks HolmesA
I've enclosed a shot of my Accounts advanced search screen.
You'll see their are no users in the "assigned to" dropdown to pick from. These users are also missing in Contacts and Opportunities.
But users do show up in my "leads" - this is the only module I haven't added any custom fields to
I have also enclose3d a shot of Leads advanced Search

[HolmesA]

Hi

I was able to reproduce your situation. It seems that this is a Studio bug.

The following solution helps me to solve it:

1. In the '\custom\modules\Accounts\metadata\searchdefs.php' file change:

         'assigned_user_id' => 
        array (
          'label' => 'LBL_ASSIGNED_TO_ID',
          'width' => '10',
          'name' => 'assigned_user_id',
        ), 
  

to:

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

2. Delete the '\cache\modules\Accounts\SearchForm_advanced_searc h.tpl' file.

The same you should perform for the Contacts and Opportunities modules.

[johnnyo]

Your fix worked perfectly.
Thank you so much for your time, i appreciate it.
J