How do you find a catalog item from the ritm/request it created?

[tdQ1w7xO6k]

I have multiple similar catalog items and don't want to find out the slow way which one created a certain problem ticket.

[Tony Chatfield1]

Hi, unfortunately your question/requirement is a little unclear as the subject mentions ritm/request item, but the body mentions problem ticket.

Taking a look at an OOB PDI, the sc_req_item field 'Item' aka 'cat_item' provides a link to the individual catalog item that the ritm is generated from.
But looking at parent task tables like sc_request and problem I do not see a field that maps the record producer/catalog item in this manner – this makes sense to me as as parent task tables do not normally have a 1 to 1 relationship with individual catalog items.

Assuming your catalog item has a 1 to 1 relationship with your problem record?
You could simply add a reference field to problem (using sc_req_item. cat_item as a guide) and then populate this field via your record producer script.
Or if your problem is generated from a ritm, then map the ritm field 'Item' during creation of your problem.

[asifnoor · Accepted solution]

Hi,

If you open the sc_req_item.list, there is 1 field named Item, which refers to the catalog item form which your request item is created.

Mark the comment as a correct answer and also helpful if this has answered the questin.

[Gulshan Kumar1]

And how to find on sc_request table ?