Queries – NAV2013

A query is a new object in Microsoft Dynamics NAV 2013 that you use to specify a set of data from the Microsoft Dynamics NAV database. You can query the database to retrieve fields from a single table or multiple tables. You can specify how to join tables in the query. You can filter the result data. You can specify totalling methods on fields, such as sums and averages.

Bron : Mohana’s Dynamics Blog
Lees meer…

Keys, Queries, and Performance

When you write a query that searches through a subset of the records in a table, you need to be careful when you define the keys both in the table and in the query so that Microsoft Dynamics NAV can quickly identify this subset. For example, the entries for a specific customer will usually be a small subset of a table containing entries for all the customers.

Bron : MSDN
Lees meer…