Skip to main content
Solved

Query returning list of IFS Cloud users and their group


Forum|alt.badge.img+7

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

 

Best answer by Marcel.Ausan

@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.

View original
Did this topic help you find an answer to your question?

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • May 30, 2024

@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

 


Forum|alt.badge.img+7
  • Sidekick (Customer)
  • May 31, 2024

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 ?

 


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • May 31, 2024

@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.


Forum|alt.badge.img+7
  • Sidekick (Customer)
  • May 31, 2024

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.


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • May 31, 2024

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


Forum|alt.badge.img+7
  • Sidekick (Customer)
  • May 31, 2024

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.


Grzegorz Byrski
Hero (Employee)
Forum|alt.badge.img+9

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings