Hi,
in APPS10 when you filter approval steps in “Document Management - Approvals” users see all the approvals steps not only for them.
I found out SQL select, that returns only steps that are for particular user:
select * from APPROVAL_CURRENT_STEP
where (PERSON_ID = '#PERSON_ID#' OR &AO.Document_Group_Members_API.User_Member_Of_Group(GROUP_ID, '#PERSON_ID#') = 'TRUE')
but when I copy it to IFS, it gives me error:
Any suggestions??
Thanks
Jan
Best answer by Pilar Franco
Hi
I executed the query in a Core App10 environment with the last Update and it’s working as expected:
Then, you will need to debug in your case why such query is giving error to you.
On the other side, if you are not using approval groups, you can simply filter by Approver with your user id and save such query, as suggested in the other post where you found the query.
Regards,
Pilar
Hi
I executed the query in a Core App10 environment with the last Update and it’s working as expected:
Then, you will need to debug in your case why such query is giving error to you.
On the other side, if you are not using approval groups, you can simply filter by Approver with your user id and save such query, as suggested in the other post where you found the query.
Regards,
Pilar
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
