Apex Developer Guide

Apex Developer Guide
Getting Started with Apex
Writing Apex
Running Apex
Debugging, Testing, and Deploying Apex
Apex Language Reference
Apex DML Operations
ApexPages Namespace
AppLauncher Namespace
Approval Namespace
Auth Namespace
Cache Namespace
Canvas Namespace
ChatterAnswers Namespace
ConnectApi Namespace
Database Namespace
Datacloud Namespace
DataSource Namespace
Dom Namespace
EventBus Namespace
Flow Namespace
KbManagement Namespace
Messaging Namespace
Metadata Namespace
Process Namespace
QuickAction Namespace
Reports Namespace
Schema Namespace
Search Namespace
Sfc Namespace
Site Namespace
Support Namespace
System Namespace
TerritoryMgmt Namespace
TxnSecurity Namespace
UserProvisioning Namespace
VisualEditor Namespace
wave Namespace
QueryBuilder Class
QueryBuilder Methods
QueryNode Class
ProjectionNode Class
Appendices
Glossary
PDF

Newer Version Available

This content describes an older version of this product. View Latest

QueryBuilder Class

The QueryBuilder class provides methods for constructing well-formed SAQL queries to pass to Wave Analytics.

Namespace

wave

Usage

Use QueryBuilder and its associated classes, Wave.ProjectionNode and Wave.QueryNode, to incrementally build your SAQL statement. For example:

Examples

QueryBuilder is the core of this first phase of the Wave Apex SDK, so let’s take a closer look. Here’s a simple count query.

The resulting SAQL query looks like this:

Here’s a more complex example that uses a union statement.

The resulting SAQL query has two projection streams, qa and qb.

QueryBuilder Methods

The following are methods for QueryBuilder.

load(datasetID, datasetVersionID)

Load a stream from a dataset.

Signature

public static wave.QueryNode load(String datasetID, String datasetVersionID)

Parameters

datasetID
Type: String
The ID of the dataset.
datasetVersionID
Type: String
The ID identifying the version of the dataset.

Return Value

Type: wave.QueryNode

count()

Calculate the number of rows that match the query criteria.

Signature

public static wave.ProjectionNode count()

Return Value

Type: wave.ProjectionNode

get(projection)

Query by selecting specific attributes.

Signature

public static wave.ProjectionNode get(String proj)

Parameters

proj
Type: String
The name of the column to query.

Return Value

Type: wave.ProjectionNode

union(unionNodes)

Combine multiple result sets into one result set.

Signature

global static Wave.QueryNode union(List<Wave.QueryNode> unionNodes)

Parameters

unionNodes
Type: List<wave.QueryNode>
List of nodes to combine.

Return Value

Type: wave.QueryNode

cogroup(cogroupNodes, groups)

Cogrouping means that two input streams are grouped independently and arranged side by side. Only data that exists in both groups appears in the results.

Signature

global static Wave.QueryNode cogroup(List<Wave.QueryNode> cogroupNodes, List<List<String>> groups)

Parameters

cogroupNodes
Type: wave.QueryNode
List of nodes to group.
groups
Type: String
The type of grouping.

Return Value

Type: wave.QueryNode