A Statement represents a pass over a set of input records
(those of the FROM table) to generate a set of output records.
Namespace: Endeca.Navigation.AnalyticsAssembly: Endeca.Navigation (in Endeca.Navigation.dll) Version: 6.3.0.0 (6.3.0.853)
Syntax
| C# |
|---|
public class Statement : IQueryNode |
| Visual Basic |
|---|
Public Class Statement _ Implements IQueryNode |
| Visual C++ |
|---|
public ref class Statement : IQueryNode |
Remarks
Input records and output records may be filtered;
output records are populated with derived values, and with
values by which the records are GROUPed.
The output record set may be sorted and paged.
A Statement has the form:
- RETURN {table-name} AS // required: RETURN or DEFINE: see Shown
- SELECT // required
- {expr1} AS {field1}, // required: at least one assignment.
- {expr2} AS {field2},
- ...
- WHERE {filter} // optional
- FROM {table-name} // optional
- GROUP // optional: or GROUP BY {field}, {field},...
- HAVING {filter} // optional
- ORDER BY {field},{field}... // optional
- PAGE({start}, {end}) // optional
NavStateRecords and AllBaseRecords are reserved table names. NavStateRecords is the default if the FROM clause is omitted.
