core/Members availability | Jon (LabKey DevOps) | 2015-04-08 15:30 |
Status: Closed | ||
Hi Martin, If the goal is to get groups of a selected user and obtain the userIds of the groups, you should be able to still do this from core/Users. The field that will give you the group ID numbers is called 'Groups/UserId'. If you go into your Users table and customize the view, then click on the + next to Groups, you should see a bunch of sub-options under it that it's pulling from the Groups table via a lookup. If you select UserId and then view the grid, you'll see your group ID numbers and if you decide to export the view into JavaScript, you'll see the column called 'Groups/UserId'. -------------- LABKEY.Query.selectRows({ requiredVersion: 9.1, schemaName: 'core', queryName: 'Users', columns: 'UserId,DisplayName,Email,Active,LastLogin,Created,FirstName,LastName,Phone,Mobile,Groups,Groups/UserId', filterArray: null, success: onSuccess, failure: onError }); -------------- This will appear for anyone regardless of permissions. Will that work for you? Regards, Jon |
||