I'm tyrin got use the salesforce connector in Qlik Senes to pull data out of a few salesfoce tables using the Bulk API.
Everything is working fine, but I'm trying to add a "where" to the select statement to limit the data set by a date. I seem to be messing up the syntax, so the load is erroring.
Does anyone know the right way to specify the statement with a date so it will work?
Example:
LOAD Id as [Case_c],
IsDeleted as [IsDeleted_Case],
CaseNumber,
...
CreatedDate as [CreatedDate_Case],
ClosedDate as [ClosedDate_Case];
SELECT Id,
IsDeleted,
CaseNumber,
...
CreatedDate,
ClosedDate
FROM Case
WHERE CreatedDate > 2016-01-01 00:00:00
;
