Skip to main content

Dear community

 

I am trying to use the Query Designer in IFS Cloud to create a list of Users and the Group they belong to, and this to facilitate our user management process.

We are using IFS Cloud 23R2 and this screenshots shows the fields I want to output to the list: User Identity, eMail and Group

I’m struggling to define this query using the Query Designer. Any help would be very much appreciated.

Thank you

 

@PGNPROXSVE you could try with the below query:

select fu.identity
        , fu.web_user Directory_ID
        , fug.user_group_id 
        , user_group_api.Get_Name(fug.user_group_id) User_Group_Name
from fnd_user fu
     LEFT JOIN Fnd_User_By_Group fug
     ON fu.identity = fug.identity

 

thank you very much @Marcel.Ausan for your answer. Your proposal requires me to have access to the IFS database. To date, I have not yet have such access, but we are in the process of obtaining it. 

Could I create this table using IFS Cloud’s Query Designer instead ?

 

@PGNPROXSVE you could simply copy/paste the code I provided in a Quick Report. Do you have access to create new Quick Reports?

Creating a quick report doesn’t require access to the DB, but you need to have the right permission in order to be able to create them.

Wonderful. It was a matter of adding the permission to Quick Reports and thx to your query, I have my listing now. Thanks a lot. You have been a great help.

@PGNPROXSVE glad I could help. Would have been useful if you would have marked my answer as solution and not yours 😁.

fair point @Marcel.Ausan , I meant to mark you answer as the right one, obviously, but I clicked the wrong one. I’m trying to figure out how to undo it, but no luck so far. I’ll reach out to the moderator.

Hello @PGNPROXSVE  I have unchecked the best answer for you. You can know select the correct one you wished to :)

Thank you both for great contributions :)

Many thanks,
Grzegorz

Reply


Terms & ConditionsCookie settings