stoneridgesoftware: Creating Cross Company Select Statements in X++

[Blog bot]

Источник: https://stoneridgesoftware.com/creat...atements-in-x/
==============

When creating a query in X++ by default that query will only return the values in the company that you are logged into.  If you desire to pull from multiple companies, you will need to use the crosscompany keyword.

CustTable custTable;while select crossCompany custTable {print custTable.accountNum; } pause;The above code section will print the account numbers for each row in the CustTable and will include data from all companies.

If you would like to restrict the companies that you want data from you can also define a container that will define which companies to search.

container desiredCompanies = ['Company1', 'Company2']; CustTable custTable; while select crossCompany : desiredCompanies custTable { print custTable.accountNum; } pause;The above code section will print the account numbers for each row in the CustTable for the two companies that we specified in the container.



Источник: https://stoneridgesoftware.com/creat...atements-in-x/