Query Data type
Version: Available or changed with runtime version 1.0.
Enables you to retrieve data from multiple tables and combine the data in single dataset.
Static methods
The following methods are available on the Query data type.
| Method name | Description |
|---|---|
| SaveAsCsv(Integer, Text [, Integer] [, Text]) | Saves the resulting data set of a query as a comma-separated values (CSV) file. |
| SaveAsCsv(Integer, OutStream [, Integer] [, Text]) | Saves the resulting data set of a query as a comma separated values (CSV) file. |
| SaveAsJson(Integer, OutStream) | Saves the resulting data set of a query as an .json file. |
| SaveAsXml(Integer, Text) | Saves the resulting data set of a query as an .xml file. |
| SaveAsXml(Integer, OutStream) | Saves the resulting data set of a query as an .xml file. |
Instance methods
The following methods are available on instances of the Query data type.
| Method name | Description |
|---|---|
| Close() | Closes a query data set and returns the query instance to the initialized state. The following code shows the syntax of the CLOSE method. Query is a variable of the Query data type that specifies the query object. |
| ColumnCaption(Any) | Returns the current caption of a query column as a text string. |
| ColumnName(Any) | Returns the name of a query column as a text string. |
| ColumnNo(Any) | Returns the ID that is assigned to a query column in the query definition. |
| GetFilter(Any) | Returns the filters that are set on the field of a specified column in the query. The following code shows the syntax of the GETFILTER method. Query is a variable of the Query data type that specifies the query object. |
| GetFilters() | Returns the filters that are applied to all columns in the query. The following code shows the syntax of the GETFILTERS method. Query is a variable of the Query data type that specifies the query object. |
| Open() | Runs a query object and generates a data set that can be read. The following code shows the syntax of the OPEN method. Query is a variable of the Query data type that specifies the query object. |
| Read() | Reads data from a row in the resulting data set of a query. |
| SaveAsCsv(Text [, Integer] [, Text]) | Saves the resulting data set of a query as comma separated values (CSV) |
| SaveAsCsv(OutStream [, Integer] [, Text]) | Saves the resulting data set of a query as comma separated values (CSV) |
| SaveAsJson(OutStream) | Saves the resulting data set of a query as Json |
| SaveAsXml(Text) | Saves the resulting data set of a query as XML |
| SaveAsXml(OutStream) | Saves the resulting data set of a query as XML |
| SecurityFiltering([SecurityFilter]) | Gets or sets how security filters are applied to the query. |
| SetFilter(Any, Text [, Any,...]) | Sets a filter on a column of a query to limit the records in the resulting data set of a query. |
| SetRange(Any [, Any] [, Any]) | Sets a filter on a range of values on a column of a query data set. |
| TopNumberOfRows([Integer]) | Specifies the maximum number of rows to include in the resulting data set of a query. |