cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple Cross-Field Matchings?

MDonovan
Explorer

Hey there -

I am trying to figure out a way to use cross-field matching to look for both the phone number and emails fields across multiple different fields in the same search query, so look across two different phone fields as well as two different email fields, is there any way to acheive this? Thanks in advance. 

1 ACCEPTED SOLUTION

Pugs_Validity
Validity Team Member
Validity Team Member

Hey @MDonovan, we actually learned a neat trick from another customer a while back during our Office Hours to achieve this. You can match across up to five fields when using cross-field matching. So while you may only be interested in looking for matches in one alternative column in each instance, putting all four of your desired search fields in the same search query should return the results you are looking for. Let us know if you have any additional questions. 

Pugs_Validity_0-1707770532203.png

 

View solution in original post

1 REPLY 1

Pugs_Validity
Validity Team Member
Validity Team Member

Hey @MDonovan, we actually learned a neat trick from another customer a while back during our Office Hours to achieve this. You can match across up to five fields when using cross-field matching. So while you may only be interested in looking for matches in one alternative column in each instance, putting all four of your desired search fields in the same search query should return the results you are looking for. Let us know if you have any additional questions. 

Pugs_Validity_0-1707770532203.png