Merge Person functionality is not working on Integrated Systems
1. Select a company were duplicate people will be found. Click on the person to be merged.
2. Click on the Merge Person Button. The merge person panel appears
3. When clicking on the search for source person to be merged, no people are found.
If we look at the sql logs, it fires a query that says
SELECT TOP 51 Pers_PersonId, Pers_FullName,pers_phonecountrycode,pers_phoneareacode,pers_phonenumber
FROM vSearchListPerson WITH (NOLOCK)
WHERE (Pers_FullName LIKE N'%' ESCAPE '|' OR COALESCE(Pers_FullName, N'') = N'')
and pers_Deleted is Null and (Pers_CompanyID=28 AND (Pers_AccountID IS NULL)
AND (Pers_PersonID<>47)) order by Pers_FullName
It is taking Pers_AccountID as NULL that’s why it is showing no records.
If we remove AND (Pers_AccountID IS NULL) it will show the records
Occurs on most of the Murano integrated systems. Found in 7.3 SP3, 2017 R1.1 and will be fixed in 2017 R3