- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Where di you used "=TRUE"
I have the same problem.