{"id":224,"date":"2010-05-05T11:41:00","date_gmt":"2010-05-05T11:41:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=224"},"modified":"2010-05-05T11:41:00","modified_gmt":"2010-05-05T11:41:00","slug":"change-the-standard-dedupe-behavior","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/","title":{"rendered":"Change the standard dedupe behavior"},"content":{"rendered":"<p>Dedupe process is the matching logic which is one of the very essential components of CRM system nowadays. This is required in order to avoid duplicate data entries in the system. Standard Sage CRM install has also incorporated this feature for entities like <strong>Company<\/strong> and <strong>Person<\/strong> which hold prime importance in <strong>CRM<\/strong>.<\/p>\n<p><strong>How to configure dedupe behavior in Sage CRM?<\/strong><br \/><strong><\/strong><br \/>Now as explained above dedupe is nothing but the matching logic. To implement the logic in sage <strong>CRM<\/strong>, we need to define <strong>Match-Rules<\/strong> from <strong>Administration<\/strong> &#8211;><strong>Data Management <\/strong>&#8211;><strong>Match Rules<\/strong>. Select an entity and then add the fields to be used for matching logic for example: <strong>Person<\/strong>. These are the fields that are added to <strong>PersonDedupeList <\/strong>under <strong>Administration<\/strong>&#8211;><strong>Customization<\/strong>&#8211;><strong>Person<\/strong>&#8211;><strong>Lists<\/strong>.<br \/>When we add the fields to match rule, it forms the where clause to retrieve the matching records from database. Let\u2019s consider <strong>person<\/strong> entity for an example and suppose we have added two fields under <strong>Match-Rules<\/strong> like <strong>Pers_FirstName <\/strong>and <strong>Pers_LastName<\/strong>. The where clause will be formed like below.<\/p>\n<p><em>\u201cPers_FirstName=\u2019ABC\u2019 <strong>and<\/strong> Pers_LastName=\u2019XYZ\u2019\u201d    <\/em><br \/><em><\/em><br \/><strong>Why this post?<\/strong><br \/><strong><\/strong><br \/>You can see in the where clause formed above the two fields are intersected that means if the match rule is set on fields for exact matching, then the above where clause will retrieve the records having person first name equal to \u2018ABC\u2019 <strong>AND<\/strong> person last name equal to \u2018XYZ\u2019 i.e. it puts the <strong>AND<\/strong> condition in clause.<\/p>\n<p>Now, I came across the business logic where <strong>Person<\/strong> entity forms the core part and the matching is to be done based on <strong>phone number<\/strong> and <strong>email address<\/strong>. My logic has to be designed in such a way that, I am not matching both the fields i.e. <strong>phone number<\/strong> and <strong>email address<\/strong> together using and condition. Instead I want to use them conditionally using <strong>OR<\/strong> clause so that I can retrieve the <strong>person<\/strong> data matching with only <strong>phone number<\/strong> or <strong>email address<\/strong> and also both of them together. In short I want my where clause to be formed like one given below using <strong>OR<\/strong> condition.<\/p>\n<p><em>\u201cPers_emailaddress=\u2019ABC@testweb.com\u2019 <strong>OR<\/strong> Pers_phonefullnumber=\u20191234 1546 5467&#8217;\u201d<\/em>  <\/p>\n<p><strong> Can this be achieved in CRM?<\/strong><\/p>\n<p>The answer is loud YES. Though you cannot achieve this through the standard behavior, we have created and an out of box component which is capable of changing the person entity dedupe behavior as per our requirement. With few changes to the mod we can even use it for company entity also. We can also design the Custom dedupe behavior for our Custom entities which will be based on same logic.<\/p>\n<p><marquee width=\"80%\"><b>If you find this content useful, Please drop us an email at <a title=\"mailto:crm@greytrix.com\" href=\"mailto:crm@greytrix.com\">crm@greytrix.com<\/a>. <\/b><\/marquee><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dedupe process is the matching logic which is one of the very essential components of CRM system nowadays. This is required in order to avoid duplicate data entries in the system. Standard Sage CRM install has also incorporated this feature for entities like Company and Person which hold prime importance in CRM. How to configure\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[720,934,1761],"class_list":["post-224","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-company","tag-dedupe","tag-person"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Change the standard dedupe behavior - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Change the standard dedupe behavior - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Dedupe process is the matching logic which is one of the very essential components of CRM system nowadays. This is required in order to avoid duplicate data entries in the system. Standard Sage CRM install has also incorporated this feature for entities like Company and Person which hold prime importance in CRM. How to configure\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2010-05-05T11:41:00+00:00\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/\",\"name\":\"Change the standard dedupe behavior - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2010-05-05T11:41:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Change the standard dedupe behavior\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Change the standard dedupe behavior - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/","og_locale":"en_US","og_type":"article","og_title":"Change the standard dedupe behavior - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Dedupe process is the matching logic which is one of the very essential components of CRM system nowadays. This is required in order to avoid duplicate data entries in the system. Standard Sage CRM install has also incorporated this feature for entities like Company and Person which hold prime importance in CRM. How to configure\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2010-05-05T11:41:00+00:00","author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/","name":"Change the standard dedupe behavior - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2010-05-05T11:41:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/05\/05\/change-the-standard-dedupe-behavior\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Change the standard dedupe behavior"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=224"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/224\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}