Defined Related List from multiple tables

pdom
Mega Expert

Hello,

I have the following setup

On Request Item, I have a field called "Completed by change"

On Incident Table, I have a field called "Caused by Change"

On Problem Table, I have two fields called "Resolved by change" and "Caused by change"

Now I have two create Two related lists called "Items Caused by Change" and "Items Resolved by Change" and show up the above tasks

I am not sure how to created a related list from multiple table, like the "Items Resolved by Change" on change table should show up the Request item and the Problem records that are related to the change under this related list

Any help please:(

7 REPLIES 7

sergiu_panaite
ServiceNow Employee
ServiceNow Employee

Hi Padmini,



You can define Relationships (System Definition -> Relationships), and as an example see one out of box called 'Change Requests',



Regards,


With relationships I can only refer data from one table. But here I am   looking to get data from multiple tables under one related list


ramireddy
Mega Guru

You can create a database view and use this database view to create "Related list". Your view should be like below.



select <required cols> form incidents table where <your filter>


UNION ALL


select <required cols> form views table <your filter>



Then you can use this view in "related lists".


Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Padmini,



You may find below blog helpful.


Defined Related Lists - ServiceNow Guru