Member Junction
    Preparing search index...

    Class QuerySQLInfo

    Stores dialect-specific SQL for a query. Each record pairs a Query with a SQLDialect and provides the SQL text written in that dialect. Maps to the QuerySQL database table.

    Use MJQuerySQLEntity from @memberjunction/core-entities instead.

    Hierarchy (View Summary)

    Index

    Constructors

    constructor

    Properties

    __mj_CreatedAt __mj_UpdatedAt ID Query QueryID SQL SQLDialect SQLDialectID

    Accessors

    QueryInfo SQLDialectInfo

    Methods

    copyInitData toJSON

    Constructors

    Properties

    __mj_CreatedAt

    __mj_CreatedAt: Date = null

    Record creation timestamp

    __mj_UpdatedAt

    __mj_UpdatedAt: Date = null

    Record last update timestamp

    ID: string = null

    Unique identifier

    Query: string = null

    Query name from the related query

    QueryID: string = null

    Foreign key to the parent query

    SQL: string = null

    The SQL query text in the specified dialect

    SQLDialect: string = null

    SQL dialect name

    SQLDialectID: string = null

    Foreign key to the SQL dialect

    Accessors

    Methods

    • Copies initialization data from a plain object to the class instance. Only copies properties that already exist on the class to prevent creating new fields. Special handling for DefaultValue fields to extract actual values from SQL Server syntax.

      Parameters

      • initData: any

        The initialization data object

      Returns void

    • Default JSON serialization for BaseInfo subclasses.

      Emits all non-underscored direct field declarations. For _-prefixed private backing fields (the MJ pattern for collection storage — e.g. _Fields, _RelatedEntities, _OrganicKeys), emits the value of the corresponding same-named public getter instead. Purely computed getters without a backing field (display-name formatters, derived flags) are intentionally skipped — they can throw when source fields are null and don't belong on the wire anyway.

      Nested BaseInfo instances and arrays of them unwrap automatically via JSON.stringify's native toJSON() protocol.

      Subclasses may override to emit a filtered subset or custom shape (see EntityFieldValueInfo).

      Returns Record<string, unknown>

    Settings

    Member Visibility

    On This Page

    Constructors
    Properties
    Accessors
    Methods