{"id":1756,"date":"2015-10-20T19:45:17","date_gmt":"2015-10-20T19:45:17","guid":{"rendered":"http:\/\/himbap.com\/blog\/?p=1756"},"modified":"2015-11-30T10:28:23","modified_gmt":"2015-11-30T10:28:23","slug":"retrieve-duplicate-detection-rules-using-crm-sdk","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=1756","title":{"rendered":"Retrieve Duplicate Detection Rules using CRM SDK"},"content":{"rendered":"<p>Sometime you may require to retrieve duplicate detection rules using CRM SDK, this post will help you to write code to get duplicate detection rule. Let\u2019s take an example we want to retrieve all the duplicate detection rules based on the entity name, if you will navigate to <strong>Settings-&gt; Data Management -&gt; Duplicate Detection Rules<\/strong>, you will see duplicate detection rules for entities, for example below is the duplicate rules for contact entity<\/p>\n<p><span style=\"color: #000000; font-family: Calibri;\"><a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2015\/10\/Duplicaterule1.png\"><img decoding=\"async\" loading=\"lazy\" class=\" size-medium wp-image-1757 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2015\/10\/Duplicaterule1-300x100.png\" alt=\"Duplicaterule1\" width=\"300\" height=\"100\" srcset=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2015\/10\/Duplicaterule1-300x100.png 300w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2015\/10\/Duplicaterule1-624x209.png 624w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2015\/10\/Duplicaterule1.png 875w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/span><\/p>\n<p>We can use following code to get duplicate detection rule records, we are using simplified connection to connect CRM deployment, you can refer <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/gg695810.aspx\">this <\/a>for details on simplified connection:<\/p>\n<pre class=\"brush: csharp; title: ; notranslate\" title=\"\">\r\nusing(OrganizationService crmService = new\r\n\r\nOrganizationService(&quot;OrganizationService&quot;))\r\n\r\n{\r\n\r\n\tQueryExpression query = new QueryExpression\r\n\r\n\t{\r\n\r\n\t\tEntityName = &quot;duplicaterule&quot;,\r\n\r\n\t\tColumnSet = new ColumnSet(&quot;name&quot;),\r\n\r\n\t\tCriteria =\r\n\r\n\t\t{\r\n\r\n\t\t\tFilterOperator = LogicalOperator.And,\r\n\r\n\t\t\tConditions =\r\n\r\n\t\t\t{\r\n\r\n\t\t\t\tnew ConditionExpression\r\n\r\n\t\t\t\t{\r\n\r\n\t\t\t\t\tAttributeName = &quot;baseentityname&quot;,\r\n\r\n\t\t\t\t\tOperator = ConditionOperator.Equal,\r\n\r\n\t\t\t\t\tValues = {&quot;contact&quot;}\r\n\r\n\t\t\t\t},\r\n\r\n\t\t\t\tnew ConditionExpression\r\n\r\n\t\t\t\t{\r\n\r\n\t\t\t\t\tAttributeName = &quot;statecode&quot;,\r\n\r\n\t\t\t\t\tOperator = ConditionOperator.Equal,\r\n\r\n\t\t\t\t\tValues = {1}\r\n\r\n\t\t\t\t}\r\n\r\n\t\t\t}\r\n\r\n\t\t}\r\n\r\n\t};\r\n<\/pre>\n<p>In above code we are retrieving only published duplicate rules, so it will fetch two records for us<\/p>\n<p><a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2015\/10\/Duplicaterule2.png\"><img decoding=\"async\" loading=\"lazy\" class=\" size-medium wp-image-1758 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2015\/10\/Duplicaterule2-300x65.png\" alt=\"Duplicaterule2\" width=\"300\" height=\"65\" srcset=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2015\/10\/Duplicaterule2-300x65.png 300w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2015\/10\/Duplicaterule2.png 600w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>After that we can loop through entity collection to get individual duplicate rule if required using following code:<\/p>\n<pre class=\"brush: csharp; title: ; notranslate\" title=\"\">\r\n\r\nforeach (Entity duplicaterule in entityCollection.Entities){\r\n\r\n\/\/processing entitycollection records\r\n\r\n}\r\n<\/pre>\n<p>Also in case you need unpublished duplicate rules you can check statecode like below:<\/p>\n<pre class=\"brush: csharp; title: ; notranslate\" title=\"\">\r\nnew ConditionExpression\r\n{\r\n\tAttributeName = &quot;statecode&quot;,\r\n\tOperator = ConditionOperator.Equal,\r\n\tValues = {0}\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Sometime you may require to retrieve duplicate detection rules using CRM SDK, this post will help you to write code to get duplicate detection rule. Let\u2019s take an example we want to retrieve all the duplicate detection rules based on the entity name, if you will navigate to Settings-&gt; Data Management -&gt; Duplicate Detection Rules, you will see duplicate detection&#8230; <a href=\"https:\/\/himbap.com\/blog\/?p=1756\">Read more &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[21,5,6,8],"tags":[233,234],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1756"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1756"}],"version-history":[{"count":8,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1756\/revisions"}],"predecessor-version":[{"id":1888,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1756\/revisions\/1888"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}