Search field doesn't work. Please help

[dekleinemedia]

Hi, I have the following issue of which i hope can help me with;

When i create a new Project and I assign an user to it, i want to search on 'Assigned to' field into ProjectList.
But when I give in the assigned user it seems to find none related project because it gives me a blank List.
See screenshot.
Here are my custom files related to this issue; They are stored in custom\modules\Project\metadata

editviewdefs

0 =>
array (
'name' => 'assigned_user_name',
'label' => 'LBL_ASSIGNED_USER_NAME',
),

listviewdefs

'ASSIGNED_USER_NAME' =>
array (
'width' => '10%',
'label' => 'LBL_LIST_ASSIGNED_USER_ID',
'default' => true,
),

Searchdefs

'assigned_user_name' =>
array (
'width' => '10%',
'label' => 'LBL_ASSIGNED_USER_NAME',
'default' => true,
'name' => 'assigned_user_name',
),

Someone knows what is wrong? Please help. Thanks in advance!

[crmbalah]

HI
assign to as relate field. the relate field's are store only the relate - id.
1.check you "list query" form sugar log file.
2. try to custom the you list query.

[andopes]

Replace the assigned_user_name field on searchdefs.php by this one:

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

Cheers

[dekleinemedia]

Replace the assigned_user_name field on searchdefs.php by this one:

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

Cheers

Thank you André, it works!
I appreciate

[midjinou]

I have the same problem almost. I created a field "reseller" of type 'related' in the accounts module. The search with account "name" no longer works. Research is done with the "reseller". Any idea?

[midjinou]

I have the same problem almost. I created a field "reseller" of type 'related' in the accounts module. The search with account "name" no longer works. Research is done with the "reseller". Any idea?