Using a query to extract data

Microsoft Dynamics NAV 2013 introduced a new object type called query. We can use a query to retrieve data from one or multiple tables. A query can be configured with specific filters, joins, and totaling methods. The following recipe will help to build a simple query to retrieve data from one table.

How to do it...

1. Create a new query with Object Designer.

2. In Query Designer, leave the default value of the column Type as it is; that is, DataItem.

3. Select Customer as Data Source from the table list.

4. In the next row, select Column as Type and No. as Data Source. Keep the method None as it is.

5. Add another two columns, Name and Balance, with the Method Type value None.

6. With the cursor hovering over the Balance row, click on Properties in the View menu or press Shift + F4.

7. In ColumnFilter, select the assist edit button to apply the following filter:

   Column	Type	Value
   Balance	Filter	<>0

   You should see the following screenshot:

   

8. Select the blank row and click...