I'm trying to implement the SOQL shown below.
I have not been sucessful in implementing the bold part in the bottom. Inserting a static value in the Connector Parameters is not a possibility since single quotes are inserted.
- Is it possible to insert custom SOQL, or is there a different solution in which I can construct the SOQL below?
- In the logs, is it possible to see the SOQL with the parameters inserted?
WHERE ASF3__Aria_Bill_Thru_Date__c > 2010-01-01 AND ASF3__Aria_Bill_Thru_Date__c < 2019-01-05
and ASF3__Client_Plan__c IN (
WHERE ASF3__Plan_Supp_Field_Name__c='ProductType' AND
I will greatly appreciate any help.