prorm API Reference
    Preparing search index...

    Interface RecursiveCTEOptions

    Recursive CTE options for hierarchical data

    interface RecursiveCTEOptions {
        name: string;
        columns?: CTEColumn[];
        anchor: FindOptions;
        recursive: FindOptions;
        model?: string | { tableName?: string; name?: string };
        maxDepth?: number;
        order?: any[];
    }
    Index
    name columns? anchor recursive model? maxDepth? order?
    name: string

    CTE name

    columns?: CTEColumn[]

    Columns

    anchor: FindOptions

    Anchor/member - starting point

    recursive: FindOptions

    Recursive member - how to get children

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

    Model class or table name for reference

    maxDepth?: number

    Maximum recursion depth

    order?: any[]

    Sort order for results

    Settings
    Member Visibility

    On This Page
    Properties