Dynamics Community Forum Thread Details

List only the duplicate leads in a subgrid

Hi,

I am not familiar with Js and I am trying to create view that displays duplicate Leads. I found this link Solved: List only the duplicate leads in a view on the community that addressed adding a subgrid on the Lead form to duplicate leads only when the firstname, lastname and topic is the same on the formOnload.

I tried the script but kept getting an error:

One of the scripts for this record has caused an error. For more details, download the log file.

The script:

function getDuplicates(executionContext) {
    var formContext = executionContext.getFormContext();
    if (formContext.ui.getFormType() != 1) {
        var duplicatesGridControl = formContext.getControl("Duplicates");
        if (duplicatesGridControl == null) {
            setTimeout(function () { getDuplicates(executionContext); }, 2000);
        } else {
            var leadId = formContext.data.entity.getId().replace("{", "").replace("}", "");
            var firstName = formContext.getAttribute('firstname')?.getValue();
            var lastName = formContext.getAttribute('lastname')?.getValue();
            var topic = formContext.getAttribute('subject')?.getValue();
            var fetchXml = `
                <fetch>
                    <entity name='lead'>
                        <attribute name='fullname'/>
                        <filter type='and'>
                            <condition attribute='firstname' operator='eq' value='${firstName}' />
                            <condition attribute='lastname' operator='eq' value='${lastName}' />
                            <condition attribute='subject' operator='eq' value='${topic}' />
                            <condition attribute='leadid' operator='ne' value='${leadId}' />
                        </filter>
                    </entity>
                </fetch>
            `;
            duplicatesGridControl.setFilterXml(fetchXml);
            duplicatesGridControl.refresh();
            var summaryObj = formContext.ui.tabs.get("Summary");
            var duplicatesObj = summaryObj.sections.get("Summary_Duplicates");
            duplicatesObj.setVisible(true);
        }
    }
}