You can create a cross-company query by using X++ code. There are two ways to do this: crossCompany keyword on the select statementQuery class methods A cross-company query can also be created under the Query node in the Application Object Tree (AOT). A cross-company query cannot return data for companies that the user does not … Continua a leggere AX – D365FO – Cross-Company in Select statement in X++ and AOT
Categoria: select statement
D365FO – AX – Order By in Select Statements
SalesTable salesTable; select salesTable index hint CustIdx order by CustAccount where salesTable.CustAccount >= '3000' && salesTable.CustAccount <= '4000' && salesTable.FixedDueDate >= 12\12\2004 && salesTable.FixedDueDate <= 05\05\2009;
