Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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'))