Get data of all companies from CompanyInfo table

(1) Share

Report

Posted on by Evi

Hello everybody,

I need to select data from all companies in CompanyInfo table through x++, ax 2012.

So what I basically need to do is a select crosscompany for CompanyInfoTable, based on a specific field.

For example, I have added FieldA(NoYesID - EDT) on CompanyInfo table.

I have written this query, but it doesn't show the data if the FieldA is checked for another company different from the current company.

CompanyInfo companyInfo;

;

select firstonly crossCompany companyInfo

where companyInfo.FieldA == NoYes::Yes.

Is there any way to write this query or a similiar one in x++?

Thanks in advance.

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

Please tell us more about your problem. It's not clear to me what you mean by "it doesn't show the data if the FieldA is checked for another company different from the current company".

Note that your requirement was to get all companies matching some criteria, but your code returns a single company (because you've used the firstOnly keyword).

Was this reply helpful? Yes No
Suggested answer

Mohit Khandelwal 2 on at

Like (0)

Report
Though your requirement isn't entirely clear, based on your query, I believe you need to enclose the "while select" statement within a changeCompany loop like this:

while select dataArea where !DataArea.isVirtual { changeCompany(dataArea.dataAreaId) { while select * from companyInfo { ... } } }

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

Like (0)

Report

Using a single cross-company query is more efficient than running a separate query for every company. You don't need changeCompany just to fetch records; you have crossCompany for this purpose.

Was this reply helpful? Yes No
Verified answer

Anton Venter 20,346 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

Like Martin mentioned, I think your issue is the "firstOnly" keyword which selects the first record only. In addition, you don't have to use the crossCompany keyword in this case because the data is shared between all companies/legal entities anyway.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Get data of all companies from CompanyInfo table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Get data of all companies from CompanyInfo table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates