report for requested item with no catalog task and approval

[Vijay Baokar]

Hello,

Can we have report or filter which show list of requested items which doesn't have catalog task created against and no approval?

[Community Alums]

Hi @Vijay Baokar ,

Please refer this filter approval!=approved^ORapproval=NULL on sc_req_item there is relationship of parent and child between sc_task to sc_req_item. But we don't have relationship of sc_req_item to sc_task.

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak

[Vijay Baokar]

@Community Alums Whatever you suggested i have already done that but yes looking for relation of sc_req_item to sc_task.

[CezaryBasta]

For the sc_req_item -> sc_task filter, depending on you use case, you may be able to use the related list conditions.

The approval is pretty simple and straightforward, as it exists on the sc_req_item. But again, depending on your process, you may also take approval from parent REQ record.