AnsweredAssumed Answered

Search "not in"

Question asked by mgagle on Feb 8, 2016

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?