From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Sat, 29 Aug 2015 12:47:18 +0000 (+0200)
Subject: skip expired users
X-Git-Url: http://git.rot13.org/?p=virtual-ldap;a=commitdiff_plain;h=18fe1e064f5df47388257a74464a112e76b204ee;ds=sidebyside

skip expired users
---

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'