how to change the collection list on edit members in servicenow

Noah Bae
Kilo Contributor

Hi all~ Happy New Year!!

I have a question. This is a table that I made.

find_real_file.png

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.

find_real_file.png

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.

find_real_file.png

How can I change the collection list like 'Group Member'.

If you know how to change the collection list, please let me know.

1 ACCEPTED SOLUTION

Arvind Singh Ra
Kilo Guru

Hi Noah,

 

Try mapping your Team Members table with the sys_user table.

use sys_m2m to create a new mappping:

find_real_file.png

 

find_real_file.png

 

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

View solution in original post

6 REPLIES 6

Arvind Singh Ra
Kilo Guru

Hi Noah,

 

Try mapping your Team Members table with the sys_user table.

use sys_m2m to create a new mappping:

find_real_file.png

 

find_real_file.png

 

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

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?

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

Sorry, Arvind.
I don't understand well about it.
I want to know how to add to related list what I made mtom.
I couldn't find it on configuring related lists page.find_real_file.png