Query Designer

Queries, just as any other objects in Microsoft Dynamics NAV or in Microsoft Dynamics 365 Business Central on-premise, have their own designer or editor with CSIDE.

Note

These steps are identical both for Microsoft Dynamics NAV and Microsoft Dynamics 365 Business Central On-premise. The screenshots are taken from Microsoft Dynamics 365 Business Central on-premises October 2018 release.

To open Query Designer, perform the following steps:

1. Open the Microsoft Dynamics NAV Development Environment. The Object Designer window will open.
2. On the left pane of the Object Designer window, click on Query to see the list of existing queries:

3. Select the query 9150 My Customers (or any other existing query) and click on Design. The QueryDesigner window will open:

The Query Designer window looks a lot like Page Designer or the new Report Dataset Designer. This will make it easier to get used to developing queries.

In the Query Designer window, we can select one or more DataItem values to define the...