how to make column in the related list of the form show on the main table list

VarisaraV
Tera Contributor

On sc_req_item form, there is a related list showing XXX table (showing at the bottom of the form). I want to make columns in related list (columns from XXX table) appear on the sc_req_item table list. Please advise how to achieve it.

Note: There is no field on sc_req_item that references to XXX table.

6 REPLIES 6

Ankur Bawiskar
Tera Patron
Tera Patron

@VarisaraV 

not possible unless you have a field on RITM table which refers to XXX table.

If you have that field then you can dot walk using that reference field and show columns from XXX table on RITM list.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@VarisaraV 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

nityabans27
Mega Guru

To show columns from a related list table (XXX table) on the sc_req_item list view, you need to use a dot-walked reference field. Here’s how to do it:


Solution: Use Dot-Walking in List Layout

  1. Go to sc_req_item > All.

  2. Click the gear icon (List Layout) in the top-left of the list view.

  3. In the Available Fields section:

    • Look for the reference field pointing to the XXX table (the one linking sc_req_item to XXX).

    • Expand it (dot-walk) to see all fields from XXX.

  4. Select the fields you want and move them to the Selected Fields list.

  5. Click Save.

This will display fields from the related XXX record on the sc_req_item list view.


⚠️ Note:

  • This only works if the relationship is via a reference field from sc_req_item to XXX (or vice versa).

  • If it's a one-to-many (like related list from child table), you’ll need a scripted field, calculated field, or database view if you want to flatten that into the list.

 

@nityabans27 
thank you for your answer.
There is no field on sc_req_item that references to XXX table. 
How do I do?