1 Reply Latest reply: Feb 26, 2015 4:27 AM by Ian Williams RSS

    Salesforce SOQL filter

    Ian Williams

      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