Microsoft Dynamics AX (Archived)

How to get a list of companies based on specific user

(0) Share

Report

Posted on by Community Member

How to get a list of companies based on specific user ?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

What do you mean exactly?

The companies somebody has access to or the one he worked in, etc.?

Would be great if you could clarify.

Thanks,

Ludwig

Was this reply helpful? Yes No
Verified answer

Jie G on at

Like (0)

Report
Hi Gnanaprakash,

Please try following code:

UserId userId = curUserId(); CompanyInfo companyInfo; OMUserRoleOrganization oMUserRoleOrganization; container result; while select companyInfo exists join oMUserRoleOrganization where oMUserRoleOrganization.OMInternalOrganization == companyInfo.RecId && oMUserRoleOrganization.User == userId { result += [companyInfo.Name, companyInfo.DataArea]; } if (!result) { // no specific company for user --> all while select companyInfo { result += [companyInfo.Name, companyInfo.DataArea]; } }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for reply,

Yes i want the list of companies somebody has access to. How can i get that through x++ code?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ada Ding,

Does the above code supposed to get the list of companies somebody has access to?

When I am running it in a job, I am not get expected result.

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

Like (0)

Report

Hi Gnanaprakash,

If you don't have the correct result, you can also have a look at my example for restricting access to legal entities. The examples do contain some logic to determine legal entity access in general or per role. kaya-consulting.com/extensible-data-security-examples-secure-by-legal-entity

Was this reply helpful? Yes No