Trying to get a report from the request item showing approval status and tasks

[AN2023]

Hi there,

I'm trying to create a report that shows the request item [sc_req_item] that are waiting to be approved (with their approval status) and all tasks [sc_tasks] that are created for request items that are already approved.

Example: 

 - REQ1 has 2 RITMs

 - RITM1 is approved and has catalog tasks

 - RITM2 is waiting for approval and has no catalog tasks

Note:  I've already got many reports starting from the sc_task table but I need the RITMs that are in approval status have no catalog tasks yet

Hoping for some inspiration. 🙂

Thanks, Audrey

[HIROSHI SATOH]

Can you provide an image of the report?

[Jitendra Diwak1]

Hi @AN2023,

for this, you need to create the Database View bcz you want to combine more than 2 tables. Please refer my accepted resolution below:

https://www.servicenow.com/community/developer-forum/how-to-join-sc-task-task-sla-and-sc-req-item-ta...

Let me know if you are able to achieve this by this.

Please accept my solution if it works for you and thumps up.

Thanks

Jitendra

[AndersBGS]

Hi @AN2023 ,

You need a database view to obtain this view, as you can dot-walk from approval to RITM or from sc_task to RITM, but not all tree table is possible without database view.

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

Best regards

Anders