ColumnFilters<T extends Object> class

Built in filters for all columns

Available extensions

• BigIntFilters
• BoolFilters
• DateFilters
• NumFilters
• StringFilters

Constructors

ColumnFilters(Expression<T> column, {bool inverted = false})

This class is a wrapper on top of the generated column class

Properties

column → Expression<T>

Column that this ColumnFilters wraps

final, inherited

hashCode → int

The hash code for this object.

no setter, inherited

inverted → bool

If true, all filters will be inverted

final, inherited

not → ColumnFilters<T>

Returns a copy of these column filters where all the filters are inverted

no setter

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

$composableFilter(Expression<bool> expression) → Expression<bool>

This helper method is used internally to create a new Expression<bool>s that respects the inverted state of the current filter

inherited

call(T? value) → Expression<bool>

Shortcut for equals

contains(T value, {bool caseInsensitive = true}) → Expression<bool>

Available on ColumnFilters<String>, provided by the StringFilters extension

Create a filter to check if the this text column contains a substring

endsWith(T value, {bool caseInsensitive = true}) → Expression<bool>

Available on ColumnFilters<String>, provided by the StringFilters extension

Create a filter to check if the this text column ends with a substring

equals(T? value) → Expression<bool>

Create a filter that checks if the column equals a value.

isAfter(T value) → Expression<bool>

Available on ColumnFilters<T>, provided by the DateFilters extension

Create a filter to check if the column is after a DateTime

isAfterOrOn(T value) → Expression<bool>

Available on ColumnFilters<T>, provided by the DateFilters extension

Create a filter to check if the column is on or after a DateTime

isBefore(T value) → Expression<bool>

Available on ColumnFilters<T>, provided by the DateFilters extension

Create a filter to check if the column is before a DateTime

isBeforeOrOn(T value) → Expression<bool>

Available on ColumnFilters<T>, provided by the DateFilters extension

Create a filter to check if the column is before or on a DateTime

isBetween(T lower, T higher) → Expression<bool>

Available on ColumnFilters<T>, provided by the BigIntFilters extension

Create a filter to check if the column is between two values This is done inclusively, so the column can be equal to the lower or higher value E.G isBetween(1, 3) will return true for 1, 2, and 3

isBetween(T lower, T higher) → Expression<bool>

Available on ColumnFilters<T>, provided by the DateFilters extension

Create a filter to check if the column is between 2 DateTimes This is done inclusively, so the column can be equal to the lower or higher value E.G isBetween(1, 3) will return true for 1, 2, and 3

isBetween(T lower, T higher) → Expression<bool>

Available on ColumnFilters<T>, provided by the NumFilters extension

Create a filter to check if the column is between two values This is done inclusively, so the column can be equal to the lower or higher value E.G isBetween(1, 3) will return true for 1, 2, and 3

isBiggerOrEqualTo(T value) → Expression<bool>

Available on ColumnFilters<T>, provided by the BigIntFilters extension

Create a filter to check if the column is bigger or equal to a value

isBiggerOrEqualTo(T value) → Expression<bool>

Available on ColumnFilters<T>, provided by the NumFilters extension

Create a filter to check if the column is bigger or equal to a value

isBiggerThan(T value) → Expression<bool>

Available on ColumnFilters<T>, provided by the BigIntFilters extension

Create a filter to check if the column is bigger than a value

isBiggerThan(T value) → Expression<bool>

Available on ColumnFilters<T>, provided by the NumFilters extension

Create a filter to check if the column is bigger than a value

isFalse() → Expression<bool>

Available on ColumnFilters<bool>, provided by the BoolFilters extension

Create a filter to check if the column is small than a value

isIn(Iterable<T> values) → Expression<bool>

Create a filter that checks if the column is in a list of values.

isNull() → Expression<bool>

Create a filter that checks if the column is null.

inherited

isSmallerOrEqualTo(T value) → Expression<bool>

Available on ColumnFilters<T>, provided by the BigIntFilters extension

Create a filter to check if the column is small or equal to a value

isSmallerOrEqualTo(T value) → Expression<bool>

Available on ColumnFilters<T>, provided by the NumFilters extension

Create a filter to check if the column is small or equal to a value

isSmallerThan(T value) → Expression<bool>

Available on ColumnFilters<T>, provided by the BigIntFilters extension

Create a filter to check if the column is small than a value

isSmallerThan(T value) → Expression<bool>

Available on ColumnFilters<T>, provided by the NumFilters extension

Create a filter to check if the column is small than a value

isTrue() → Expression<bool>

Available on ColumnFilters<bool>, provided by the BoolFilters extension

Create a filter to check if the column is bigger than a value

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

sqlEquals(T value) → Expression<bool>

Creates a filter that checks whether the column is equal to the value.

inherited

startsWith(T value, {bool caseInsensitive = true}) → Expression<bool>

Available on ColumnFilters<String>, provided by the StringFilters extension

Create a filter to check if the this text column starts with a substring

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited