- \n
- Paribus 365™<\/li>\n
- Microsoft Dynamics 365 CRM<\/li>\n
- Infor CRM (Saleslogix)<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/p>\n
Introduction<\/h2>\n
For the reviewers of Paribus 365™ Match Results having information columns that speed up the decision are important. The information columns displayed are controlled in the Data Set.<\/p>\n
As well as adding standard fields the information displayed can be enhanced further.<\/p>\n
Identifying Who Wrote the Most Recent History Record<\/h2>\n
It\u2019s often useful to know who wrote the last history record or sent the last email to a Contact or Account when trying to determine which record of a Match Group should be the surviving record into which the duplicates should be merged. To do this, you need to find the most recent History record and then extract the name of the User who was associated with that record.<\/p>\n
The process can be broken up into 3 logical elements.<\/p>\n
- \n
- Finding the associated History records for the Accounts on which you\u2019re matching<\/li>\n
- Identifying the most recent record<\/li>\n
- Displaying the User Name from the Userinfo table associated with the identified History record<\/li>\n<\/ul>\n
To include this information for the Paribus reviewer, a SQL statement can be included within the Information Columns definition to provide the USER Name. An example is below:<\/p>\n
(SELECT USERNAME FROM USERINFO WHERE USERID = (SELECT TOP 1 COMPLETEDUSER FROM HISTORY WHERE HISTORY.ACCOUNTID = ACCOUNT.ACCOUNTID ORDER BY COMPLETEDDATE DESC)) AS \u2018Last History User\u2019<\/p>\n
For example, it would be added as follows:<\/p>\n
![\"Paribus](\"https:\/\/www.qgate.co.uk\/knowledge\/wp-content\/uploads\/2015\/07\/figure-2.png\")
<\/a><\/p>\n