Report based on Request and two 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 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 

[Amit Verma]

Hi @BuddhikaN 

You can create a report on sc_req_item table and group on the Request field. Please refer below screenshots :

Thanks and Regards

Amit Verma

[BuddhikaN]

Hi @Amit Verma,

Many thanks for the above information. However, even with the above can we get the requests where one attached Requested Item is in Completed status and the other Requested Item is in Order Fulfillment stage?

As per my understanding, we can't filter based on two statues of two requested items which are attached to the same request. Isn't it? 

Thanks 

[Amit Verma]

@BuddhikaN 

You can try applying filters as below :

Thanks and Regards

Amit Verma

[BuddhikaN]

Hi @Amit Verma,

Thanks again and let me further clarify my requirement. 

I have number of Requests where each Request contains two Requested Items with different names (Ex: One item as ABC and other item as XYZ)

Now I need to build a report to find number of Requests where ABC item is in Completed stage and XYZ item is in Order Fulfillment stage. 

So is that possible with your suggestion? 

Thanks