Hi,
My table is using the GetUsers aggregate. I want my table to have another column that displays on the screen the name of each apprentice's manager (name of the AdminId).
How do I do this? Can someone please advise?
Kind regards,
Shaan
Hi Shaan,
You can do this very easily with a simple aggregate:
You add the ApprenticeManagers with the User table twice, one with the ApprenticeId (to get the details of the apprentice user) and one with the AdminId (to get the details of the admin user).
Notice I changed the name of the source from the User_2 the platform names automatically when you add the User table for the second time, to User_Admin to facilitate the distinction.
Then it's just a matter of placing the table on the screen and displaying the name of the right User or UserAdmin joined tables.
Kind Regards,João
Hi João,
To display the name of the admin what would the expression be?
The expression should be the <Name of the query>.List.Current.<Name of the table, in my case User_Admin>.Name.
So taken the example of the query before, it would be like in the image below: