Approval

[Abhisheks144151]

sc_req_item) and a related child table (u_approvals) that stores custom approval data.
The related list is visible on the form, but I want to show fields like u_approval_status from the child table in the sc_req_item list view.
There’s no reference field from sc_req_item pointing to u_approvals. Is there a way to achieve this?

[Mark Manders]

If there is no direct relation so you can dotwalk, you can only show fields from another table by creating a database view.

[Ankur Bawiskar]

@Abhisheks144151 

not possible then.

Why did you create custom approval table? what's your business requirement?

Also how RITM is related to this table?

Did you create defined relationship between those 2 tables and there is nothing in common?

If yes then are you using sysapproval_approver table in that relationship script?

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

[nityabans27 · Accepted solution]

Hi, I faced a similar problem. 
You cannot directly show fields from a child table (like u_approvals) on the parent table’s list view (e.g., sc_req_item) unless there is a reference field to enable dot-walking.

In your case, since sc_req_item has no reference to u_approvals, dot-walking isn’t an option.

 Alternatives:

• Create a Database View joining sc_req_item and u_approvals using a common key (like request_item).

• Use a before Business Rule or calculated field to populate a field on sc_req_item with relevant info from u_approvals.

• Consider creating a report or dashboard based on the joined data instead of showing it on the list view.

Without a direct reference, this type of cross-table list customization isn’t natively supported.

If you think my answer is helpful, please accept it as a solution and mark helpful.

Thanks and regards
Nitya Bansal