AnsweredAssumed Answered

Combine Salesforce queries for OR filtering

Question asked by richard.brown@sunquestinfo.com on May 18, 2016
Latest reply on Jun 28, 2016 by richard.brown@sunquestinfo.com

We need an OR filter across multiple Salesforce objects. According to this and that posts, we need 2 SF Connectors for each half of the OR query, and then combine them into a single document stream.

 

What is the best way to do that? Do we start a process with a No Data start shape, then call a subprocess with the 2 SF Connectors as described in "Group Documents from Multiple Sources" in this post? Are there other approaches?

 

How do we eliminate duplicates in the resulting document stream?

 

Thanks for your suggestions.

Outcomes