What is a query?
Query is the name of a Dynamics NAV application object that was first introduced in Microsoft Dynamics NAV 2013. This application object is only meant to retrieve data from the database. It is a read-only object. It cannot modify, delete, or insert new data into the database.
There are many things about queries in Dynamics NAV that point to the future of our reporting world:
- They allow us to retrieve data from multiple tables at the same time
- They allow us to retrieve only specific fields in a table
- They allow us to group the retrieved data according to certain fields without the need of any explicit key for them
- They allow us to total the retrieved data using different totaling methods (sum, count, average, min, and max)
If you are a Dynamics NAV programmer and you have worked with the previous versions of Dynamics NAV, you will see the advantages and the possibilities of this new object right away. The Query object makes the summarizing of data much easier without...
