extract @ffzg.hr mail or safeq smtp server will reject it

[virtual-ldap] / sql / hreduperson.sql

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