List of users for a security role | D365FO


Introduction:
In this blog, we will see how we can get list of users who has assigned a specific security role  

Solution: 

UserInfo         userInfo;
SecurityRole     securityRole;
SecurityUserRole securityUserRole;

while select networkAlias from userInfo
        where userInfo.networkAlias
    exists join securityUserRole
        where securityUserRole.User == userInfo.id
    exists join securityRole
        where securityRole.RecId == securityUserRole.SecurityRole
        &&    securityRole.Name == 'Sales manager(NameOfTheSecurityRole)'
{
    info(userInfo.networkAlias);
}

Thanks for reading !!!



Share Story :