Project - Search Facility

[matt.stannard]

Hi there,

We have our SugarCRM installation and I can do a search for projects using keywords and its fine, but if I use the Assigned User field I get no results despite projects being assinged to a user.

How can I find what is going wrong?

Many thanks

M

[davidboris]

Hi,

I confirmed by printing the query and seems it is wrong in Sugar.

In your project's searchdefs.php there will be a code like

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

Comment it and add the following

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

[davidboris]

Hi,

To keep the item selected add following code to your projects SearchFields.php

 'assigned_user_id'=> array('query_type'=>'default'),