From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Thu, 19 Dec 2019 14:43:26 +0000 (+0100)
Subject: remove clever e-mail selection and use primary one
X-Git-Url: http://git.rot13.org/?p=virtual-ldap;a=commitdiff_plain;h=c004207348f0a98a6ed47d255eb20eae213c524f

remove clever e-mail selection and use primary one
---

diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql
index c40b846..b3cb5b3 100644
--- a/sql/hreduperson.sql
+++ b/sql/hreduperson.sql
@@ -15,12 +15,7 @@ select
 	b.borrowernumber					as objectGUID,
 	surname						as displayName,
 	a.attribute					as pager,
-	case
-		when email    regexp '@ffzg.hr' then email
-		when emailpro regexp '@ffzg.hr' then emailpro
-	else
-		trim(userid)
-	end as mail,
+	email						as mail,
 	categorycode					as memberOf,
 	categorycode					as ou,
 	categorycode					as department,