Software (include version): DocStar (any version), SQL (any version)


Use Case: The customer requested a list of users in a specific group in DocStar


Customer: International Forest Products (IFP)


Prerequisites: N/A


Instructions:

  1. SELECT * FROM [AAAA0001].[dbo].[Role] ORDER BY [Name] 

  2. Copy the Id of the Group you would like to filter by 

  3. SELECT u.[Username] FROM [Astria_Host].[dbo].[User] u INNER JOIN AAAA0001.dbo.RoleMembership rm ON u.[Id] = rm.[UserId] WHERE rm.RoleId = 'Paste Id copied from the Role table' ORDER BY u.[Username]


Helpful Links: N/A