AnsweredAssumed Answered

Salesforce Connector Operation: Construction of Complex SOQL

Question asked by BjarkeHansen4421 on Aug 13, 2015
Latest reply on Apr 19, 2017 by mani.sethuraman333464

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?

SELECT Id
FROM ASF3__Account_Plan__c
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 (
    SELECT ASF3__Client_Plan__c
    FROM ASF3__Client_Plan_Supplemental_Fields_Mapping__c
    WHERE ASF3__Plan_Supp_Field_Name__c='ProductType' AND
          ASF3__Plan_Supp_Field_Value__c='Age-Related'

)

 

I will greatly appreciate any help.

Outcomes