"any dropdown" in Advanced Search

[zaska]

Hi there,

I have two custom fields ("Car 1" and "Car 2" for example) for module Contacts of type DropDown. They use one dropdown list (cars_dom). Now I want to make a field in advanced search called "Any Car" with the same dropdown and search the two db fields.

I'm looking at the wiki and tried with:

 'cars_all'=> array('query_type'=>'default','operator'=>'=','options'=>'cars_dom'), 
  

in SearchDefs.php but with no luck.
Any ideas?
Thanks

SugarCE 5.2.0e

[zaska]

Like a workaround:

 <?php
$searchdefs ['Contacts'] =
array (
  'layout' =>
  array (
    'advanced_search' =>
      'car_1' =>
      array (
        'width' => '10%',
        'label' => 'LBL_ANY_CAR',
        'default' => true,
        'name' => 'car_1',
        'displayParams' => array(
                'size' => '1',
        ),
      ),  

Then in SearchFields.php:

                 'car_1'=> array('query_type'=>'default','operator'=>'=','db_field'=>array('car_1','car_2')), 
  

[madhrishi]

Hi Zaska,

Great post and this is what i was looking for... Can you please explain more how to achieve this? I made the modifications in custom/module/my_module folder... With your steps i am not finding any field in the advanced search view... should i explicitly add a 'car_1' drop down? Pls let me know....

Actually in the search view, i get a blank field with Label : LBL_ANY_CAR

Thanks

[aprameya]

Many ppl ask this question... no one answers
Following threads raise the same question... but no solution...

http://www.sugarcrm.com/forums/showthread.php?t=6229
http://www.sugarcrm.com/forums/showt...ght=search+any
http://www.sugarcrm.com/forums/showt...ght=search+any
http://www.sugarcrm.com/forums/showt...ght=search+any
http://www.sugarcrm.com/forums/showt...ght=search+any

I have search the forums toooo much. Sugar team, kindly help.

[andopes]

Have a look at the Leads module metadata: modules/Leads/metadata.
File SearchFields.php:

         'address_state'=> array('query_type'=>'default','db_field'=>array('primary_address_state','alt_address_state')), 
  

Create a new array element for a virtual field where you will set the db fields to be searched.

File searchdefs.php:

                 array('name' => 'address_state', 'label' =>'LBL_STATE', 'type' => 'name'), 
  

Add this virtual field into searchdefs.php, Sugar will render it according to type (name) template.

The fiile searchdefs.php can be customized into custom/modules/Leads/metadata folder, but the SearchFields.php not, but you can create the file custom/modules/Leads/metadata/metafiles.php and set the path for the new SearchFields.php there. Have a look at the script modules/Contacts/metadata/metafiles.php

Regards

[madhrishi]

Thank You... That was some hope.... i managed to get a field in the search form... but it looks weird...

I did the following at sugarcrm/custom/modules/Contacts/metadata

sugarcrm/custom/modules/Contacts/metadata/Searchdefs.php

'car_c' => 
      array (
        'name' => 'car_c',
        'width' => '10%',
        'label' => 'LBL_THIS_CAR',
        'default' => true,
        'type' => 'enum',
        'options' => 'programlist_list',        
      ),

sugarcrm/custom/modules/Contacts/metadata/Searchfields.php

'car_c'=> array('query_type'=>'default','operator'=>'=','db_field'=>array('field1_c','field2_c')),

sugarcrm/custom/modules/Contacts/metadata/metafiles.php

$metafiles['Contacts'] = array(
	'searchfields'	  =>    'custom/modules/Contacts/metadata/SearchFields.php',
 );

This is what i got in the search form : Kindly help...

A enum with no values.....

[andopes]

You need to create the dropdown programlist_list throught Admin -> Studio -> Dropdown Editor and also create the translation for LBL_THIS_CAR into an extended language for Contacts.

Cheers

[madhrishi]

Hi Andopes,

Of course i created the drop down... field1_c and field2_c database fields are also instances of this dropdown ... Anything else that i am missing? Have i included the right contents in the files? Especially the metadata.php and Searchdefs.php ??

Thanks

[andopes]

At the search form sugar read the options from vardefs instead of from searchdefs.php, so you need to create the field in the extended vardefs as an non-db field:
custom/Extension/modules/Contacts/Ext/Vardefs/vardefs.ext.php

 $dictionary['Contact']['fields']['car_c'] = array(
            'name' => 'car_c',
            'vname' => 'LBL_THIS_CAR',
            'type' => 'enum',
            'options' => 'programlist_list',
            'len' => '100',
); 
  

Go to Admin -> Repair -> Rebuild Extensions

Cheers

[madhrishi]

Now i have the field displayed properly on the search form... But its failing to retrieve any records...
Below are the contents of the files :

custom/modules/Forse_Contactssearch/metadata/SearchFields.php

            'programname_c'=> array('query_type'=>'default','operator'=>'=','options'=>'program_list','db_field'=>array('prog1_c','prog2_c')),

custom/modules/Forse_Contactssearch/metadata/searchdefs.php

      'programname_c' => 
      array (
        'name' => 'programname_c',
        'width' => '10%',
        'label' => 'LBL_THIS_PROGRAM',
        'default' => true,
        'type' => 'enum',
        'options' => 'program_list',        
      ),

custom/modules/Forse_Contactssearch/metadata/metafiles.php

$module_name = 'Forse_Contactssearch';
 $metafiles[$module_name] = array(
	'searchfields'	  =>    'custom/modules/'. $module_name. '/metadata/SearchFields.php',
 );
?>

custom/Extension/modules/Forse_Contactssearch/Ext/Vardefs/vardefs.ext

<?php
$dictionary["Forse_Contactssearch"]["fields"]["programname_c"] = array( 
            'name' => 'programname_c', 
            'vname' => 'LBL_THIS_PROGRAM', 
            'type' => 'enum', 
            'options' => 'program_list',
            'source' => 'non-db',
            'len' => '100', 
);
?>