Searching many fields with one field

[aprameya]

Hi,

I have 5 instances of same drop down list. Like

Working Field 1 : 
              Medicine
              Architect
              Engineer
              Sales
              Other

Working Field 2 : 
              Medicine
              Architect
              Engineer
              Sales
              Other

...

Working Field 5 : 
              Medicine
              Architect
              Engineer
              Sales
              Other

Now, I want to search for a person, who is an Engineer.... Problem is that i have to add all 5 Drop downs to the search layout and everytime look for 'engineer' in all 5 dropdowns to get the record....

Is there a way where we can have just one dropdown field at the search layout which will search all the 5 dropdowns and get the result....

Something similar to 'Any Phone'...'Any Address' ... search in advanced search view....

Thank You,
Aprameya

[andopes]

Hi Aprameya

Have a look at the file modules/Contacts/metadata/SearchFields.php.
The field address_street definition tells sugar to look at two different fields.

         'address_street'=> array('query_type'=>'default','db_field'=>array('primary_address_street','alt_address_street')), 
  

You need to do the same for your 5 fields.

Cheers

[aprameya]

Hi Andopes,

Thanks for your reply.... I am not clear how to do this... In contacts module, i dont see "address_street" field definition... but this suddenly appears in search alone.... In my case, i have 5 dropdowns.....
So should i be defining a new dropdown field and add it to advanced search?

Lets call it 'AnyWorkingField'

and add this line in modules/contacts/metadata/SearchFields.php

'AnyWorkingField'=> array('query_type'=>'default','db_field'=>array('WorkingField1','WorkingField2','WorkingField3','WorkingField4','WorkingField5')),

But this is not working....

What should i do?

[aprameya]

Hi,

Can someone help me with this?

Thank You.