filter method

T filter(
  1. String field, {
  2. dynamic equals,
  3. dynamic notEquals,
  4. dynamic greaterThan,
  5. dynamic gt,
  6. dynamic greaterThanOrEqual,
  7. dynamic gte,
  8. dynamic lessThan,
  9. dynamic lt,
  10. dynamic lessThanOrEqual,
  11. dynamic lte,
  12. dynamic contains,
  13. dynamic startsWith,
  14. dynamic endsWith,
  15. bool? isNull,
  16. bool? isNotNull,
})

Filter with named operator arguments (no raw SQL operator strings):

await User().filter('role', equals: 'admin').get();
await User().filter('age', greaterThan: 18, lessThan: 65).get();

Implementation

T filter(
  String field, {
  dynamic equals,
  dynamic notEquals,
  dynamic greaterThan,
  dynamic gt,
  dynamic greaterThanOrEqual,
  dynamic gte,
  dynamic lessThan,
  dynamic lt,
  dynamic lessThanOrEqual,
  dynamic lte,
  dynamic contains,
  dynamic startsWith,
  dynamic endsWith,
  bool? isNull,
  bool? isNotNull,
}) {
  qb.filter(
    field,
    equals: equals,
    notEquals: notEquals,
    greaterThan: greaterThan,
    gt: gt,
    greaterThanOrEqual: greaterThanOrEqual,
    gte: gte,
    lessThan: lessThan,
    lt: lt,
    lessThanOrEqual: lessThanOrEqual,
    lte: lte,
    contains: contains,
    startsWith: startsWith,
    endsWith: endsWith,
    isNull: isNull,
    isNotNull: isNotNull,
  );
  return this as T;
}