Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error using salesforce connector with alpa numeric values in where clause

I am trying to pull data from salesforce.com using their connector, which is working fine. When i try to limit the amount of data getting pulled by specifying a record type id using a where clause, it errors out. The value of the record id contains alpha numeric values. i have tried with single quotes, double quotes and no quotes, each time it gives a different error. here is the where clause

Where (TaskRecordTypeID = '012400000009hCiAAI' OR '012400000009hBfAAI')

1 Reply
Not applicable
Author

You should try Where (TaskRecordTypeID in ('012400000009hCiAAI','012400000009hBfAAI'))