• State Suggested Answer
  • Locked Locked
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 96 subscribers
  • Views 4313 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

Map One Identity tables

sgulyaev
over 7 years ago

We have 2 tables in One Identity namager: Person and Locality.
We want that Person table etrieve "City", "Room", "Phone" fields from Locality table (from which locality the person belongs).
Any idea how to do this?

  • 0 over 7 years ago
    You can extend the Locality table with the 3 columns, then add a template on Person.City, Person.Room and Person.Phone to pull the data from the UID_Locality.

    HTH
  • 0 over 7 years ago
    Locality table have Locality.City, Locality.Person, Locality.Phone fields.
    I don't know what template should we use to pull data.
    And where can we configure this template?
  • 0 over 7 years ago
    What is your use case?
    I would assign the locality as Primary location to the employee. The city will be set by default then.
    The same logic can be made for room and phone, but I especially for room, I don't get the use case.
    You can do that in the schema editor in designer.
  • 0 over 7 years ago

    Interesting question.

    Out of the box, there are templates on the columns Person.City, Person.Room and Person.Phone that fetch the data via the primary location assignment of the person (Person.UID_Locality).

    So I think you just need to check the columns in Designer to see if any customizations prevent your use-case from working.