Query to view the requests in Pending by Action for specific user

[Legacy User]

Dear All,

 

Can someone help me with the below query.

 

I want to view all the requests pending for action by an user.

 

What is the backend I should use for it?

[Jon_Israel]

Hi Divya,

When you say a query are you looking to add something to a scoreboard or are you running something in SQL itself?  Additionally, you would need to also need to define what classifies as a pending action for a user.  In other words, what are the actions that you are looking for, and what determines if its pending for a user?

Thanks,

Jon I.

[Jason_Wolfe]

Hi Divya!

 

You can leverage the following to return the Catalog requests with a pending action for a user:

 

select distinct request_id from usm_request_pending_action where status in (1,5) and ( ( user_id = 'spadmin' ) or ( group_id in ( 'test group' ,'test group 2') ) )

 

If you are not interested in pending actions assigned to group(s) the user is part of you can remove that part of the condition, otherwise you can specify a particular group(s) or all groups as included in the 'User Group Membership' section of the user's profile in the Catalog UI.

 

Thanks,
Jason

[Legacy User]

This helps, Jason