List of users for a security role | D365FO - CloudFronts
cloud fronts new logo
Data-Ready Blueprint
cloud fronts new logo
Data - Ready BluePrint

List of users for a security role | D365FO

Posted On April 8, 2020 by Jagdish Solanki Posted in 

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 !!!


Related posts:

Sales Manager dashboard in Dynamics 365 Sales. The top row holds two Goal Progress charts, one for signed contracts and one for new contract revenue, each plotting Target, Actual and In-progress per salesperson. The middle row holds three bar charts built on Opportunity, grouped by owner. The bottom row holds a grid of team goals and a list of open opportunities.

Every Target Traced to a Deal: Dynamics 365 Sales Visibility for an Australian Commercial Laundry Pr...

Production Journal showing Consumption Quantity 0 on every RM/PM line

Why Is Consumption Quantity Showing Zero in Dynamics 365 Business Central? A Pharma Manufacturing Ca...

Portal sign-in page with a card titled Sign In to Customer Portal, a generic portal logo and a single Microsoft Entra ID sign-in button

How We Built a Role-Based Customer Portal in Microsoft Power Pages for a US-Based IT Services Provid...

Project Dashboard Overview tab. The top bar shows tabs for My Projects, Overview, Projects, Resources, Trends and Documents, and buttons for Copy, CSV and PDF. Below are KPI tiles for budget 300 hours, consumed 167 hours and 55.7 percent utilization, a donut chart, a portfolio health bar and a monthly hours chart.

From Scattered Reports to One Click: A Client-Ready Project Report Inside Dynamics 365


Share Story :

SEARCH BLOGS :

FOLLOW CLOUDFRONTS BLOG :


Categories

Secured By miniOrange