What is filter logic with multiple conditions and depths?

882 Asked by ChrisEVANS in Salesforce , Asked on Aug 22, 2023

I have created a report which looks like the following:

Type = Minor Works AND
(Stage: 05 OR 06 AND Stage Age >= 5) OR (Stage: 07 AND Stage Age >= 10)

I have also created a filter:

1. Type equals “Minor Works.”

2. Stage equals “05 - Awaiting Scope.”

3. Stage equals “06 - Awaiting Quote”

4. Stage equals “07 - Awaiting Customer Agreement”

5. Stage Age (Days) greater or equal “5.”

6. Stage Age (Days) equals “10.”

But I am getting the comment that my filter needs to use parentheses around successive AND and OR expressions.

Answered by Dan Peters

you can use any line: To get rid of this comment and be able to get Salesforce filter logic you can use any line:

1. 1 AND (((2 OR 3) AND 5) OR (4 AND 6))

2. 1 AND ((2 OR (3 AND 5)) OR (4 AND 6))

22. How to solve the error limit exceeded?

Your Answer

Answers (2)

Palmer

BitLife game online offers endless life possibilities where success depends on the decisions you make.

2 Months

Satou

Every programming needs to be 100% reliable and algorithmic. A mistake can really affect the execution. Learn about various programming languages with this geometry dash lite website.

1 Year