Search multiple in same field

[kennethgeeslin]

I am wondering if it is possible to create a custom search wherein i can select multiple states. For example i want to do a search on all leads that are in a certain lead status that are in NY NJ and CT? Any ideas?

[andopes]

Hi kenneth

Which version are you using?
In SugarCRM 5.1 the status in Leads Advanced Search Form is displayed as a multi select field, so you can select as values as you want.

Cheers

[kennethgeeslin]

I am using 5.1. In the advanced search form I want to be able to select multiple states. It is not a multiselect dropdown.

[andopes]

Hi kenneth

That is so weird.
I'm using a SugarCRM CE 5.1 and all enum fields (dropdown) are displayed as a multi select field in the Advanced Search.
Can you attach the content of the files modules/Leads/vardefs.php, modules/Leads/metadata/searchdefs.php, modules/Leads/metadata/SearchFields.php.
If these last two files exist into custom/modules/Leads/metadata then attach them.
Which is your php version?

Cheers

[kennethgeeslin]

PHP is 5.2.6
I zipped all files and attached. Thanks for your help.

[andopes]

Hi kenneth

I updated my files with the yours and the layout of the Leads Search Form display the status as a multi select field.
This means it is not a metadata issue, perhaps it is a cache issue.
Try to run the Quick Repair and Rebuild from Admin -> Repair
Did you upgrade your Sugar from another version?

Cheers

[kennethgeeslin]

I upgrade from 5.0.f

[andopes]

Hi kenneth

All dropdown fields are displayed as dropdown in the Search Form, instead of multi select or only that one?
Zip the folder include/SugarFields/Fields/Enum and attach the file in your next post.

Cheers

[kennethgeeslin]

Actually i am speaking of fields that are not dropdown or multiselect ( i.e. City or state) that is what i want to be able to choose more than one.

[andopes]

Hi kenneth

So it is not necessary to analyze the Enum field.
You want to render non enum and non multienum fields as a multienum in the Search Form.
Is that right?

It yes then it requires some programming.
For each non enum field you want to render as a multienum field in Search Form you need to define a function which will return the html options to insert into select field.
You need to edit the searchdefs.php of the modules to specify which function must be invoked to get the field content.

Let me know if you need additional help.

Cheers