3 Merge Request Notification and Duplicate Score Visibility Shared by Tony Visconti, College Church one year ago 13.5 Administration / Finance Intermediate What This recipe will show you how toSetup a workflow to email a notification when there are merge requests waiting to be processedSetup a schedule job to run this workflow on a recurring basis.Add Duplicate Score Visibility on the Merge People PageWhyThere is currently no notification sent out when someone submits a merge requestThe SQL tables used to store merge requests are slightly obscureWe we are processing a duplicate request from another staff member we need to verify the duplicate is legitimate. There is not information on the duplicate merge screen to see what fields match. There is a wealth of information we could show accessible in the PersonDuplicate including the match confidence score and info on what fields match.HowSetup a workflow to email a notification when there are merge requests waiting to be processedStart by creating a new workflow with the name Merge Request Email Notification under the Data Integrity CategorySet a description of "Send a simple email with a link to the merge request queue and the open merge request count"Uncheck Automatically Persisted. That won't be necessary for this simple workflow.Add a workflow attribute called "mergeRequestCount" of type integer with this description "The count of merge requests waiting to be processed based querying the EntitySetItem table"Within the Start Activity we are going to add two actionsSet Open Merge Request Count Conditionally send an email if the count is > 0.Set Open Merge Request Count ActionName your first action "Set Open Merge Request Count" and set the type Utility > SQL RunUpdate the SQLQuery action field with this valueSet the Result Attribute action field drop down value to the workflow attribute "mergeRequestCount"Conditionally Send Email ActionName your second action "Send Notification Email" and set the type Communications > Email SendUpdate the body text, here is what I started:There are {{ Workflow | Attribute:'mergeRequestCount' }} merge request(s) in the <a href="/reporting/data-integrity/merge-requests">queue</a> This email was sent from {{ 'Global' | Attribute:'InternalApplicationRoot' }}Set the remaining fields for this action as desiredSetup a schedule job to run this workflow on a recurring basisHere is what mine looks likeAdd Duplicate Score Visibility on the Merge People PageNavigate to the Merge PageAdd an html content block to the top of the page with this content Configure html content block so that SQL is checked within the "Enabled Lava Commands" settingNotably when you visit an existing merge request you will see a SET parameter in the url. This SET parameter is tied to a record in the EntitySetId table where we can find the Person Alias Ids included in the merge request. From there we pull information PersonDuplicate regarding the match score and matching fields for each pair of alias in the merge request set.Follow Up Please don't hesitate to leave a comment or message me on Rocket Chat (@tony.visconti) if you have questions or find any issues with this recipe. The Rock community site doesn't currently notify recipe authors when you comment below. Change Log ~2022-08-17 - Initial Draft~2022-09-01 - Added details on how to add Duplicate Score Visibility to Merge Page~2022-09-22 - I have found that I am also interested in keeping an eye on the number of records in the Person Duplicate List. You could also leverage this view and include the number of records greater than a specific confidence score in the email notification.~2023-01-03 - I added detail for setting up a scheduled job, adding Duplicate Score Visibility and fixed various typos Download File