We have a few rules that essentially look this this:
- Query 1: Fetch some data from MDA.
- Query 2: Fetch a lot of Data from SFDC.
- Left Merge from MDA to SFDC.
- Do something.
It would be great if there were an option to automatically stop the rule execution if nothing was retrieved in the first query. Today, if we get zero results from the MDA fetch, we still have to wait for the rule to make the much larger query to SFDC, which can sometimes take up to 10 minutes of compute time, only to end up with an empty dataset after the merge.