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.

Where does all related lists information will be stored.

nithingurajala
Kilo Contributor

Hi Folks,

I have one doubt, I want to find where all the related list will be stored ..?

So when ever we try to add a related list for a particular form we can notice related list for that form will be unique when compared with others.

example:

In user table I can see so many related list:

find_real_file.png

In Incident form it is different.

find_real_file.png

So where do all this related list are stored, how do they are linked to tables or forms.

I tried to see in Relationship table(sys_relationship) where I am not able to find all these related lists.

even I tried to see in sys_m2m table even I did not get it.

so can any one let me know the underlying concept of related list .

I will be thankful if you brief me about this.

Nithin.

Developer CommunityServiceNow Developers Blogctomasi

1 ACCEPTED SOLUTION
5 REPLIES 5

Chuck Tomasi
Tera Patron

The definitions of what related lists appear on which forms is defined in "sys_related_list" table.



From the image below, I can see that the incident "Default view" has three related lists on it. SLAs, CIs and a defined relationship that is calculated at runtime (probably something like incidents by same caller.)


find_real_file.png


Thanks chuck for your quick reply.



I have one requirement where I need to add two related list of same table(with different conditions) on same table.


My be these may confuse you I will give an example.



On incident form I want task related list with two different conditions.


one related list for Priority 1 and other is for Priority 1



But when ever I add condition it is changing. Is there any way do achieve this.



Please refer the screen shot for reference.


find_real_file.png



Thanks,


Nithin.


You will need to create custom relationship for this.


Creating Defined Related Lists - ServiceNow Wiki


Kalai nailed it! You need to create your own custom defined relationship. I do this all the time. It's pretty easy. Take a look at the documentation and there are examples to follow to build in your filter and have it show up as a related list you can select.