Community
Showing results for 
Search instead for 
Do you mean 
Reply

Opportunity Advanced Query Not Working

Accepted Solution Solved
Copper Contributor
Posts: 126
Country: USA
Accepted Solution

Opportunity Advanced Query Not Working

My advanced query on Opportunities is not working.  Here's what I have: 

 

type:  Opportunities

Field Name:  Opportunity Name

Operator:  Starts With

Value:  FQ

AND

 

type:  Opportunities

Field Name:  FQ Status

Operator:  Does Not Contain

Value:  Lost

OR

 

type:  Opportunities

Field Name:  FQ Status

Operator:  Does Not Contain

Value:  Closed

END

 

This query results in ALL Opportunities being displayed.  Can someone help? 

 


Accepted Solutions
Solution
Accepted by topic author Jillian Trish
‎09-25-2015 03:20 AM
Copper Contributor
Posts: 126
Country: USA

Re: Opportunity Advanced Query Not Working

That was it.  Thank you.

View solution in original post


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

Re: Opportunity Advanced Query Not Working

As you listed it it's working correct. You didn't specify how you are grouping with parathensis.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Solution
Accepted by topic author Jillian Trish
‎09-25-2015 03:20 AM
Copper Contributor
Posts: 126
Country: USA

Re: Opportunity Advanced Query Not Working

That was it.  Thank you.