From 18fe1e064f5df47388257a74464a112e76b204ee Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Sat, 29 Aug 2015 14:47:18 +0200 Subject: [PATCH] skip expired users --- sql/group.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/group.sql b/sql/group.sql index 47c28b8..b862457 100644 --- 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' -- 2.20.1