Salesforce -Bind Variable Error

[daveguderian]

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}}'

[daveguderian]

Additionally, here are my result mappings.

[dhilips]

Hi Dave,

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".

[daveguderian]

Thank you Dhilip. I did have it set from the "Value" because if I select "Field" it is not letting me save it for some reason.

[daveguderian]

Update: I am able to add 1 criteria and save, but adding the second does not allow me to save still.

[dhilips]

@daveguderian Can you please share what error you're facing while saving with two filters?

[daveguderian]

@dhilips - I just figured out why it was doing that and was able to get it to save.

Does this look correct based on the filters:

((IntPS__Social_Security_Number__c = {{{string r_SSN}}}) AND (IntPS__Date_Of_Birth__c = {{{date r_DOB}}}))

[dhilips]

@daveguderian Is above filter expression solved your issue?