Retrieves records from one or more tables and combines the records into rows and columns in a single dataset. You create queries in the development environment with Query Designer.
To open this window, on the Tools menu, choose Object Designer, choose Query, and then choose the Design button. Choose the New button instead of the Design button to design a new query.
In Query Designer, tables are specified by data items. You combine tables by linking the data items in Query Designer. In most cases, the tables are combined based on a relationship between certain fields in the tables. Microsoft Dynamics NAV includes different types of data item links that you can use to limit the records that are included in the resulting dataset by how the fields in data item tables are related to each other.
Fields
| Field | Description |
|---|---|
Expanded | Expands and collapses all indented hierarchy. This includes child data items and columns. |
Type | Specifies the type of data to include in the dataset. You can choose one of the following types of data:
|
Data Source | Specifies the table to retrieve the dataset from. |
Name | Specifies the name of the data item, column, or filter element. |
Method Type | Specifies the date or totals type method on the query column. For more information, see MethodType Property. |
Method | Specifies either a date method for retrieving the year, month, or day from a Date field or a totals method for performing calculations on field values. For more information, see Method Property. |
Group By | Specifies that records are grouped by this column. You cannot change the contents of this field. It is automatically calculated from the defined columns. All columns where Method Type is not Totals are used for grouping. |