Hello there! I'm hoping for a little help on the "Advanced Search" function.
This is in regards to the Contract module, but could be used everywhere. This search includes several Multiple Choice fields, and I want the user to be able to search *only* the selected fields. The SugarCRM default is to provide results where X is true AND other fields are true. I want to be able to search where X is true and ONLY X is true.
Basically, I want to be able to search for an instance where only one (or two, or however many are selected) of the multiple choice fields has been selected.
Is this possible?