Skip to main content

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

Hi ​@westjan ,

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

Thanks for your answer, sorted it was just a matter of access rights.

Reply


Terms & ConditionsCookie settings