Query is the name of a new Dynamics NAV application object 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.
Queries are the ninth object type in Dynamics NAV, although only seven are available in Dynamics NAV 2013, now that forms and dataports are gone.
There are many things about queries in Dynamics NAV that will make you just love them:
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...