smart-sqlite3-filter
    Preparing search index...

    Interface SearchOptions

    interface SearchOptions {
        columns?: string[];
        defaultFields?: string[];
        fieldsAliases?: Record<string, string[]>;
        from?: number;
        limit?: number;
        logger?: Logger;
        orderBy?: string;
        tableName?: string;
    }
    Index

    Properties

    columns? defaultFields? fieldsAliases? from? limit? logger? orderBy? tableName?

    Properties

    columns?: string[]

    Columns to return. Defaults to every column (*). Naming only the columns you need avoids reading wide ones (blobs, coordinates) you are going to throw away.

    ['*']
    defaultFields?: string[]

    In which fields to search. If not provided all fields will be searched.

    fieldsAliases?: Record<string, string[]>

    Aliases for the fields. If not provided the fields will be used as aliases It is possible to specify many fields in which the search will be performed

    from?: number

    Number of results to skip, for pagination. Requires a limit: SQLite has no OFFSET without LIMIT.

    0
    limit?: number

    The maximum number of results to return

    1000
    logger?: Logger

    We can log more information about how queries are executed

    orderBy?: string

    Specify the order of the results

    ''
    tableName?: string

    The name of the table to search. If not provided and there is only a table in the database it will be sued.

    Settings

    Member Visibility

    On This Page

    Properties