Salesforce SOQL filter

Mon, 26 Jan 2026 21:26:37 GMT

Hi,

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

SalesforceConnectorMaster:

SELECT

Name,

IsWon,

FROM Opportunity

WHERE (Name like 'A%')

//AND (IsWon=1)

;

Opportunity:

LOAD Opportunity.Name,

Opportunity.IsWon

RESIDENT SalesforceConnectorMaster;

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:

AND (IsWon=1)

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

Ian

Re: Salesforce SOQL filter

Thu, 26 Feb 2015 09:27:27 GMT

Hi,

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,

http://www.salesforce.com/us/developer/docs/officetoolkit/index_Left.htm#StartTopic=Content%2Fsforce_api_calls_soql_select_dateformats.htm|SkinName=webhelp

Re: Salesforce SOQL filter

renato_cardim — Thu, 14 Sep 2023 19:50:05 GMT

Hi,

Where di you used "=TRUE"

I have the same problem.

topic Salesforce SOQL filter in QlikView

Salesforce SOQL filter

Re: Salesforce SOQL filter

Re: Salesforce SOQL filter