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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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'))