- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-02-2020 09:52 PM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2020 12:48 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2020 12:48 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-06-2020 11:00 PM
Thanks for the answer, Arvind.
I made M2M relationship, but I don't know how to use this.
Can you give me some more details?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-06-2020 11:46 PM
Hi Noah,
You need to go open 'sys_relationship' table. It contains all the related lists and then search for Team members related list.
Afterwards select sys_user table in 'Queries from table' and also select Apply to table where you want to apply this(Where this related list will appaer).
then Submit
I hope this helps you.
Please do Mark correct and helpful based on impact.
Regards,
Arvind
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-07-2020 12:39 AM