Hello
I'm playing around with the "dependent" attribute on column definition.
Like on incident table ("assigned_to" is dependent on "assignment_group"), I could create my own table create a user and group reference & dependent, and it's working.
Then I created an other table with user & roles references (role "dependent" on user) and it's not working.
(if I select a user I still see all roles).
In general there is a "m2m" table between such 2 references
- user & group: m2m = sys_user_grmember
- user & roles: m2m = sys_user_has_role
These m2m table(s) is not specified when configure an "dependent" in dictionary. How does the systems knows which m2m table to use.
One step further:
- if I create an own application with two tables tab1 & tab2
- I can create multiple m2m - tables referencing tab1 & tab2 for multiple purposes
- how does Servicenow knows which to use for "dependent" ??
I appreciate any contribution. Many thanks.
Sincerely Detlef Biedermann
