The purpose of today’s featured article is to show how to create automatically view out of a query object in AOT, based on the selected query. This is a very helpful enhancement that provides easy testing with queries.
Iteration through AOT elements is done by using the TreeNode class which has very useful methods for finding a specific node, creating and compiling subnodes, retrieving their children and so on… Creating a view and setting some properties through X++ code is showed below. The view is named as the query and by adding the ‘View’ suffix.
But there is one problem when it comes to a query that has many data-sources and even some of them have nested data-sources and so on… In order to solve this ‘inception’ problem, we need to iterate through all data-sources and add every field to the view. The following code example shows how to iterate recursively through the data-sources and the addFields function adds the fields to the view.
At the end, the newly created view should be compiled and a data dictionary synchronization is recommended: treeNodeView.AOTcompile(); SqlDataDictionary::synchronize();
Allow All Cookies
Third Party Embedes
Third-party cookies are cookies that are set by other websites, not this one. This website may use embedded content from other websites, such as YouTube or Google maps. Your consent is required to view content from these websites embedded on this site.