I'm very new to both Qlikview and Salesforce and I'm just messing around with the Salesforce connector. I am using v12 (QvSalesForceConnector.exe 64) and the Salesforce API v33.
My connection is fine and validates OK to the Test sandox site
CUSTOM CONNECT TO "Provider=QvSalesforceConnector.exe;BatchSize=2000;UseBulkAPI=false;Url=https://test.salesforce.com/services/Soap/u/33.0;QueryMode=QueryAll;ConvertSqlDates=False;BooleanAsStrings=False;ConvertToLocalTime=False;XUserId=;XPassword=;
I have a simple LOAD Script
WHERE (Name like 'A%')
DROP Table SalesforceConnectorMaster;
The script above works fine, however when I try to filter on the IsWon field then I get the following error
Error: QVX_UNKNOWN_ERROR: INVALID_FIELD:
Now I saw some documentation that implies that the Filter may not be enabled on every field but when I look at Opportunity on the salesforce api documentatio it implies that it is available for filter.
Any ideas? Thanks in advance
I actually solved this and so thought I'd share the answer. I found this on the Salesforce documentation site, and in SOQL you have to use =TRUE,