virtual-ldap/sql/group.sql

select
        concat('cn=',c.categorycode,',ou=',c.categorycode)      as dn,
        'group'                         as objectClass,
        'groups'                        as ou,
        c.categorycode                  as cn,
        description                     as description,

        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
1	select
2	concat('cn=',c.categorycode,',ou=',c.categorycode) as dn,
3	'group' as objectClass,
4	'groups' as ou,
5	c.categorycode as cn,
6	description as description,
7
8	concat('uid=',replace(userid,'@ffzg.hr',''),',ou=',c.categorycode,',dc=ffzg,dc=hr') as members
9	from categories c
10	join borrowers b on b.categorycode = c.categorycode
11	where length(userid) > 0