remove clever e-mail selection and use primary one

[virtual-ldap] / sql / hreduperson.sql

diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql
index c40b846..b3cb5b3 100644 (file)
--- 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,