I have a Customer object with many linked Issues objects, and I want to create a Foundry Rule that checks several conditions of the linked issues. My example data looks like 1 row of customer data and 4 rows of issues data. I’d like to check:
- does the Customer have at least 3 issues?
- are the 3 issues on our high priority list of Issue Types A, B, C, D, and E?
- for each high priority issue types, has the customer tried to resolve it at least 2 times?
Any guidance on how to setup this up? Does it need to be split into multiple rules?