Community
Showing results for 
Search instead for 
Do you mean 
Reply

Advanced Search, Test Three Fields To Be Rejected

Accepted Solution Solved
Bronze Super Contributor
Posts: 1,662
Country: USA
Accepted Solution

Advanced Search, Test Three Fields To Be Rejected

I created an advanced lookup and it did not perform the way I expected.  Thought I understood Boolean, but maybe not.  Here's the lookup:

 

(TypeField NameOperatorValue)And/Or
 ContactLast ResultsStarts WithSelected For Project A And
 ContactE-MailContains DataNothing And
 ContactTime ZoneStarts WithCentral And
(Contacte-MailDoes Not ContainOptOut Or
 ContactID-Status 2Does Not ContainOptOut Or
 ContactID StatusDoes Not ContainOptOut)End

 

The above fails.

 

When I changed the last three rows to And, then the test worked.

 

In other words, do not select a contact if e-Mail doesn't contain "OptOut".  The same for ID-Status 2 and for ID-Status.  

 

Why does changing the last three to "End" ?

 

Many thanks

 

John Purdy
ACT! Premium V. 22.1.212.0 Update 4
HP ENVY 17m, 16GB, & Office 365, 32bit, 500GB SSD.
ACT CRM Advisor

Accepted Solutions
Solution
Accepted by topic author jnpurdy
‎03-04-2019 12:35 PM
Bronze Super Contributor
Posts: 1,662
Country: USA

Re: Advanced Search, Test Three Fields To Be Rejected

Yep, it's been at least 60 years since taking a class in Boolean logic.

 

Thank you.

John Purdy
ACT! Premium V. 22.1.212.0 Update 4
HP ENVY 17m, 16GB, & Office 365, 32bit, 500GB SSD.
ACT CRM Advisor

View solution in original post


All Replies
Platinum Elite Contributor
Posts: 6,867
Country: USA

Re: Advanced Search, Test Three Fields To Be Rejected

The issue was that you were chaining OR negative conditions. In other words the first does not contain statement included all that didn't meet that condition. the second did the same thing which meant that it likely included everything the first statement was intended to exclude. Remember that AND is the same as NOR.
Roy Laudenslager
Retired ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
Solution
Accepted by topic author jnpurdy
‎03-04-2019 12:35 PM
Bronze Super Contributor
Posts: 1,662
Country: USA

Re: Advanced Search, Test Three Fields To Be Rejected

Yep, it's been at least 60 years since taking a class in Boolean logic.

 

Thank you.

John Purdy
ACT! Premium V. 22.1.212.0 Update 4
HP ENVY 17m, 16GB, & Office 365, 32bit, 500GB SSD.
ACT CRM Advisor