Report based on Request and Requested Items

[BuddhikaN]

Hi All,

I'm struggling to create a report based on Request and Requested Items in SNOW and would you be able to help me with this please? 

In my scenario one Request has two connected Requested Items.  So I want to create a report to show no of Requests where the connected two Requested Items are in Completed stage. 

Is this possible? 

Thanks 

[BuddhikaN]

Hi @Sujatha V M 

Additionally, in my case I have two Requested Items under one Request, and I need to create a report to show number of requests where one Requested Item is in Completed status and the other Requested Item is in Order Fulfillment stage. May I know is it possible? 

Thanks 

[AndersBGS]

Hi @BuddhikaN ,

Just create a report based on the sc_req_item table. Here you can also dot-walk / see the original request.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[BuddhikaN]

Hi @AndersBGS 

Many thanks for the information. However, under the sc_req_item table I cannot see a filter for Stage or Status. So may I know how can I use either Requested Item Stage or Status for filtration? 

Thanks