List layout to include fields from Related List columns

[krishnakumar2]

Hello Everyone,

We have a requirement show some of the fields from related list table in the parent table list layout.

cmdb_ci_ip_address table has been added as related list to network adaptor table. Now, I would like to show some of the fields on IP address table in the list of Network Adaptor table (cmdb_ci_network_adapter). 

When I open the records of cmdb_ci_network_adapter table, I should be able to see some of the columns of IP Address table. 

Is it possible? If possible, could you please guide me how this can be achieved?

Thanks for your help!

Krishna

[Michael Jones - · Accepted solution]

I believe that you can only add fields to a list view to which you can otherwise dot walk, meaning that the record in the related list needs to associate to a field on the records in the list as a reference. I don't think that you can add values from the cmdb_ci_ip_address table to the list view for cmdb_ci_network_adapter as setting the relationship does not update a reference field on the adapter, but you could add fields from the adapter table to the list view in the ip_address table as that relationship sets the "nic" field as a reference. 

To see what I mean, open the cmdb_ci_ip_address list view, right click and configure list layout. When you scroll through the available fields, you can select NIC, expand it, and then add any fields from the record to the view. 

The only way I could see you being able to do this would be to reverse the relationship, add a field to the cmdb_ci_network_adapter and set the reference there. 

[krishnakumar2]

That's what was my understanding as well. Thank you for answering. 

[Pascal Verdieu]

You could create a Database view:  https://community.servicenow.com/community?id=community_video&sys_id=6a23a5cd1bd57814a17c62c4bd4bcbd5