ModelQuery<T extends Model<T>> extension

on

• Model<T>

Methods

avg(String column) → Future<double?>

Available on Model<T>, provided by the ModelQuery extension

Get average value

groupBy(String field) → T

Available on Model<T>, provided by the ModelQuery extension

GROUP BY clause - chainable

limit(int value) → T

Available on Model<T>, provided by the ModelQuery extension

LIMIT clause - chainable

max(String column) → Future

Available on Model<T>, provided by the ModelQuery extension

Get max value

min(String column) → Future

Available on Model<T>, provided by the ModelQuery extension

Get min value

offset(int value) → T

Available on Model<T>, provided by the ModelQuery extension

OFFSET clause - chainable

orderBy(String field, {bool? asc, bool? descending}) → T

Available on Model<T>, provided by the ModelQuery extension

ORDER BY clause - chainable Chainable orderBy with both asc and descending options

orWhere(String field, dynamic value) → T

Available on Model<T>, provided by the ModelQuery extension

OR WHERE clause - chainable

orWhereContains(String field, String value, {bool caseSensitive = false, bool escape = true}) → T

Available on Model<T>, provided by the ModelQuery extension

orWhereEndsWith(String field, String value, {bool caseSensitive = false, bool escape = true}) → T

Available on Model<T>, provided by the ModelQuery extension

orWhereLike(String field, String value, {bool caseSensitive = false, bool escape = true}) → T

Available on Model<T>, provided by the ModelQuery extension

orWhereStartsWith(String field, String value, {bool caseSensitive = false, bool escape = true}) → T

Available on Model<T>, provided by the ModelQuery extension

paginate(int page, [int perPage = 15]) → Future<Map<String, dynamic>>

Available on Model<T>, provided by the ModelQuery extension

Paginate results

query() → QueryBuilder

Available on Model<T>, provided by the ModelQuery extension

Internal query builder instance for chaining Execute the query and get results - FIXED Get first result - FIXED Custom query builder - starts a new chain

select(List<String> fields) → T

Available on Model<T>, provided by the ModelQuery extension

SELECT specific fields - chainable

sum(String column) → Future<double?>

Available on Model<T>, provided by the ModelQuery extension

Get sum value

where(String field, dynamic value) → T

Available on Model<T>, provided by the ModelQuery extension

WHERE clause - chainable

whereBetween(String field, dynamic start, dynamic end) → T

Available on Model<T>, provided by the ModelQuery extension

whereContains(String field, String value, {bool caseSensitive = false, bool escape = true}) → T

Available on Model<T>, provided by the ModelQuery extension

whereEndsWith(String field, String value, {bool caseSensitive = false, bool escape = true}) → T

Available on Model<T>, provided by the ModelQuery extension

whereIn(String field, List values) → T

Available on Model<T>, provided by the ModelQuery extension

WHERE IN clause - chainable

whereLike(String field, String value, {bool caseSensitive = false, bool escape = true}) → T

Available on Model<T>, provided by the ModelQuery extension

whereNotBetween(String field, dynamic start, dynamic end) → T

Available on Model<T>, provided by the ModelQuery extension

whereNotIn(String field, List values) → T

Available on Model<T>, provided by the ModelQuery extension

WHERE NOT IN clause - chainable

whereNotLike(String field, String value, {bool caseSensitive = false, bool escape = true}) → T

Available on Model<T>, provided by the ModelQuery extension

whereNotNull(String field) → T

Available on Model<T>, provided by the ModelQuery extension

WHERE NOT NULL clause - chainable

whereNull(String field) → T

Available on Model<T>, provided by the ModelQuery extension

WHERE NULL clause - chainable

whereOperator(String field, String operator, dynamic value) → T

Available on Model<T>, provided by the ModelQuery extension

WHERE with custom operator - chainable

whereStartsWith(String field, String value, {bool caseSensitive = false, bool escape = true}) → T

Available on Model<T>, provided by the ModelQuery extension