Microsoft Dynamics AX (Archived)

how to display the legal entity of user's role?

(0) Share

Report

Posted on by BASMA

920

I create first a grid that displays the list of user.

I create second grid thats displays the list of roles of the selected user.

Now, in other tab I displayed if the role is active for all the organizations or have access to specific organizations:

0458.access.png

If the radioButton "Grant access to specific organizations individually" is selected , I want when I clicked on "next" I get the names of organizations where the selected role is active.

I added the OMUserRoleOrganization as dataSource , in the method executeQuery() I set this code:

public void executeQuery()
{
SysQuery::findOrCreateRange(this.query().dataSourceTable(tablenum(OMUserRoleOrganization)), fieldnum(OMUserRoleOrganization, User)).value(queryValue(UserInfo.id));
SysQuery::findOrCreateRange(this.query().dataSourceTable(tablenum(OMUserRoleOrganization)), fieldnum(OMUserRoleOrganization, SecurityRole)).value(queryValue(SecurityRole.RecId));

super();
}

Then I added OMInternalOrganization as datasource, in the method executeQuery() I set this code:

public void executeQuery()
{
SysQuery::findOrCreateRange(this.query().dataSourceTable(tablenum(OMInternalOrganization)), fieldnum(OMInternalOrganization, RecId)).value(queryValue(OMUserRoleOrganization.OMInternalOrganization));
super();
}

I called these methods in clicked Button, but I didn't get values.

I want to know how to link the userInfo, SecurityRole, OMUserRoleOrganization and OMInternalOrganization to get the names of organizations??

*This post is locked for comments

All responses (11)

Answers (1)

André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

RE: how to display the legal entity of user's role?

Thanks. This would indeed prevent creating new records and now your error from above is not coming anymore. I have marked your own answer as verified.
Verified answer

BASMA 920 on at

Like (0)

Report

RE: how to display the legal entity of user's role?

Hi, André,
André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

RE: how to display the legal entity of user's role?

Hi Basma,

Thanks. Glad you solved it, but what exact property are you referring to?
BASMA 920 on at

Like (0)

Report

RE: how to display the legal entity of user's role?

Hi André,

it works now,

juste I changed the property of omUserRoleOrganization.
André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

RE: how to display the legal entity of user's role?

The fact-box on the user details form is also a form. You can find it based on menu items used in the fact-box section of the form design. Please let us know if you are able to reverse engineer it now.
BASMA 920 on at

Like (0)

Report

RE: how to display the legal entity of user's role?

I need it in a new form, beacause there are some other tasks related to it.

in the list of user in form, I didn't know the source of dialogBox
Suggested answer

André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

RE: how to display the legal entity of user's role?

Hi Basma,

This is already standard available. You can go to the users list page. Then open the details for one user. You can click a role. At the right side, there is a space for factboxes. Out of the box, one fact box will then show the list of organizations. If you need to present it a bit different, then use the example for the exact queries and coding.
BASMA 920 on at

Like (0)

Report

RE: how to display the legal entity of user's role?

The purpose of this task is :

1. choice of user from grid

2.display the list of roles assigned to this user.

3.When I selected role and clicked next , I get the names of organizations where the role is active.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: how to display the legal entity of user's role?

Hi Basma,

What is the purpose of this adjustment? What do you want to achieve at the end of the day?

Would be great if you could explain.

Many thanks

Ludwig
BASMA 920 on at

Like (0)

Report

RE: how to display the legal entity of user's role?

I add OMUserRoleOrganization as datasource:

then I add OMINternalOrganization : i link it with OMUserRoleOrganization :

Now I get the correct organizations but when I open form I get this dialogBox:

I didn't understand it ?