Creating a related list for a requested item,

[HenryD]

Hello I wanted to make a related list and ive done a relationship that is set to apply on the requested item & queries from the catalog task table. Right now i have the "Catalog Tasks->Request" related list in my requested item as i need this but im trying to add another one named "Delivery plan status" in there as well. 

Ive attached the screenshot, is there any code needed for this or anyone have experience with something like this, any help is appreciated

[kchorny]

I think your query would be current.addQuery('request_item',parent.sys_id);

Then once you've added the Related List, you would use Configure List Layout and add the Delivery plan > Status field to it. 

[shloke04]

Hi,

Relationship which you are looking for can be simply achieved by adding the Delivery Plan field in the existing Catalog task List view which is available on the Requested Item Related List as shown below:

I don't think you need to create a new Relationship for this as you are just trying to show Delivery Plan which is available on catalog task on the Requested Item record.

1) Right click on the List layout of Catalog task which is available as a Related List on RITM form as shown below:

Now search for Delivery Plan field and add it to the Right side of the slush bucket as shown below:

Result:

Please let me know if I have misunderstood your requirement here and can assist you further.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[HenryD]

hello thank you for the input, your comments were helpful i just needed to add code within a new relationship from Reqested item to catalog tasks and was able to get it working. ill provide the answer above, somebody else had commented what the right answer was but i think deleted it

[HenryD · Accepted solution]

The code i added to the relationship was 

current.addQuery('request_item',parent.sys_id);

somebody provided me this answer within the community but deleted it or i cannot see it anymore.