From 0e6a310cce589d12bb6543d7ebe2681f581fefd5 Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Sat, 23 Feb 2019 10:03:32 +0100 Subject: [PATCH] extract @ffzg.hr mail or safeq smtp server will reject it --- sql/hreduperson.sql | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql index b3cb5b3..c40b846 100644 --- a/sql/hreduperson.sql +++ b/sql/hreduperson.sql @@ -15,7 +15,12 @@ select b.borrowernumber as objectGUID, surname as displayName, a.attribute as pager, - email as mail, + case + when email regexp '@ffzg.hr' then email + when emailpro regexp '@ffzg.hr' then emailpro + else + trim(userid) + end as mail, categorycode as memberOf, categorycode as ou, categorycode as department, -- 2.20.1