Synch Mapping FK relation ADSAccount EX0Mailbox

Question

Hello all, 
 I have a Synch-Mapping question. 
 I am in the AD Synch-Project mapping from the ADSAccount. 
 From that point, I want to have the values "EmailAddresses" which are stored in the table "EX0Mailboxes". 
 There is an FK relation from EX0Mailboxes to ADSAccount. How can I get the value EmailAddresses from EX0Mailboxes? 
 I tried with scripted properties but I cannot use Connection.GetSingleProperty("EX0Mailbox","EmailAddresses", f.Comparision("UID_ADSAccount), $UID_ADSAccount$) as the Connection object is based on VI.Projector and unfortunately I dont have any insight how to use it correctly. 
 Thanks, Fatih

Markus Weiss-Ehlers · Answer

Do you have mapping rule configured to write something to the property itself to trigger your script? 
 
You try to debug the script in Visual Studio using the DEBUG button. In the new Sync Editor - open your Sync Project, go to the target system browser of the OneIM connection and try to set the virtual property to something. You will see, that the script will be triggered. (Do not forget to set a break point in your property script in Visual Studio.

Markus Weiss-Ehlers · Answer

Hi Werner, 
 you do have a limited filter formatter available using the SystemObject . It is limited in a way that it only supports some of the operations the full SQL formatter is capable of doing. When the SystemObject is created by a OneIM connector connection the filter formatter will be mapped to the SQL formatter of the OneIM connection. 
 The same sample as above with the filter formatter would look like the following. 
 
 Imports VI.Projector.Connection 
 
 Dim email = SystemObject.Connection. QueryObject ( SystemQuery . _ 
 From ( "EX0MailBox" ). Select ( "EmailAddresses" ) _ 
 . Filter (SystemObject.Connection.FilterFormatter. Comparison ( _ 
 SystemObject. SchemaType ( "UID_ADSAccount" ), _ 
 $UID_ADSAccount $ , Filter_ 
 .Formatter.FilterCompareOperator. Equal ) _ 
 ) _ 
 ).Result.First. GetValue ( "EMailAddresses" ).AsString 
 
 Return email 
 
 Hth

Endpoint Privilege Management

Synch Mapping FK relation ADSAccount <> EX0Mailbox

Top Replies