• State Suggested Answer
  • Locked Locked
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 93 subscribers
  • Views 1847 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

Foreign Key from AccProduct Child/Parent Relationship in Dropdownlist

gpcservicenow
over 5 years ago

I have created a custom table which has optional FK to itself for the purpose of child/parent relationships - similar to ADSGroup/Org/AccProductGroup tables etc.

When I create a FK relationship from the AccProduct table to this table, in Manager when editing the master data for a Service Item (AccProduct) the data from the new custom table is shown in a flat structure - instead of showing all parent items with expandable option to view the child objects.

Does anyone know how to ensure that the parent/child style relationship can be viewed for the custom table?

Custom table viewed from the service item, flat structure

What the Org table looks like with the parent/child relationship

  • 0 over 5 years ago

    I have found the solution now.

    The parent FK column on the custom table needs to be updated to have Recursive Key set to TRUE.

    This can be modified in Designer > One Identity Manager Schema > Custom Tables > select your table > your custom table parent FK > Column Properties > Tab More: