How to Identify the current user group for the current user logon to AX using X++ and populate that group on Form.

(0) Share

Report

Posted on by Bashir Ahmad

5,248

Hi,

I need to get current logged in user group and need to populate that user group in all over the forms by placing the label or link.

i am able to get the user group with following code. please correct the following code also suggest how do i populate group, when ever user access the form i need to place link or label on each form and that will populate the current user group.

public static client void main(Args _args)
{
    UserGroupList groups;
    UserInfo userInfo;
      select * from userInfo where userInfo.id == curuserid();

    info(strfmt("You have login by this %1 user id and alias name is %2",curuserid(),userInfo.networkAlias));

    info("You belong to  following user groups");

   while select groups where groups.userId == curuserid()

    {

        info(groups.groupId);
        info(curuserid());

    }
      //info(curuserid());

}

Please Help ASAP

*This post is locked for comments

I have the same question (0)

All responses (22)

Answers (2)

Martin Dráb 236,519 Most Valuable Professional on at

Like (0)

Report

RE: How to Identify the current user group for the current user logon to AX using X++ and populate that group on Form.

You tagged the question with "AX 2012", but UserGroupList table doesn't exist in AX 2012, therefore your code wouldn't even compile. Something from what you wrote is not correct - please fix it.

If you really can use UserGroupList, you see that the user may be assigned to many groups. If you want to use a single group ID, you need to decide which one to use.

Where do you want to populate the group ID? If to a field, just use table.Field = groupId. If it should go to an unbound control, use something like stringControl.text(groupId).

Was this reply helpful? Yes No
Bashir Ahmad 5,248 on at

Like (0)

Report

RE: How to Identify the current user group for the current user logon to AX using X++ and populate that group on Form.

Thanks Martin,

Yes you are right the following code is returning Null.

following code is not working but i am not getting any compilation error.

while select groups where groups.userId == curuserid()

{

info(groups.groupId);

}

can you please suggest the exact table name, also i am working with AX2012 R2

Was this reply helpful? Yes No
André Arnaud de Cal... 299,509 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to Identify the current user group for the current user logon to AX using X++ and populate that group on Form.

Hi Bashir,

Are you upgrading an environment from AX4 or AX2009? The security is different in AX 2012. What is the exact business requirement?

Roles assigned to a user can be found in the table SecurityUserRole.

The functionality for user groups is still available in AX 2012, but this is only used at Journals for approval and indicating which users are allowed to post in certain ledger periods. So the table UserGroupList does still exists, but I wonder if you need this table or another one.

Was this reply helpful? Yes No
Bashir Ahmad 5,248 on at

Like (0)

Report

RE: How to Identify the current user group for the current user logon to AX using X++ and populate that group on Form.

let me correct the question, Actually i need to get The current user Active Directory Group.

the user belongs to group in a domain.

Was this reply helpful? Yes No
Martin Dráb 236,519 Most Valuable Professional on at

Like (1)

Report

RE: How to Identify the current user group for the current user logon to AX using X++ and populate that group on Form.

Ah, my mistake. There is no system table UserGroupList in AX 2012, as it used to exist in older versions - it's now considered deleted and it's been turned to DEL_UserGroupList table. But there is a new application table UserGroupList (in AOT among normal tables, not system tables).

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 236,519 Most Valuable Professional on at

Like (1)

Report

RE: How to Identify the current user group for the current user logon to AX using X++ and populate that group on Form.

You won't find information about AD groups in AX database, so stop looking there. But there is a solution, of course. You can use .NET types in namespace System.DirectoryServices.AccountManagement to query Active Directory, and you can use these types in X++ through .NET Interop.

UserPrincipal.GetAuthorizationGroups() looks like what you need.

Let me know if you get into troubles; I work quite a lot with .NET Interop.

Was this reply helpful? Yes No
Ali Zaidi 4,655 on at

Like (0)

Report

RE: How to Identify the current user group for the current user logon to AX using X++ and populate that group on Form.

You have to add following code in initial method of form. UserGroupList exists in Dynamics Ax 2012 R2 Cu7. But this table did not show you active directory group of user.

public void init()

{

UserGroupList groups;

UserInfo userInfo;

super();

select * from userInfo where userInfo.id == curuserid();

select groups where groups.userId == curuserid();

if (groups !=null)

{

lblUserGroup.text(groups.groupId);

}

}

Was this reply helpful? Yes No
Bashir Ahmad 5,248 on at

Like (0)

Report

RE: How to Identify the current user group for the current user logon to AX using X++ and populate that group on Form.

Thanks Martin,

Yes exactly i am looking for group that user is authorized in Active directory.

can you please share any code example by using System.DirectoryServices.AccountManagement to get the AD User group in X++

Thanks

Bashir Ahmad

Was this reply helpful? Yes No
Bashir Ahmad 5,248 on at

Like (0)

Report

RE: How to Identify the current user group for the current user logon to AX using X++ and populate that group on Form.

Ali,

I have tried this code as i have mentioned in question. no data return in following query.

select * from userInfo where userInfo.id == curuserid();

select groups where groups.userId == curuserid();

Was this reply helpful? Yes No
Verified answer

Jonathan Halland 11,310 on at

Like (1)

Report

RE: How to Identify the current user group for the current user logon to AX using X++ and populate that group on Form.

Hi Bashir,

Please view this article I wrote for this exact purpose

www.exploreax.com/.../active-directory-lookup-in-ax-2012

Was this reply helpful? Yes No