EngineFindOptions

Options for Engine.findOne and Engine.findMany.

Properties

columns?

optional columns?: string[]

Columns or fields to return. When omitted or empty, all columns are returned.

---

filter?

optional filter?: CheckedExpr

A checked AIP-160 filter expression for the WHERE/filter clause. When omitted, all rows are matched.

---

limit?

optional limit?: number

Maximum number of rows to return.

---

offset?

optional offset?: number

Number of rows to skip (for pagination).

---

orderBy?

optional orderBy?: OrderBy

Ordering directive parsed from an AIP-132 order_by string. The engine translates this into database-specific ordering.

---

table

table: string

The table or collection name.