Qlik Community

QlikView Connectors

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Error using salesforce connector with alpa numeric values in where clause

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