Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am in the midst of a POC and need to prove that I can combine data from Salesforce with data from other sources. I've been successfuly, but now want to put a Salesforce SOQL query into the script, including relationships. I have a query that I can execute outside of QlikView, but get a syntax error inside of QlikView. Here it is:
SELECT Name, (SELECT Name FROM Agreements__r), (SELECT Name FROM Agreement_Products__r)
FROM Account
WHERE RecordTypeID = '01230000000t5SFAAY'
LIMIT 100
Thoughts?
the select (SELECT Name FROM Agreements__r) returns more than one row so
1) which name must be extracted from Agreements__r?
2) use aliases that is (SELECT Name FROM Agreements__r) as alias01
hope it helps