Duplicate detection using JavaScript

(0) Share

Report

Posted on by Community Member

Hello,
I am trying to write a function which throws an error message if one of the records has a few field records which are duplicate.
Name of entity - dev_employee
Name of the lookup field - dev_centerid
Name of the field which needs to be checked for duplicates - dev_employeeid

So I am using SDk.Rest method to retrieve all the dev_employee records in which the dev_centerid is equal to the current record on which it will be run.

function EmployeeDuplicateDetection() {
var ecid = Xrm.Page.data.entity.attributes.get("dev_centerid").getValue()[0].id;
var EmpID = Xrm.Page.getAttribute("dev_employeeid").getValue();
var containsDuplicates = false;
SDK.REST.retrieveMultipleRecords(
"dev_employee",
"?$select=dev_employeeid,dev_entertainmentcenterid&$filter=dev_entertainmentcenterid/Id eq guid'" + ecid,
function (results) {

if (results.length > 0)
{
int length = results.length;
for(i=0; i<length; i++)
{
var employeeID = results[i].dev_employeeid;
if(employeeID == EmpID)
{
alert("Record with same Employee ID already exists. Please use different ID.");
}
}
}
},
function (error) {
alert(error.message);
},
function () {
//On Complete - Do Something
}
);
}

I am thrown a EmployeeDuplicateDetection() cannot be run on Event handler error. I have loaded the Rest.SDK library to the form as well.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Koen VdV 1,219 on at

Like (0)

Report

Probably you have a good reason for this, but why are you not using the OOB functionality?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Koen,

Thanks for the response. Are you asking about the duplicate detection? If that's the case, the reason is I just want the user to be thrown an error message. I do not want the user to be shown all the records with the same field value existing in the system(Duplicate Detectiion wizard).

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

I am not sure if this is the case, but why are you not using the CRM 2016 Web API. It is possible that the Rest.SDK is not longer functioning (or functioning properly) in 2016.

There are a few libraries that you can use for the CRM 2016 Web Api (which are somewhat similar to Rest SDK). Below are a couple:

github.com/.../Xrm.Tools.CRMWebAPI

sdkwebapi.codeplex.com

Microsoft released webapi functionality as part of their Xrm namespace in v9.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

JayeshAC 1,157 on at

Like (0)

Report

Hi Jim,

Please correct me if my understanding is wrong. You want to restrict an user to create an record if it is already present in the system with same dev_centerid and you are verifying the duplicate records by dev_centerid of the current record.

If my understanding is correct then why don't you use sync plugin in Pre-validation stage?

You can use Query Expression/Linq/FetchXml to retrieve the record whose dev_centerid is equal to current record's dev_centerid. If you found the result then simply throw an InvalidPluginExecutionException with error message. It will restrict the user to create a record with same dev_centerid.

Check below link to know more abount InvalidPluginExecutionException.

msdn.microsoft.com/.../microsoft.xrm.sdk.invalidpluginexecutionexception.aspx

Hope this helps to resolve your issue.

Regards,

Jayesh

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Jim,

You can use OOB Key feature available for each Entity in CRM 2016 to restrict the user from creating the duplicate record.

This feature will also through an message for duplicate record.

Was this reply helpful? Yes No
Suggested answer

Iswarya 1,347 on at

Like (0)

Report

Hi,

the following script will populate alert if there is any duplicate record present, and prevent the current record to save.

function GetData(executionObj)

{

debugger;

var x= Xrm.Page.getAttribute("new_x").getValue();

var y=Xrm.Page.getAttribute("new_y").getValue();

if (x!= null && y!=null )

{

var xId = x[0].id;

var yId = y[0].id;

var context = Xrm.Page.context;

var serverUrl = context.getClientUrl();

var ODataPath = serverUrl + "/XRMServices/2011/OrganizationData.svc";

var retrieveResult = new XMLHttpRequest();

retrieveResult.open("GET", ODataPath +"/new_TestSet?$select=new_X,new_Y&$filter=new_X/Id eq guid'"+xId+"' and new_Y/Id eq guid'"+yId+"'",false);

retrieveResult.setRequestHeader("Accept", "application/json");

retrieveResult.setRequestHeader("Content-Type", "application/json; charset=utf-8?");

retrieveResult.send();

if (retrieveResult.readyState == 4 /* complete */)

{

if (retrieveResult.status == 200)

{

var retrieved = this.parent.JSON.parse(retrieveResult.responseText).d;

var Result = retrieved.results;

if (typeof Result !== "undefined")

{

var count = Result.length;

if (count>1)

{

alert("duplicate value not allowed");

executionObj.getEventArgs().preventDefault();

}

}

}

}

}

}

Was this reply helpful? Yes No