Reporting and Dashboards

[ratnasekhar]

Hi,

I’m working on creating a dashboard report for my manager that shows all requests currently pending his approval. I’m using the "sysapproval_approver" table with the following filters:

• Approver = [Manager's Name]

• State = Requested

This table includes two types of records: Requested Items and SC Tasks.

For Requested Items, I was able to retrieve the “Requested For” field using the reference:
Approval for → Requested Item → Requested For.

However, I’m unable to find a similar way to retrieve the “Requested For” field for SC Tasks.

Could you please advise how I can fetch the “Requested For” value for SC Tasks?
Or alternatively, is there a better way to achieve this requirement?

Goal:
My manager needs a list view of all requests pending his approval, along with the Requested For information, so he can review and approve them all in one place.

Any guidance would be appreciated.

Thanks!

Ratna

[Mohammad Danis1]

Hi @ratnasekhar ,

There is no OOB field as "Requested For" in SC Task table, that's the reason you don't see it.
If you see "Requested For" field in list view of SC Task that field is a dot-walked field from Request Item Table.

------------------------------------ | Was my response helpful? | ------------------------------------
⬇️Dropping a Kudos or Accepting as solution ✅ ↘️ would be absolutely brill ⭐ Cheers!
Regards,
Mohammad Danish

[Mohammad Danis1]

Hi @ratnasekhar ,

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Mohammad Danish

[Astik Thombare]

Hi @ratnasekhar,

You can access the Requested For field from the SC Task using dot-walking as follows:

Approval For → Requested Item → Requested For

This works because the SC Task record has a reference to the Requested Item, which in turn references the Requested For user.

Please refer to the image below for more clarity.

If my answer helped you, please consider marking it as ✅ Correct and giving it a 👍 Helpful — it might help other members in the community too!

Thanks,
Astik T 😊💡

[AndersBGS]

Hi @ratnasekhar ,

 so according to your explanation, you have approvals for sc_tasks - is that correct understood?