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.