Display RITM record in Related Lists Tab for Change Request

HanisahR
Tera Contributor

Displaying the RITM records in the related lists for Requested Items tab based on chosen ritm field inside the 'Business Approval for Deployment' field inside change request.

 

Tried to configure inside business rule for when Business Approval for Deployment is not empty for the script to be run after insert of the business approval field, then check if it's empty. Query to the RITM table and associate it with which fields inside sc_req_item table. But quite having trouble since it's not appearing in the change request in requested items tab. 

Supposedly have 2 situations, when user first insert new record, another situation when user change the RITM number (update).

1 REPLY 1

pavani_paluri
Giga Guru

Hi @HanisahR ,

 

A related list just shows records that have a reference field pointing back to the current record.
If you want RITMs to appear under a Change Request, each RITM needs to have a field (e.g., u_change_request) set to the Change Request’s Sys ID.

Make sure RITMs have a field that points to the Change Request (could be change_request or a custom field like u_change_request).

Write a Business Rule on change_request:

Runs after insert and after update.

Checks if Business Approval for Deployment is filled in.

Finds that RITM record in the sc_req_item table.

Updates the RITM’s “linked Change Request” field with the current Change Request’s Sys ID.

Once the RITM’s link field is updated, the Requested Items related list on the Change Request will automatically show it.
If you change the RITM number in the Business Approval field, the script updates the link so the related list stays correct.

 

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Pavani P