What is filter logic with multiple conditions and depths?
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.
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?