prorm API Reference
    Preparing search index...

    Interface SubqueryOptions

    Subquery builder options

    interface SubqueryOptions {
        model: string | { tableName?: string; name?: string };
        where?: Record<string, any>;
        columns?: string[];
        order?: any;
        group?: string | string[];
        having?: Record<string, any>;
        limit?: number;
        offset?: number;
    }
    Index
    model where? columns? order? group? having? limit? offset?
    model: string | { tableName?: string; name?: string }

    Model or table name to use for the subquery

    where?: Record<string, any>

    Where conditions

    columns?: string[]

    Columns to select

    order?: any

    Order by

    group?: string | string[]

    Group by

    having?: Record<string, any>

    Having conditions

    limit?: number

    Limit results

    offset?: number

    Offset results

    Settings
    Member Visibility

    On This Page
    Properties