Re: Use variable in the WHERE clause of Salesforce Connector v13.1
Have you encounter an error when fetching data from CaseHistory from Salesforce? I get an error with the SQL below.
Unable to get column information for the fields that are used in the query. Please make sure you have only one SELECT statement in a query editor. Description: Relationship queries with polymorphic key (keywords TYPEOF, Owner, Who and What) are not supported by the connector.
where CreatedDate >= 2009-01-01T00:00:00.000Z and CreatedDate <= 2009-02-01T00:00:00.000Z and Field ='Owner';