Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Need to build an relationship between RITM table and rm_story table

Suseela Peddise
Kilo Sage

‎08-17-2018 03:41 AM

We have a 'Requested Items' related list in rm_story table to show which RITM has been associated to that particular story .

Similar way , we wanted to see the linked stories in RITM level. For that I have created a new relationship between 'sc_req_item' and 'rm_story' table.

 

It is showing linked stories correctly in the related list, however default filter condition just showing as 'Stories' . There is no default filter condition available.

If I try opening the link in new tab, instead of showing only the linked story it is showing all the list of stories. 

Looking forward for the reply . Thanks in Advance.

Labels:
0 Helpfuls
  • 2,088 Views
2 REPLIES 2

Mark Stanger
Giga Sage

‎08-17-2018 12:18 PM

It sounds like what you really want is a many-to-many table to store this relationship.  That will allow you to have one request item with a list of stories at the bottom and one story with a list of request items at the bottom.  Here is how you can create a many-to-many relationship table.

Here's an article showing how this should be done.

https://www.servicenowguru.com/system-definition/relationships/creating-manytomany-relationship-serv...

0 Helpfuls

Mark Stanger
Giga Sage

‎08-27-2018 06:27 PM

Just checking on on this one.  Has this question been answered or is there more information I can help you with?  If it's been answered, please mark the answer above as the correct one so people know this has been taken care of.  Thanks!

0 Helpfuls