X-Git-Url: http://git.rot13.org/?p=virtual-ldap;a=blobdiff_plain;f=sql%2Fhreduperson.sql;fp=sql%2Fhreduperson.sql;h=b3cb5b3e1db1ce7a600d0da8fb02ce1f27defef3;hp=568e5f53dbd8b1d469f4b27db03382416013f6d3;hb=baa13147ede9edae755288ab1a1f0779366b2dff;hpb=704421304e70ffc488ce7bd9a58dd8ee9cd64915

diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql
index 568e5f5..b3cb5b3 100644
--- a/sql/hreduperson.sql
+++ b/sql/hreduperson.sql
@@ -12,13 +12,16 @@ select
 	concat(firstname,' ',surname)			as cn,
 
 	-- SAFEQ specific mappings from UMgr-LDAP.conf
-	borrowernumber					as objectGUID,
+	b.borrowernumber					as objectGUID,
 	surname						as displayName,
-	rfid_sid					as pager,
+	a.attribute					as pager,
 	email						as mail,
 	categorycode					as memberOf,
 	categorycode					as ou,
 	categorycode					as department,
-	concat('/home/',borrowernumber)			as homeDirectory
-from borrowers
+	concat('/home/',b.borrowernumber)			as homeDirectory
+from borrowers b
+left join borrower_attributes a on b.borrowernumber = a.borrowernumber and code='RFID_SID'
+
+