From c004207348f0a98a6ed47d255eb20eae213c524f Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Thu, 19 Dec 2019 15:43:26 +0100 Subject: [PATCH] remove clever e-mail selection and use primary one --- sql/hreduperson.sql | 7 +------ 1 file changed, 1 insertion(+), 6 deletions(-) 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, -- 2.20.1