โ08-25-2020 07:29 PM
Hi Good Day,
I was designing an automation pipeline which brings down the manual effort . The pipeline is about to be completed but I encounter some difficulties while parsing the fileds in the SOQL snap . I get the two fields $Start_Date and $End_Date from the source and I try to use them in the snap . I could include only one condition successfully but when I try including an additional condition parsing error occurs . I have attached the screenshot for the reference . Also it could be useful if we have a guiding document on how to handle such scenerios if multiple conditions occur.
My Query:
โSELECT Additional_Specialties__c,External_ID_vod__c,Id,LastModifiedDate,Specialty_1_vod__c FROM Account WHERE IsPersonAccount=True and Additional_Specialties__c!=null and LastModifiedDate >=โ+$Start_Date" and LastModifiedDate <="+$End_Date------Failed to parse
โSELECT Additional_Specialties__c,External_ID_vod__c,Id,LastModifiedDate,Specialty_1_vod__c FROM Account WHERE IsPersonAccount=True and Additional_Specialties__c!=null and LastModifiedDate >=โ+$Start_Date ------Worked successfully
โ08-26-2020 12:14 AM
Hi @Harsha3,
From what I can see from your screenshot, my guess is youโre missing a plus sign after $Start_Date.
Cheers,
Dimitri
โ08-26-2020 12:47 AM
Thanks @dimitri.hristovski so much