Le 02/02/2016 02:14, Joel Levin a écrit :
Hi All:
It just occurred to me that pivotAttributes in LSC may support more
than 1 string attributes?
Is something like the below possible --- it does not work yet -- but
was wondering if I am on the right path.
i.e.to <http://i.e.to> pivot on the 2 attribute combination from the
source database tables which are guaranteed to be unique: the course
group name(cn) and the login name(uid)?
I'm still hitting a snag --- i.e. it is an error w.r.t the pivot
condition on "cn" --- I am missing something --- not sure if I'm on
the correct path and should push further.
Error message: ERROR - Error while synchronizing ID {uid=smith,
cn=ZOOL_649_001_2015W}: org.lsc.exception.LscServiceException: Only a
single record can be returned from a getObject request ! For id=smith,
ZOOL_649_001_2015W (8), there are 72 records !
You can maybe try the group_concat function:
http://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_group-concat
This will allow to return only one value per group. Then use javascript
in the dataset to parse the conatened value and transform it into an array.
Else you can use the executable plugin to script your SQL requests:
http://lsc-project.org/wiki/documentation/plugins/executable
--
Clément OUDOT
Consultant en logiciels libres, Expert infrastructure et sécurité
Savoir-faire Linux
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
