Member Junction
    Preparing search index...

    Interface AggregateExpression

    Single aggregate expression to compute alongside the main view query. Aggregates run in parallel with the row data query and are NOT affected by pagination.

    interface AggregateExpression {
        alias?: string;
        expression: string;
    }
    Index

    Properties

    alias? expression

    Properties

    alias?: string

    Optional alias for the result (used in error messages and debugging). If not provided, defaults to the expression itself.

    expression: string

    SQL expression for the aggregate. Examples:

    • "SUM(OrderTotal)"
    • "AVG(Price)"
    • "COUNT(*)"
    • "MAX(CreatedAt)"
    • "SUM(Quantity * Price * (1 - Discount/100))"

    Settings

    Member Visibility

    On This Page

    Properties