• State Suggested Answer
  • +2 person also asked this people also asked this
  • Locked Locked
  • Replies 11 replies
  • Answers 2 answers
  • Subscribers 95 subscribers
  • Views 13426 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Synch Mapping FK relation ADSAccount <> EX0Mailbox

fatih.eroglu
over 7 years ago

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

Parents
  • 0 over 7 years ago

    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

Reply
  • 0 over 7 years ago

    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

Children
No Data