Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Salesforce SOQL/SQL Syntax (Join)

Hey there,

I am trying to join Salesforce tables using the Qlikview connector, however none of the options I tried work. Can anyone advice on the syntax needed to join tables (on a key). Both SQL and SOQL failed me.

For example, I would like to know the actual username of a case owner. So in SQL, this would kinda look like:

SELECT c.id, c.subject, u.name

FROM case c

JOIN user u on u.id = c.ownerId

SOQL:

SELECT id, subject, owner.name

FROM case

Also, I am unsure what functions I can use - according to the user guide, both SQL and SOQL are valid and were 'combined', however I was unable to format my createdDate using DATE_FORMAT(). Is there a definite list or should I mostly rely on SOQL functions?

0 Replies