prorm API Reference
    Preparing search index...

    Interface CTEDefinition

    Base CTE definition without raw SQL

    interface CTEDefinition {
        name: string;
        columns?: CTEColumn[];
        baseCase?: Record<string, any>[] | FindOptions;
        recursiveCase?: FindOptions;
        unionWith?: FindOptions;
        model?: string | { tableName?: string; name?: string };
    }
    Index
    name columns? baseCase? recursiveCase? unionWith? model?
    name: string

    Name of the CTE

    columns?: CTEColumn[]

    Column definitions

    baseCase?: Record<string, any>[] | FindOptions

    Base case for recursive CTE - can be FindOptions or values

    recursiveCase?: FindOptions

    Recursive case for recursive CTE

    unionWith?: FindOptions

    Non-recursive UNION part

    model?: string | { tableName?: string; name?: string }

    Model class or table name

    Settings
    Member Visibility

    On This Page
    Properties