Comments on: Creating a Many-to-Many relationship in ServiceNow

By: Jim Pisello

Jim Pisello — Fri, 14 Jul 2017 16:57:30 +0000

In reply to Dharani. Hi Dharani, Have you created the appropriate ACLs on the new many-to-many table to allow users with the ITIL role to create and write to records on that table?

By: Dharani

Dharani — Sun, 18 Jun 2017 07:16:39 +0000

Hi Mark,

ITIL users cannot able to view New/Edit button in the related list.

Any solution?

Thanks,
Dharani

By: Mark Stanger

Mark Stanger — Wed, 17 Feb 2016 15:56:10 +0000

In reply to Dave Edgar. It should do exactly that. I'd guess that you don't have the right related list associated...or maybe not the correct columns shown. If you're relating a problem to a problem you would probably need to include both columns to show both sides of the relationship.

By: Dave Edgar

Dave Edgar — Wed, 17 Feb 2016 15:34:10 +0000

Hi Mark

This works well BUT what it doesn’t do is put a link on the record you have linked to. I’ll explain. I’m linking problems to problems. So for example I’m in PRB001 and link to PRB002. So PRB001 shows PRB002 in the related list but in the PRB002 record it doesn’t show PRB001 in it’s related list. Is there a way of doing this?

By: Mark Stanger

Mark Stanger — Thu, 06 Sep 2012 12:21:50 +0000

In reply to Akshat. You'll want to take a look at ACL security for that table as well. Make sure that users have create, write, and delete access.

By: Akshat

Akshat — Thu, 06 Sep 2012 04:25:58 +0000

HI Mark

I have Created a Related list from Relationship under the system definitions application while displaying this as a related list on the form the edit button is not showing up… But by default every related list has a edit button

I have also tried that from list control enable edit but i am enable to show the edit button on my related list…

Regards
Akshat

By: Andrew

Andrew — Thu, 09 Aug 2012 13:59:37 +0000

Thanks for the info Mark. When I looked at it, I didn’t exactly like the way that the plugin worked either. I think I will stick with the method you are using here.

By: Mark Stanger

Mark Stanger — Wed, 08 Aug 2012 16:24:06 +0000

In reply to Andrew.

Auditing is kind of tricky in this situation because the operations are almost always an insert or a delete. If you want to audit these changes, then you need to set up a business rule on your m2m table to capture those changes and then store them in some other related record.

As far as the best way, I’ve never really been a huge fan of the many-to-many task relations plugin because it’s got such a broad scope (all task types) and that makes it so that you always have to filter the information in the related list. In my experience, the cases where you need this type of functionality are generally very few and very targeted, which is why I prefer to set up my own table.

By: Andrew

Andrew — Wed, 08 Aug 2012 16:20:00 +0000

Is there any way to audit changes of relationships established this way? Is this still the best way to set this up, or should the Related Items plugin be used?

By: Ajay

Ajay — Mon, 10 Jan 2011 18:12:54 +0000

In reply to Mark Stanger.

Thank you mark will try that and will get back to you.

Yeah when i tried to deleted from the table dictionary entry (delete) the m2m still stay there…i was trying to just change the lable name,…but its failed…

will try any other way to do that…thank you very much