Hi all~ Happy New Year!!
I have a question. This is a table that I made.
There are three related lists. 'Group Members', 'Team Members', 'TestMembers'.
* Group Members list is 'sys_user_grmember'
* Team Members list is a table what I made.
* TestMembers list is extended 'Group Member'
I want to make lists of the same functions.
You can add columns by clicking on the Edit button.
This is 'Edit members' view when you click the Edit button in 'Group Members'.
This collection list shows list of users. You can select users and add the columns.
I think this users list is 'sys_user'.
But 'Team members' is not show list of users. It shows own records.
How can I change the collection list like 'Group Member'.
If you know how to change the collection list, please let me know.
Hi Noah,
Try mapping your Team Members table with the sys_user table.
use sys_m2m to create a new mappping:
Also go through: https://docs.servicenow.com/bundle/newyork-platform-administration/page/administer/table-administrat...
M2M relationship definition method creates a related list that by default uses the "Edit" button slush bucket. In most cases, the preferred behavior on a many to many relationship is to select from a slush bucket rather than create new records.
After m2m mapping of your Team members table with the user table, it should resolve your issue.
Please do Mark correct and helpful based on impact.
Regards,
Arvind
Hi Noah,
Please ignore my very first reply.
- What I am trying to say is that you need to open 'sys_relationship.list' table. There you will find all the related lists and search for Team members related list.
- open your Team member related list from there and a form will appear like this:
- Afterwards select sys_user table in 'Queries from table' field and also select a table in Apply to table(it will be there by default in your case) field,where you want to apply this(Where this related list will appear).
- Then you need to submit it.
- Then go back to the table where this related list(Team Member) is and select the edit button. After that you will see user data populated in the slush bucket.
Please mark it correct if it helps you.
Warm regards,
Arvind
