Can't edit related lists.

Andrew Jordan1
Tera Contributor

‎11-11-2022 01:07 AM

A strange one for you.

I have four tables Risk, Hazard, SOP and Department that are joined together by six m2m tables like this..toomanym2m.PNG

Which all seems to work and do what we want it to do.

My problem is when adding the related links to the bottom of a form.

related links.PNG

When viewing from a Hazard Record you can see the SOP and Risk records in the list and filter buttons and New and Edit buttons work.

When viewing from a SOP Record you can see the Hazard and Risk records in the list and filter buttons and New and Edit buttons work.

But..

When viewing from a Risk record you can see the SOP and Hazard records , all of the filter buttons and New and Edit buttons are there but nothing happens when you click on them. It's like the whole tabs are dead.

We've just upgraded from Rome to Tokyo and it did this on both versions.

 

Anyone have any idea where to start looking. I'm assuming it's some security rule somewhere.

Preview file
15 KB
Preview file
30 KB
0 Helpfuls
  • 872 Views
3 REPLIES 3

Anurag Tripathi
Mega Patron
Mega Patron

‎11-11-2022 01:13 AM - edited ‎11-11-2022 01:14 AM

I can see it getting messy, why don't you create relationships by query? By that you will be able to get the ideal result.

The New and Edit button take you to the M2M table instead of the actual Risk or Department table and that is why you don't see anything there. 

How to create Scripted Relationships or Defined Re... - ServiceNow Community

-Anurag
0 Helpfuls

Andrew Jordan1
Tera Contributor
In response to Anurag Tripathi

‎11-14-2022 02:03 AM

HI, 

 

We can't do it that way as we need the Edit button which isn't available from a query relationship.
There's also no shared fields on any of the records to query against.

It's not the relationships we have a problem with it's that nothing on the tab works which means we can't edit the list or change any column views or filter.

 

0 Helpfuls

Andrew Jordan1
Tera Contributor

‎11-17-2022 08:03 AM

Sorted it.

 

This was a weird error. After going through loads of ACL's and security permissions I noticed that the page wasn't scrolling all the way down to the bottom. 

After a bit of googling I found out something about page lengths. As the form was all just one long form I added a tab section in the form.

This allowed the form to scroll all the way to the bottom of the page. Once it did this all the buttons worked as they should.

0 Helpfuls