Parent Directory
| 
Revision Log
implement multiple values by keeping dn and repeating rows with changed attributes, implement organizationalunit and group with same attributes as Active Directory
| 1 | select |
| 2 | concat('cn=',c.categorycode,',ou=groups') 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 |
| ViewVC Help | |
| Powered by ViewVC 1.1.26 |