search requests by approver id returns only pending requests

[Former Member]

Hi experts,

The option Search Request in GRC-AC, when is used to search using the criteria “Approver ID”, returns only the requests pending for the approver, and don´t show the requests already closed.

There´s any note or sp to solve this problem, or this is the standard behavior?

Regards,

Gabriel Aquino

[Monsores · Accepted solution]

Hello, Gabriel.

   We also didn't find a standard solution for this yet, but as a workaround to know the approvers which took decisions in a request workflow, we query two tables:

1. In GRFNMWRTINST we get the INSTANCE_ID of the request by putting its number in the EXTERNAL_KEY_DIS field.

2. Filtering GRFNMWRTDATLG with this INSTANCE_ID, you will have a list of the request paths and the decisions already taken in each of them, together with the responsibles.

Although not the best solution, I hope it helps.

Regards,

Marcelo Monsores

[Former Member · Accepted solution]

Hi Monsores,

It´ll help us a lot. Thanks.