Skip to main content
Solved

Filter Approvals to current user in Cloud

  • November 6, 2025
  • 3 replies
  • 36 views
T
Hero (Customer)
Forum|alt.badge.img+10

Is it possible to do a search like this in Cloud to limit approvals to those the current user can approve?

 

where (PERSON_ID = '#PERSON_ID#' OR &AO.Document_Group_Members_API.User_Member_Of_Group(GROUP_ID, '#PERSON_ID#') = 'TRUE')

 

We have approvals attached to areas other than Document Management and I would like to make a lobby element for users that will show them those other approvals.

Best answer by Abdul

Hi ​@TosohLBlum and ​@matt.watters,

I tried to configure and seems did it successfully. 

Can you please try to replicate and check whether it’s working as expected.

  1. Created a SQL type lobby datasource with following where condition.

PERSON_ID = FND_SESSION_API.GET_FND_USER OR DOCUMENT_GROUP_MEMBERS_API.Is_Loggedin_User_A_Memeber(GROUP_ID) = 'TRUE'

  1. Created a counter type Lobby element where I used navigation for Approvals screen with Datasource condition.

Hope this helps.

 

Regards

Abdul Rehman

    3 replies

    matt.watters
    Ultimate Hero (Partner)
    Forum|alt.badge.img+26
    • matt.watters
    • Ultimate Hero (Partner)
    • 699 replies
    • November 7, 2025

    ​@TosohLBlum I created a similar post for this and have received no responses yet.

     

    If a response resolves your issue, please use "Best Answer" so that the thread can be closed and others can find solutions more easily. Regards - Matt
    Abdul
    Superhero (Partner)
    Forum|alt.badge.img+20
    • Abdul
    • Superhero (Partner)
    • 542 replies
    • Answer
    • November 7, 2025

    Hi ​@TosohLBlum and ​@matt.watters,

    I tried to configure and seems did it successfully. 

    Can you please try to replicate and check whether it’s working as expected.

    1. Created a SQL type lobby datasource with following where condition.

    PERSON_ID = FND_SESSION_API.GET_FND_USER OR DOCUMENT_GROUP_MEMBERS_API.Is_Loggedin_User_A_Memeber(GROUP_ID) = 'TRUE'

    1. Created a counter type Lobby element where I used navigation for Approvals screen with Datasource condition.

    Hope this helps.

     

    Regards

    Abdul Rehman

    https://www.linkedin.com/in/abdul-rehman-ifscloudexpert/
    MikeCH
    Hero (Employee)
    Forum|alt.badge.img+13
    • MikeCH
    • Hero (Employee)
    • 166 replies
    • November 7, 2025

    Can't it also be solved using the page parameters, as in the lobby standard (e.g. here in the non-conformance report)?


     

     


    Terms & ConditionsCookie settingsAccessibility statement