Condition.aggregate

Property Description

An aggregate function that is performed on the condition. An aggregate function performs a calculation on the condition values and returns a single value.

This property is set during the execution of Query.createCondition(options) or Component.createCondition(options).

Note:

This property is not applicable to parent conditions created with the execution of Query.and(conditions), Query.or(conditions), or Query.not(condition).

Type

string (read-only)

Module

N/query Module

Parent Object

query.Condition

Sibling Object Members

Condition Object Members

Since

2018.1

Syntax

Important:

The following code sample shows the syntax for this member. It is not a functional example. For a complete script example, see N/query Module Script Samples.

            // Add additional code
...
    var myCustomerQuery = query.create({
        type: query.Type.CUSTOMER
    });
        var myAggregateCondition = myCustomerQuery.createCondition({
            fieldId: 'openingbalance',
            operator: query.Operator.GREATER,
            values: 10000,
            aggregate: query.Aggregate.MAXIMUM
    });
    var theAggregate = myAggregateCondition.aggregate;
...
// Add additional code

Syntax

Related Topics