Related List on Asset form

roomawakar
Tera Contributor

Hi All,

 

I want a new related list called "Location" on the alm_hardware form. When I am configuring form and looking into the slush bucket, i donot find any relationship between Location -> Asset.

 

Where will I get this? or I need to configure a new relationship between those?

 

Thanks,

Rooma

1 ACCEPTED SOLUTION

Sandeep Rajput
Tera Patron
Tera Patron

@roomawakar If there is no existing relationship between the Asset and Location table then you can create a new relationship using the Relationship module

 

Screenshot 2024-07-30 at 6.35.49 PM.pngScreenshot 2024-07-30 at 6.36.11 PM.pngScreenshot 2024-07-30 at 6.41.00 PM.png

You can add the related list as follows.

 

Screenshot 2024-07-30 at 6.42.16 PM.png

Screenshot 2024-07-30 at 6.42.25 PM.png

Screenshot 2024-07-30 at 6.42.43 PM.png

Screenshot 2024-07-30 at 6.42.52 PM.png

View solution in original post

4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @roomawakar 

 

In this case, you need to create an M2M relationship. 

 

https://www.servicenow.com/community/developer-articles/servicenow-create-custom-related-list-servic...

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Sandeep Rajput
Tera Patron
Tera Patron

@roomawakar If there is no existing relationship between the Asset and Location table then you can create a new relationship using the Relationship module

 

Screenshot 2024-07-30 at 6.35.49 PM.pngScreenshot 2024-07-30 at 6.36.11 PM.pngScreenshot 2024-07-30 at 6.41.00 PM.png

You can add the related list as follows.

 

Screenshot 2024-07-30 at 6.42.16 PM.png

Screenshot 2024-07-30 at 6.42.25 PM.png

Screenshot 2024-07-30 at 6.42.43 PM.png

Screenshot 2024-07-30 at 6.42.52 PM.png

Hi Sandeep,

 

Thanks for your quick response. Can you please tell me why we are using 'sys_id' in the query while creating the relationship?

 

Thanks,

Rooma

@roomawakar We are only fetching those locations which are related with location populated on the Asset form.