This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
Microsoft Logo
Gray Pipe
Developer Network Developer Network Developer
Sign in

Subscriber portal

Get tools
  • Downloads
    • Visual Studio
    • SDKs
    • Trial software
      • Free downloads
      • Office resources
      • SharePoint Server 2013 resources
      • SQL Server 2014 Express resources
      • Windows Server 2012 resources
  • Programs
    • Subscriptions
      • Overview
      • Administrators
    • Students
      • Microsoft Imagine
      • Microsoft Student Partners
    • ISV
    • Startups
    • Events
  • Community
    • Magazine
    • Forums
    • Blogs
    • Channel 9
  • Documentation
    • APIs and reference
    • Dev centers
    • Samples
    • Retired content
search clear
We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second.
Technical Reference C/SIDE Reference Guide C/AL Functions
C/AL Functions Query Data Type
Query Data Type
Query Data Type
Functions Not Supported by Microsoft Dynamics NAV Web Client
Automation Data Type
BLOB Data Type
Boolean Data Type
Byte Data Type
Char Data Type
Codeunit Data Type
Database
DateFormula Data Type
Dates and Times
Debugger
Dialog Data Type
FieldRef Data Type
File Data Type
GUID Data Type
InStream and OutStream Data Types
KeyRef Data Type
Numbers
OCX Data Type
Option Data Type
Page Data Type
Query Data Type
Accessing Columns of a Query Dataset
CLOSE
COLUMNCAPTION
COLUMNNAME
COLUMNNO
GETFILTER
GETFILTERS
OPEN
READ
SAVEASCSV
SAVEASXML
SETFILTER
SETRANGE
TOPNUMBEROFROWS
Record Data Type
RecordID Data Type
RecordRef Data Type
Report Data Type
Sessions
Strings
System
Test Pages
TableFilter Data Type
Variant Data Type
XMLport Data Type
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.
This documentation is archived and is not being maintained.

Query Data Type

Microsoft Dynamics NAV 2015
Other Versions
  • Microsoft Dynamics NAV 2016
  • Microsoft Dynamics NAV 2013 R2
  • Microsoft Dynamics NAV 2013

A complex data type that stores queries.

Remarks

A query enables you to retrieve data from multiple tables and combine the data in single dataset.

See Also

Reference

Accessing Columns of a Query Dataset
CLOSE Function (Query)
COLUMNCAPTION Function
COLUMNNAME Function
COLUMNNO Function
GETFILTER Function (Query)
GETFILTERS Function (Query)
OPEN Function (Query)
READ Function (Query)
SAVEASCSV Function
SAVEASXML Function
SETFILTER Function (Query)
SETRANGE Function (Query)
TOPNUMBEROFROWS Function

Show:
Print Export (0)
Print Share
IN THIS ARTICLE
    Is this page helpful?
    Additional feedback?
    1500 characters remaining
    Thank you! We appreciate your feedback.

    Dev centers

    • Windows
    • Office
    • Visual Studio
    • Microsoft Azure
    • More...

    Learning resources

    • Microsoft Virtual Academy
    • Channel 9
    • MSDN Magazine

    Community

    • Forums
    • Blogs
    • Codeplex

    Support

    • Self support

    Programs

    • BizSpark (for startups)
    • Microsoft Imagine (for students)
    United States (English)
    • Newsletter
    • Privacy & cookies
    • Terms of use
    • Trademarks
    logo © 2017 Microsoft
    © 2017 Microsoft