Hi,
We have a custom dropdown on the Leads form called "Business Sub Type". By default "--none---" is selected.
when we search for a person "John Sim:, he does not come up in the serach results as his business type is set to "Finance". This should not work that way.
If "--none" is selected ALL records should show (for all Business Subtypes). Here is my understanding how existing Splendid Search logic for dropdowns works:
"--None--" is not in the custom filed, Means it is assigned by the system
"--None-"- means null
So it is adding "WHERE business_type-Sub is NULL"
In the search form, define the listbox as a multi-selection. When you do this, SplendidCRM will only filter on the listbox field if a value is selected.
There are examples of this in the Accounts.SearchAdvanced layout.