What is filter logic with multiple conditions and depths?

386 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

Answer (1)

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.

2 Months