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

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
    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
    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
    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

    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.