skip expired users

diff --git a/sql/group.sql b/sql/group.sql
index 47c28b8..b862457 100644 (file)
--- a/sql/group.sql
+++ b/sql/group.sql
@@ -8,4 +8,4 @@ select
        concat('uid=',replace(userid,'@ffzg.hr',''),',ou=',c.categorycode,',dc=ffzg,dc=hr') as members
 from categories c
 join borrowers b on b.categorycode = c.categorycode
-where length(userid) > 0
+where length(userid) > 0 and userid not like '%@expired'