Coarse matching filter is throwing operations not allowed error in duplicate identity management

[Padmavathi]

Hi Team,

Admin > Global Configurations > Duplicate Identity Management, we are using the below query under Coarse Matching Filter's as per the document Configuring Intelligence (saviyntcloud.com)

((SOUNDEX(t1.FIRSTNAME)= SOUNDEX(t2.FIRSTNAME) and SOUNDEX(t1.LASTNAME)= SOUNDEX(t2.LASTNAME))) and t1.USERKEY <> t2.USERKEY

We are unable to save the configuration as we are getting the below error pop up.

Can anyone help us to solve the issue.

Thanks in advance!

Padmavathi

[sk]

@Padmavathi Looks like a bug or soundex function is not supported. Please open a ticket with support

[rushikeshvartak]

Please try 

SUBSTRING(t1.FIRSTNAME,1,4) = SUBSTRING(t2.FIRSTNAME,1,4) and SUBSTRING(t1.LASTNAME,1,4) = SUBSTRING(t2.LASTNAME,1,4) and t1.USERKEY <> t2.USERKEY