I am trying to get my lookup query for Date of Birth and Social Security number to work and am receiving an error. If I write these queries individually (as their own distinct lookup) they work fine, but when I combine them it is throwing me this error despite the fact that the query does run and produces results. Can someone help me format this correctly for Salesforce and help me understand what I did incorrectly?
select IntPS__Date_Of_Birth__c, IntPS__Social_Security_Number__c, Plan_Member_SFID__c from IntPS__Patient__c where IntPS__Date_Of_Birth__c = {{data.PrimaryMembersDateOfBirth}} and IntPS__Social_Security_Number__c = '{{data.PrimarySSN}}'
The error message states that r_SSN is passed as a plain string. Would you please remove the filters and add fresh ones with the same configuration? Verify that the settings are being set straight from the fields list. It's not reproducible for us. To understand better, Could you please tell me if you set the "Value" earlier? and later changed to "fields".