Query is the name of a Microsoft Dynamics NAV or Microsoft Dynamics 365 Business Central 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 Microsoft Dynamics NAV and in Microsoft Dynamics 365 Business Central 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, minimum, and maximum)
If you are a Microsoft Dynamics NAV or Microsoft Dynamics 365 Business Central developer, and you have worked with the previous versions of Microsoft...