We need data selection rules in our new Salesforce connector. Salesforce has “implied” relationships between e.g. quote line and quote header, and this opens up for a variation to our traditional data selection rule logic. Example…
Assume the quote header table contains a country field. Our traditional data selection rule logic allows us to filter this table, e.g.:
Country IN (‘AU’,’NZ’).
The quote line table does not contain a country field but it’s still possible in the TX REST API to filter the quote LINE table using a quote HEADER filter. In the TX REST API, such a query would look like this:
SELECT+Id,Name,CurrencyIsoCode+FROM+QuoteLine+WHERE+Quote.Country+IN+('AU','NZ')
We select lines from the QuoteLine table based on a filter referring to the Quote (parent) table, and then Salesforce does the rest.
