• State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 93 subscribers
  • Views 92 views
  • Users 0 members are here
Options
Related

Difficulty with cross-object value template

bahruz novruzov_64493
1 month ago

Hello everyone,

Could you please advice in creation of simple template for a column in Person table, where I'll use the value from ADSAccount table.

I have tried the following within CustomProperty10 column of Person table:

Value = $FK(UID_ADSAccount).ExtensionAttribute10$

Value = $FK(UID_ADSAccount),ADSAccount.ExtensionAttribute10$

Getting compile error.

Identity Manager v.9.1

  • 0 1 month ago

    When you look at the table definitions you will see that there is no foreign-key UID_ADSAccount in the Person table. The relations are the other way round, the table ADSAccount points to the person table via the FK UID_Person. That's why your template doesn't compile.

    In general, if you want to copy data from a child table to the parent, you need to code this either in the on-saving script of the child table (ADSAccount in your case) which ends in a synchronous update of the assigned entry in the Person table, or you create a process chain for the events Update (and potentially Insert/Delete) depending on your use-case.

    For your special case, I would take a look at the default process for updating an identity (aka Person) with the data from an assigned ADSAccount.

    Check the documentation on that topic here support.oneidentity.com/.../18

    HtH