Remove pending alerts for exited employees in bulk through backend query.
Client needs to remove the alerts which are pending with managers and POC's and this data is more than 2 years old, The alerts are especially to be removed for terminated employees. Manually identing the records and deleting will not be a feasible option hence will require a query to check pending/awaiting approval transaction of terminated employees and to withdraw them.
Please let us know if there are query which can built or used.
Thanks & Regards
Abhilash Anand
0