Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Querying Salesforce from QlikView Script

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?

1 Reply

Re: Querying Salesforce from QlikView Script

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

Community Browser