Eileen has uploaded a new change for review.
https://gerrit.wikimedia.org/r/308678
Change subject: Exclude placeholder email from dedupe queries
......................................................................
Exclude placeholder email from dedupe queries
Change-Id: If75ef5a81c525bcf3b7d71c8260f61a0a273d42c
---
M CRM/Dedupe/BAO/QueryBuilder/IndividualUnsupervised.php
1 file changed, 2 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm/civicrm
refs/changes/78/308678/1
diff --git a/CRM/Dedupe/BAO/QueryBuilder/IndividualUnsupervised.php
b/CRM/Dedupe/BAO/QueryBuilder/IndividualUnsupervised.php
index 1ae3af9..b39ecc3 100644
--- a/CRM/Dedupe/BAO/QueryBuilder/IndividualUnsupervised.php
+++ b/CRM/Dedupe/BAO/QueryBuilder/IndividualUnsupervised.php
@@ -66,6 +66,7 @@
JOIN civicrm_email as email2 ON
email2.contact_id=contact2.id AND
email1.email=email2.email
+ AND email.1 <> 'nob...@wikimedia.org'
WHERE contact1.contact_type = 'Individual'
AND " . self::internalFilters($rg);
return array("civicrm_contact.{$rg->name}.{$rg->threshold}" => $query);
@@ -97,6 +98,7 @@
FROM civicrm_email as email1
JOIN civicrm_email as email2 USING (email)
WHERE email1.contact_id < email2.contact_id
+ AND email.1 <> 'nob...@wikimedia.org'
AND " . self::internalFilters($rg, "email1.contact_id",
"email2.contact_id");
CRM_Core_DAO::executeQuery($sql);
--
To view, visit https://gerrit.wikimedia.org/r/308678
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: If75ef5a81c525bcf3b7d71c8260f61a0a273d42c
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/crm/civicrm
Gerrit-Branch: master
Gerrit-Owner: Eileen <emcnaugh...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
