Assigning security roles to new AX user was never that easy !!!

Some time before I got a chance to write on a utility to make user role assignment a much easier....on ONE click.

For example; a new accountant joined your organization and CFO asked AX System Admin to add this new user into AX and give him/her same permissions as other accountants have in AX. Without this utility AX system Admin will open existing user roles in a seperate window and add these roles for new joined users....Is it not the time consuming activity when you have to add dozens of roles.

This utiltiy not limited to copy user roles but can copy User Groups and user Options too.

Some important methods of this utility are;

Create User lookup for FROM USER

public void fromUserLookup(FormStringControl userLookupControl)

{

    Query                   qry = new Query();

    QueryBuildDataSource    qbd;

    QueryBuildRange         qbr;

    SysTableLookup          sysTableLookup;

    Userinfo                userInfo;

    systablelookup = SysTableLookup::newParameters(tableNum(UserInfo), userLookupControl);

    SysTableLookup.addLookupfield(fieldNum(UserInfo, ID));

    SysTableLookup.addLookupfield(fieldNum(UserInfo, NetworkAlias));

    SysTableLookup.addLookupfield(fieldNum(UserInfo, Name));

    qbd = qry.addDataSource(tableNum(userInfo));

    qbd.addRange(fieldNum(UserInfo,Company)).value(curext());

    sysTableLookup.parmQuery(qry);

    sysTableLookup.performFormLookup();

}

Create User lookup for TO USER

public void toUserLookup(FormStringControl userLookupControl)

{

    Query                   qry = new Query();

    QueryBuildDataSource    qbd;

    QueryBuildRange         qbr;

    SysTableLookup          sysTableLookup;

    Userinfo                userInfo;

    systablelookup = SysTableLookup::newParameters(tableNum(UserInfo), userLookupControl);

    SysTableLookup.addLookupfield(fieldNum(UserInfo, ID));

    SysTableLookup.addLookupfield(fieldNum(UserInfo, NetworkAlias));

    SysTableLookup.addLookupfield(fieldNum(UserInfo, Name));

    qbd = qry.addDataSource(tableNum(userInfo));

    qbd.addRange(fieldNum(UserInfo,Company)).value(curext());

    qbr = qbd.addRange(fieldNum(UserInfo, Enable));

    qbr.value('1');

    sysTableLookup.parmQuery(qry);

    sysTableLookup.performFormLookup();

}

Function to copy USER ROLES

/// <summary>

/// copy roles assigned to one user to another

/// </summary>

/// <returns>

/// true; roles are copied across. false; roles failed to copied

/// </returns>

/// <remarks>

/// this method is used to copy user roles assigned to one user to another user.

/// </remarks>

private boolean copyUserRoles()

{

    boolean                 ret = true;

    SecurityRole            securityRole;

    SecurityUserRole        securityUserRole;

    SecurityUserRole        securityUserRoleExist;

    SecurityUserRole        securityUserRoleInsert;

    OMUserRoleOrganization  userRoleOrganization, userRoleOrganization_Insert;

    List                    copiedUserRoles = new List(Types::String);

    ListEnumerator          lEnumerator;

    setPrefix(strFmt("Copy user", fromUser, toUser));

    try

    {

        select securityRole where securityRole.AotName == 'SystemUser';

        delete_from securityUserRole where securityUserRole.User == toUser && securityUserRole.SecurityRole == securityRole.RecId;

       

        while select securityUserRole

                where securityUserRole.User == fromUser

            notExists join * from securityUserRoleExist

                where securityUserRoleExist.SecurityRole    == securityUserRole.SecurityRole

                    && securityUserRoleExist.User           == toUser

        {

            select securityRole where securityRole.RecId == securityUserRole.SecurityRole;

            copiedUserRoles.addStart(securityRole.Name);

            securityUserRoleInsert.initValue();

            securityUserRoleInsert.SecurityRole = securityUserRole.SecurityRole;

            securityUserRoleInsert.User         = toUser;

            securityUserRoleInsert.insert();

            securityUserRoleInsert.clear();

            while select userRoleOrganization

                    where userRoleOrganization.User == fromUser

                        && userRoleOrganization.SecurityRole == securityUserRole.SecurityRole

            {

                userRoleOrganization_Insert.initValue();

                userRoleOrganization_Insert.OMHierarchyType             = userRoleOrganization.OMHierarchyType;

                userRoleOrganization_Insert.OMInternalOrganization      = userRoleOrganization.OMInternalOrganization;

                userRoleOrganization_Insert.SecurityRole                = userRoleOrganization.SecurityRole;

                userRoleOrganization_Insert.SecurityRoleAssignmentRule  = userRoleOrganization.SecurityRoleAssignmentRule;

                userRoleOrganization_Insert.User                        = toUser;

                userRoleOrganization_Insert.insert();

                userRoleOrganization_Insert.clear();

            }

        }

    }

    catch

    {

        ret = false;

    }

    if (ret)

    {

        lEnumerator = copiedUserRoles.getEnumerator();

        if (copiedUserRoles.empty())

            info(strFmt("User %1 and %2 have already the same user role",fromUser, toUser));

        while (lEnumerator.moveNext())

        {

            info(strFmt('%1',lEnumerator.current()));

        }

    }

    else

        error(strFmt("User Roles aborted please review list"));

    return ret;

}

Function to copy USER OPTIONS

/// <summary>

/// copy options assigned to one user to another

/// </summary>

/// <returns>

/// true; options are copied across. false; options failed to copied

/// </returns>

/// <remarks>

/// this method is used to copy user's options assigned to one user to another user.

/// </remarks>

private boolean copyUserOptions()

{

    boolean                 ret = true;

    UserInfo                userInfoSource;

    UserInfo                userInfoTarget;

    SysUserInfo             sysUserInfoSource;

    SysUserInfo             sysUserInfoTarget;

    setPrefix(strFmt("Copy user options", fromUser, toUser));

    try

    {

        select userInfoSource

            where userInfoSource.id == fromUser

        join sysUserInfoSource

            where sysUserInfoSource.Id == userInfoSource.id;

        ttsBegin;

           

            select forUpdate userInfoTarget where userInfoTarget.id == toUser;

            userInfoTarget.filterByGridOnByDefault = userInfoSource.filterByGridOnByDefault;

            userInfoTarget.statuslineInfo = userInfoSource.statuslineInfo;

            userInfoTarget.update();

           

            select forUpdate sysUserInfoTarget where sysUserInfoTarget.Id == toUser;

            sysUserInfoTarget.DefaultCountryRegion = sysUserInfoSource.DefaultCountryRegion;

            sysUserInfoTarget.update();

        ttsCommit;

    }

    catch

    {

        ret = false;

    }

    if (ret)

    {

        info(strFmt("User %1 and %2 have already the same user options ", fromUser, toUser));

    }

    else

        error(strFmt("User Options aborted please review list "));

    return ret;

}

Function to copy USER GROUPS

/// <summary>

/// copy groups assigned to one user to another

/// </summary>

/// <returns>

/// true; groups are copied across. false; groups failed to copied

/// </returns>

/// <remarks>

/// this method is used to copy user groups assigned to one user to another user.

/// </remarks>

private boolean copyUserGroups()

{

    boolean                 ret = true;

    UserGroupList           userGroupList;

    UserGroupList           userGroupListExist;

    UserGroupList           userGroupListInsert;

    List                    copiedGroups = new List(Types::String);

    ListEnumerator          lEnumerator;

    setPrefix(strFmt("Copy user groups", fromUser, toUser));

    try

    {

        while select userGroupList

                where userGroupList.userId == fromUser

            notExists join * from userGroupListExist

                where userGroupListExist.groupId == userGroupList.groupId

                    && userGroupListExist.userId == toUser

        {

            copiedGroups.addStart(userGroupList.groupId);

            userGroupListInsert.initValue();

            userGroupListInsert.groupId = userGroupList.groupId;

            userGroupListInsert.userId  = toUser;

            userGroupListInsert.insert();

            userGroupListInsert.clear();

        }

    }

    catch

    {

        ret = false;

    }

    if (ret)

    {

        lEnumerator = copiedGroups.getEnumerator();

        if (copiedGroups.empty())

            info(strFmt("User %1 and %2 have already the same user Groups ",fromUser, toUser));

        while (lEnumerator.moveNext())

        {

            info(strFmt('%1',lEnumerator.current()));

        }

    }

    else

        error(strFmt("User Groups aborted please review list "));

    return ret;

}

Let's have inside into MS Dynamics AX 2012 R3

Inside MS Dynamics AX 2012 R3 is released with new features (functionally) and performance enhancement (technically).

http://blogs.msdn.com/b/microsoft_press/archive/2014/08/12/new-book-inside-microsoft-dynamics-ax-2012-r3.aspx

Collection classes in AX – What, When and How to use

Data inserting, traversing and retrieving can be done with many different ways in AX. We do have different collection classes for it and each one has its own importance and performance impact. Let’s talk about each one by one and compare it.

List

• -          are structures, contain values of any X++ type that are accessed sequentially
• -          all values must be of same X++ type (specified through baseEnum types)
• -          type is defined on creation and cannot be modified after initialization
• -          can be traversed through ListEnumerator class
• -          values can be added from both sides e.g. using addEnd() and addStart() methods 

Example 1

static void ListExample1(Args _args)

{

    List list = new List(Types::String);    // Declare and initialize List of String type

    ListEnumerator  enumerator;             // Declare ListEnumerator class to traverse list

       

    list.addEnd("Faisal");                  // Add values at End of the List

    list.addEnd("Fareed");                  // Add values at End of the List

    list.addStart("AX Developer");          // Add values at Start of the List

   

    enumerator = list.getEnumerator();      // initialize listEnumerator class object

   

    while (enumerator.moveNext())

    {

        print enumerator.current();

    }

    pause;   

} 

 Output:

Traverse from left to right

Example 2

Lists can be initialized from container too.

static void ListExample2(Args _args)

{

    Container       companyRange;               // Declare container

    List            list;                       // Declare List

    ListEnumerator  enumerator;                 // Declare ListEnumerator class to traverse list       

   

    companyRange = [curext()];                  // initialize container with current company

       // we can pass multiple values here but need to be of same  

          datatype as this is used in List in below code       

    list = con2List(companyRange);

   

    enumerator = list.getEnumerator();          // initialize listEnumerator class object

   

    while (enumerator.moveNext())

    {

        print enumerator.current();

    }

    pause;   

}

Example 3

Below code is actually an example to copy user roles from one user to another. Where I used ‘List’ to store records what roles have been moved across.

static void ListExample3(Args _args)

{

    boolean                 ret = true;

    SecurityRole            securityRole;

    SecurityUserRole        securityUserRole;

    SecurityUserRole        securityUserRoleExist;

    SecurityUserRole        securityUserRoleInsert;

    OMUserRoleOrganization  userRoleOrganization, userRoleOrganization_Insert;

    List                    copiedUserRoles = new List(Types::String);

    ListEnumerator          lEnumerator;   

    try

    {       

        while select securityUserRole

                where securityUserRole.User == fromUser

            notExists join * from securityUserRoleExist

                where securityUserRoleExist.SecurityRole    == securityUserRole.SecurityRole

                    && securityUserRoleExist.User           == toUser

        {

            select securityRole where securityRole.RecId == securityUserRole.SecurityRole;

            copiedUserRoles.addStart(securityRole.Name);

            securityUserRoleInsert.initValue();

            securityUserRoleInsert.SecurityRole = securityUserRole.SecurityRole;

            securityUserRoleInsert.User         = toUser;

            securityUserRoleInsert.insert();

            securityUserRoleInsert.clear();

            while select userRoleOrganization

                    where userRoleOrganization.User == fromUser

                        && userRoleOrganization.SecurityRole == securityUserRole.SecurityRole

            {

                userRoleOrganization_Insert.initValue();

                userRoleOrganization_Insert.OMHierarchyType             = userRoleOrganization.OMHierarchyType;

                userRoleOrganization_Insert.OMInternalOrganization      = userRoleOrganization.OMInternalOrganization;

                userRoleOrganization_Insert.SecurityRole                = userRoleOrganization.SecurityRole;

                userRoleOrganization_Insert.SecurityRoleAssignmentRule  = userRoleOrganization.SecurityRoleAssignmentRule;

                userRoleOrganization_Insert.User                        = toUser;

                userRoleOrganization_Insert.insert();

                userRoleOrganization_Insert.clear();

            }

        }

    }

    catch

    {

        ret = false;

    }

    if (ret)

    {

        lEnumerator = copiedUserRoles.getEnumerator();

        if (copiedUserRoles.empty())

            info(strFmt("User %1 and %2 already have the same user role",fromUser, toUser));

        while (lEnumerator.moveNext())

        {

            info(strFmt('%1',lEnumerator.current()));

        }

    }

    else

        error(strFmt("Aborted please review error list above"));

}

You can also have a look on this post to find difference between Iterators and Enumerators.                     

Maps

• -          can be used as a temp data store for the given scope of a process
• -          are much quicker than temp tables
• -          allows you to associate one value (the key) with another value
• -          values can be any valid X++ type

static void mapExample1(Args _args)

{

    Map             mapExample;

    MapEnumerator   mapEnumeratorExample;

    CustTable       custTable;

   

    mapExample = new Map(Types::String,Types::String);

   

    select custTable where custTable.AccountNum == "144212";

   

    mapExample.insert(CustTable.AccountNum, CustTable.name());

   

    mapEnumeratorExample = new MapEnumerator(mapExample);

   

    while (mapEnumeratorExample.moveNext())

    {

        if (!mapExample.empty())

        {           

            print mapExample.lookup(custTable.AccountNum);

        }       

    }

    pause;

}

Good information about Maps is also shared here

Containers

MSDN page describes it very best http://msdn.microsoft.com/en-us/library/aa874816.aspx

Containers can be used to get multiple values returned from any method.

Original method

private container getActualAmount()

{

    Container   amountContainer;

    container   textContainer;   

    ;

    for()

    {       

        amountContainer = conIns(amountContainer);

        textContainer   = conIns(textContainer);       

    }

    return [amountContainer, textContainer];

}

Called From

container   AmountsC = conNull();

container   TextC    = conNull();

[AmountsC, TextC]   = this.getActualAmount();

Set values to use for your logic

ExampleTable.Field1 = conPeek(AmountsC,1);

ExampleTable.Field2 = conPeek(AmountsC,2);

Important points about Containers

• They are value based structure. So no class based object stored on it.
• They are similar to linked list or array like structured.
• Their size fixed at time of declaration. When you insert update or delete any value from container, a new container is created.
• They always copied by value.
• Containers are base 1 not like array based zero.