Qlik Community

QlikView Connectors

Not applicable

Salesforce SOQL filter

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;BooleanAsS...

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

1 Solution

Accepted Solutions
Not applicable

Re: Salesforce SOQL filter

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...

1 Reply
Not applicable

Re: Salesforce SOQL filter

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...

Community Browser