QueryNode Class

Define each node of the query - such as projection, groups, order, filters. Execute the query.

wave

Refer to the QueryBuilder example.

The following are methods for QueryNode.

build(streamName)

Build the query string represented by this QueryNode and assign it to a stream name.
foreach(projections)

Applies a set of expressions to every row in a dataset. This action is often referred to as projection.
group(groups)

Groups matched records (group by specific dataset attributes).
group()

Groups matched records (group by all).
order(orders)

Sorts in ascending or descending order on one or more fields.
cap(cap)

Limits the number of results that are returned.
filter(filterCondition)

Selects rows from a dataset based on a filter condition (a predicate).
filter(filterConditions)

Selects rows from a dataset based on multiple filter conditions (predicates).
execute(streamName)

Execute the query and return rows as JSON.

Build the query string represented by this QueryNode and assign it to a stream name.

public String build(String streamName)

streamName:

Type: String

The identifier for the stream - for example, “q”.

The SAQL query string represented by the QueryNode.

Applies a set of expressions to every row in a dataset. This action is often referred to as projection.

public wave.QueryNode foreach(List<wave.ProjectionNode> projections)

projections:

Type: List<wave.ProjectionNode>

A list of ProjectionNodes to be added to this QueryNode.

Groups matched records (group by specific dataset attributes).

public wave.QueryNode group(List<String> groups)

Groups matched records (group by all).

public wave.QueryNode group()

Sorts in ascending or descending order on one or more fields.

public wave.QueryNode order(List<List<String>> orders)

orders: Type: List<List<String>> A list of column names and associated ascending or descending keywords, for example

Limits the number of results that are returned.

global Wave.QueryNode cap(Integer cap)

Selects rows from a dataset based on a filter condition (a predicate).

public wave.QueryNode filter(String filterCondition)

filterCondition:

Type: String

For example: filter('Name != \'My Name\'')

Selects rows from a dataset based on multiple filter conditions (predicates).

public wave.QueryNode filter(List<String> filterCondition)

Execute the query and return rows as JSON.

global ConnectApi.LiteralJson execute(String streamName)

Type: ConnectApi.LiteralJson