will demonstrate this capability using our âOrder Processing Systemâ project from Example 9.1. ...... Use your imagination and assume that a CPM/PERT network, as shown in the figure at the top of the following page, with the following estimated a
If you want to become full, let yourself be empty. Lao Tzu
Idea Transcript
> Developer and IT Pro Help for Microsoft Dyna… > Development > Objects
Tables Codeunits
Queries Microsoft Dynamics NAV 2016
Other Versions
Pages Reports Queries How to: Create Queries Understanding Data Item Links Understanding Query Totals and Grouping Understanding Query Filters How to: Sort a Query Dataset in Ascending or Descending Order Using the Date Method to Retrieve Day, Month, and Year Data Configuring User Permissions to Queries Working with Queries in C/AL Using Queries Instead of Record Variables Walkthrough: Creating a Query to Link Two Tables Walkthrough: Creating a Query That Uses a Totaling Method and Sorting Walkthrough: Creating a Query to Link Three Tables XMLports MenuSuites Compiling Objects Importing and Exporting Objects Running Objects from the Development Environment Using About This Page and About This Report Viewing the Definition of a Function or Object Locking and Unlocking Objects Object Specifications and Limitations Displaying Charts Using the Chart Control Add-in How to: Specify the Start ID Offset of Elements on Objects A query object enables you 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 totaling methods on fields, such as sums and averages. The following section describes how to locate Microsoft Dynamics NAV 2016 documentation about designing queries in Microsoft Dynamics NAV.
Creating Queries This section explains how to design queries to specify datasets.
To
See
Learn how to create a basic query in Query Designer.
How to: Create Queries
Learn the supported ways to join tables in Query Designer.
Understanding Joins
Learn how to add totaling methods to columns in a query.
Understanding Query Totals
Learn how to filter the results of a query.
Understanding Query Filters
Learn how to run queries from C/AL code
Working with Queries in C/AL
Learn how to create complex queries by walking through examples that use the CRONUS International Ltd. demonstration database.
Walkthrough: Creating a Query to Join Two Tables Walkthrough: Creating a Query That Uses a Totaling Method Walkthrough: Creating a Complex Query
Note
You cannot run a query that gets data from both the application database and the business data database. This also applies to single-tenant deployments so that you do not have to rewrite queries if you decide to export the application. For a description of which tables are considered part of the application database, see Separating Application Data from Business Data.
Using Queries The following examples show how you can use queries in your Microsoft Dynamics NAV application. Creating charts that are based on a query instead of a table. For more information, see How to: Create Generic Charts in the Application Help for Microsoft Dynamics NAV 2016. Saving a query as an .xml or .csv file. You can use the SAVEASXML Function (Query) to create an .xml file that contains the resulting dataset of a query. You can use the .xml file to integrate with external applications. Exposing data as an OData web service. You can register and publish a query as a web service in the same way that you can register and publish pages or codeunits as web services. You use the Web Services page to register and publish pages, codeunits, or queries. After you expose a query as a web service, you can import it into other applications. For example, you can import Microsoft Dynamics NAV data into Microsoft Excel using Microsoft PowerPivot for Excel, which is a data analysis add-in. You can then create PivotTables in Excel that use the Microsoft Dynamics NAV data from your query. For an example , see Walkthrough: Combining Data from Microsoft Dynamics NAV Queries and Pages with Data from Azure Data Mart (OData) Print Share
Is this page helpful?
Dev centers Windows Office Visual Studio Microsoft Azure
Yes
No
Learning resources
Community
Support
Microsoft Virtual Academy
Forums
Self support
Channel 9
Blogs
MSDN Magazine
Codeplex
Programs BizSpark (for startups) Microsoft Imagine (for students)