Class: QueryProperties

LiveView. QueryProperties

new LiveView.QueryProperties(initialValues)

Stores detailed information about a LiveView query.
Name Type Description
initialValues Object optional An object containing initial values for the QueryProperties object's properties. The property names defined in the initialValues object should match those of the corresponding QueryProperties member properties.

Members

includeInternalboolean

Flag indicating whether or not the query was configured to include LiveView-internal field values.
Default Value:
  • false

isAggregateboolean

Flag indicating whether or not the query is an aggregate query.
Default Value:
  • false

limitNumber

If a limit was specified in the query, this is the numerical value of that limit. For example, if the query was 'SELECT * FROM ItemsSales LIMIT 30', then the limit value would be 30. If no limit was specified, then the value will be -1;
Default Value:
  • -1

orderByArray

An array of objects that define the ORDER BY clause of the query. The order of elements in the array determines the priority of ordering (i.e. orderBy[0] is of the highest priority). The elements in the array contain two properties: fieldName and direction. The fieldName property is the string name that identifies the ORDER BY field. The direction property indicates is a string that indicates what direction to order the values ('ASC' for ascending order and 'DESC' for descending order).
Default Value:
  • []

predicateString

The predicate or set of conditions appearing in the query's WHERE clause.
Default Value:
  • null

predicateDelayNumber

If a time-delay modifier was added to the WHEN clause, predicateDelay is the value of the delay in milliseconds. For example, if the query was 'SELECT * FROM ItemsSales WHERE price > 100 FOR 1000', then predicateDelay would be 1000). If no time-delay modifier was specified, predicateDelay will be -1.
Default Value:
  • 0

projectionString

The projection of the query (i.e. those fields appearing in the query's FROM clause). Stored in CSV format.
Default Value:
  • null

queryTypeString

One of ['SNAPSHOT', 'CONTINUOUS', 'SNAPSHOT_AND_CONTINUOUS', 'DELETE']
Default Value:
  • null

schemaObject

The Schema of the parsed query.
Default Value:
  • null

tableString

The name of the table against which the query will be performed.
Default Value:
  • null

whenObject

If a time-window is specified in the query, this object will contain three properties: field, begin, and end. The field property is the string name of the field specified in the WHEN clause. The begin property defines the beginning of the time-window. The end property defines the end of the time-window. For example, if the query is 'SELECT * FROM ItemsSales WHEN transactionTime BETWEEN now()-seconds(30) AND now()', the field would be 'transactionTime', the begin would be 'now()-seconds(30)' and the end would be 'now()'.
Default Value:
  • null