ComputedField class

A computed field definition for correlated subqueries.

Generates SQL like:

(SELECT MIN("price") FROM "Plan" WHERE "consultantId" = t0.id) AS "minPrice"

Constructors

ComputedField.avg(String field, {required String from, Map<String, dynamic>? where})

Create an AVG aggregate computed field.

factory

ComputedField.count({String field = '*', required String from, Map<String, dynamic>? where})

Create a COUNT aggregate computed field.

factory

ComputedField.first(String field, {required String from, Map<String, dynamic>? where, Map<String, String>? orderBy})

Create a FIRST (single value) computed field.

factory

ComputedField.max(String field, {required String from, Map<String, dynamic>? where})

Create a MAX aggregate computed field.

factory

ComputedField.min(String field, {required String from, Map<String, dynamic>? where})

Create a MIN aggregate computed field.

factory

ComputedField.sum(String field, {required String from, Map<String, dynamic>? where})

Create a SUM aggregate computed field.

factory

Properties

field → String

The field to aggregate or select.

final

from → String

The model/table to query from.

final

hashCode → int

The hash code for this object.

no setter, inherited

operation → AggregateOp

The aggregate operation (MIN, MAX, AVG, SUM, COUNT, or FIRST for single value).

final

orderBy → Map<String, String>?

ORDER BY for FIRST operation.

final

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

where → Map<String, dynamic>?

WHERE conditions for the subquery. Can contain FieldRef for correlated references.

final

Methods

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

toJson() → Map<String, dynamic>

Convert to JSON for query builder.

toString() → String

A string representation of this object.

override

Operators

operator ==(Object other) → bool

The equality operator.

inherited