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.