ModelQueryExtensions<TTable extends Table, TModel> extension

Query builder extensions for models

on

Methods

limitTo(int count) SimpleSelectStatement<TTable, TModel>

Available on SimpleSelectStatement<TTable, TModel>, provided by the ModelQueryExtensions extension

Add LIMIT
offsetBy(int count) SimpleSelectStatement<TTable, TModel>

Available on SimpleSelectStatement<TTable, TModel>, provided by the ModelQueryExtensions extension

Add OFFSET
orderByColumn(Expression<Object> orderBy(TTable tbl), {OrderingMode mode = OrderingMode.asc}) SimpleSelectStatement<TTable, TModel>

Available on SimpleSelectStatement<TTable, TModel>, provided by the ModelQueryExtensions extension

Add ORDER BY clause
whereCondition(Expression<bool> filter(TTable tbl)) SimpleSelectStatement<TTable, TModel>

Available on SimpleSelectStatement<TTable, TModel>, provided by the ModelQueryExtensions extension

Add WHERE condition