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?

 

Thanks!

Mike

Outcomes