Apex Reference Guide

Apex Reference Guide
Release Notes
Apex DML Operations
ApexPages Namespace
AppLauncher Namespace
Approval Namespace
Auth Namespace
Cache Namespace
Canvas Namespace
ChatterAnswers Namespace
CommerceBuyGrp Namespace
CommerceExtension Namespace
CommerceOrders Namespace
CommercePayments Namespace
CommerceTax Namespace
ComplianceMgmt Namespace
Compression Namespace
ConnectApi Namespace
Context Namespace
Database Namespace
Datacloud Namespace
DataRetrieval Namespace
DataSource Namespace
DataWeave Namespace
Dom Namespace
embeddedai Namespace
EventBus Namespace
ExternalService Namespace
Flow Namespace
Flowtesting Namespace
flowuiruntime Namespace
FormulaEval Namespace
fsccashflow Namespace
Functions Namespace
ise_bots_apex Namespace
IssueCreditMemo Namespace
ind_mfg_sample_mgmt_apex Namespace
industriesNlpSvc
IndustriesDigitalLending Namespace
Invocable Namespace
InvoiceWriteOff Namespace
IsvPartners Namespace
KbManagement Namespace
LxScheduler Namespace
Messaging Namespace
Metadata Namespace
PlaceQuote Namespace
Pref_center Namespace
Process Namespace
QuickAction Namespace
renew_assets_summary Namespace
Reports Namespace
RevSignaling Namespace
RevSalesTrxn Namespace
RichMessaging Namespace
RulesAppln Namespace
runtime_industries_cpq Namespace
runtime_industries_insurance Namespace
Schema Namespace
Search Namespace
setup_flow_performance Namespace
Sfc Namespace
Sfdc_Checkout Namespace
Sfdc_Enablement Namespace
sfdc_surveys Namespace
sfdw Namespace
sfsqlquery Namespace
Site Namespace
Slack Namespace
Support Namespace
System Namespace
TerritoryMgmt Namespace
TxnSecurity Namespace
UserProvisioning Namespace
VisualEditor Namespace
Wave Namespace
QueryBuilder Class
QueryNode Class
ProjectionNode Class
ProjectionNode Methods
Templates Class
TemplatesSearchOptions Class
Appendices
PDF

ProjectionNode Class

Add aggregate functions to the query, or define an alias.

Namespace

wave

Usage

Refer to the QueryBuilder example.

ProjectionNode Methods

The following are methods for ProjectionNode.

sum()

Returns the sum of a numeric field.

Signature

public wave.ProjectionNode sum()

Return Value

Type: wave.ProjectionNode

avg()

Returns the average value of a numeric field.

Signature

public wave.ProjectionNode avg()

Return Value

Type: wave.ProjectionNode

min()

Returns the minimum value of a field.

Signature

public wave.ProjectionNode min()

Return Value

Type: wave.ProjectionNode

max()

Returns the maximum value of a field.

Signature

public wave.ProjectionNode max()

Return Value

Type: wave.ProjectionNode

count()

Returns the number of rows that match the query criteria.

Signature

public wave.ProjectionNode count()

Return Value

Type: wave.ProjectionNode

unique()

Returns the count of unique values.

Signature

public wave.ProjectionNode unique()

Return Value

Type: wave.ProjectionNode

alias(name)

Define output column names.

Signature

public wave.ProjectionNode alias(String name)

Parameters

  • name:

    Type: String

    The name to use for this column. For example, this code defines the alias c: 
    1Wave.ProjectionNode[] projs = new Wave.ProjectionNode[]{Wave.QueryBuilder.count().alias('c')};

Return Value

Type: wave.ProjectionNode