Community
Showing results for 
Search instead for 
Do you mean 
Reply

Advanced search - scratching head!

Tuned Listener
Posts: 77
Country: United States

Advanced search - scratching head!

I have created the following:

 

Contacts - Import Field - Contains "value" - or

Contacts - User 13 - Contains "value" - and

Contacts - Company - Does Not Contains "value" - and

Contacts - Company - Contains Data - and

Contacts - DOC - Equals To - False - end

 

But -- I still get contacts where company is blank - and DOC where it is true.

 

What is the logic in creating such searches?

Platinum Elite Contributor
Posts: 6,663
Country: USA

Re: Advanced search - scratching head!

Without parenthesis to show grouping and resolution precedence, what you provided makes no sense. 
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Advanced search - scratching head!

The "or" that you placed after the first statement means that if Import Field contains the "value", then it won't matter if the rest of the statements are true or not. If you want results where all conditions are met, then you would need to use "and" after the first statement.

 

If you want to treat the last four statements as one condition, then place an open parentheses before the User 13 statement and a closed parentheses after the DOC statement.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.