Extract RITM details from the request number

[Evan2]

Hi All,

I want to extract RITM details for the corresponding request numbers for all requests all at a time. I have tried to apply the filter like below screenshot but while personalizing list columns I am not able to find RITM related field.

Please help.

Regards,

Evan  

[Ankur Bawiskar]

Hi Evan,

why not have the details/report on RITM table and then use dot walk to number field and then select the fields from Request?

screenshot below; click on request + icon and select the request fields in the report

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Jaspal Singh]

Hi Evan,

This would not work as REQ extends Task table & so does RITM & thus does not exists any parent-child relation. Also, it is not possible to get in details for Child from Parent but vice-versa is possible. So, instead of reporting on Request(sc_request) table report on RITM (sc_req_item) table  as there exists a field Request that is a reference field available OOB & can be leveraged to configure the List Layout as required.

If there is a need to use REQ table itself there a reference of RITM has to be present on the REQ table for a dot walk.

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.

[PriyaRanji]

Hi Evan,

You can navigate to sc_req_item.LIST and filter with the request (REQXXXXX) where you get the corresponding RITM that are associate with the REQ. Hope it helps! Let us know if you still not getting it 🙂

Thanks,

Priyanka R