core/Members availability

LabKey Support Forum (Inactive)
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