How do I generate a single score report for pending approval requests for VIP Users?

[Jerry Ong]

Hi there,

I am generating a single score reports to filter out approval requests for VIP users. I tried with the sysapproval_approver table with the following conditions, but am not able to create a related list conditions using the sys_user table.

Can anyone advise me how to get this done properly?

Thank you.

[J Siva · Accepted solution]

Hi @Jerry Ong 
You can achieve this using the below query in sysapproval_table.
The below query returns the list of approval records where the "state" is requested and the "Requested For" user is VIP user.

Regards,
Siva

[Jerry Ong]

Thank you! Managed to do this properly.