Set Coarse Matching Filter Algorithm for handling NULL value in Duplicate Identity Management

[sdey_2023]

We are using the following algortihm in coarse match :

(t1.preferedfirstname=t2.preferedfirstname or (t1.preferedfirstname is null and t2.preferedfirstname is null)) and (t1.lastname=t2.lastname or (t1.lastname is null and t2.lastname is null)) and t1.customproperty3=t2.customproperty3 and t1.USERKEY <> t2.USERKEY and (t1.customproperty65 NOT LIKE 'FILTER' OR t1.customproperty65 IS NULL) AND (t2.customproperty65 NOT LIKE 'FILTER' OR t2.customproperty65 IS NULL)

We want to check if preferedfirstname , lastname is null or same for both the users, but we are not getting the users flagged in the Duplicate Identity dashboard if both have same FN and LN is null or viceversa with same CP3. 

Can you please advise

[rushikeshvartak]

Any errors in logs

[sdey_2023]

Hi Rushikesh, no error found in logs, when we are trying to run the query in Data Analyzer it is returning correct result but the users are not getting flagged in the M&M queue, we have timeout set as 239 in the Global config, can it be possible that it is unable to query in the mentioned time, what should be the more efficient version of the query then? Thanks.

[rushikeshvartak]

Share logs