OrderedQuery<T extends Record> class final Writing queries

A Query which has an order imposed by .orderBy.

An OrderedQuery has the following extension methods that preserve the ordering:

• .where,
• .limit,
• .offset,
• .select, and,
• .distinct.

Tip

If you wish to use an ordered query in manner that disregards the ordering you can convert to an unordered Query using asQuery. This is necessary for certain operations (like JOIN, UNION, etc.) becauses SQL disregards the order of rows in subqueries.

As an example, SQL disregards the ordering when using a query in a UNION or JOIN, thus, you must use asQuery, if you wish to do such operations.

Available extensions

• OrderedQuery1
• OrderedQuery2
• OrderedQuery3
• OrderedQuery4
• OrderedQuery5
• OrderedQuery6
• OrderedQuery7
• OrderedQuery8
• OrderedQueryExt

Properties

asQuery → Query<T>

Available on OrderedQuery<T>, provided by the OrderedQueryExt extension

Wrap this as unordered Query.

no setter

first → QuerySingle<(Expr<A>)>

Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension

Limit Query to the first row using LIMIT clause.

no setter

first → QuerySingle<(Expr<A>, Expr<B>)>

Available on OrderedQuery<(Expr<A>, Expr<B>)>, provided by the OrderedQuery2 extension

Limit Query to the first row using LIMIT clause.

no setter

first → QuerySingle<(Expr<A>, Expr<B>, Expr<C>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

Limit Query to the first row using LIMIT clause.

no setter

first → QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the OrderedQuery4 extension

Limit Query to the first row using LIMIT clause.

no setter

first → QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the OrderedQuery5 extension

Limit Query to the first row using LIMIT clause.

no setter

first → QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the OrderedQuery6 extension

Limit Query to the first row using LIMIT clause.

no setter

first → QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

Limit Query to the first row using LIMIT clause.

no setter

first → QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the OrderedQuery8 extension

Limit Query to the first row using LIMIT clause.

no setter

hashCode → int

The hash code for this object.

no setter, inherited

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

distinct() → ProjectedOrderedQuery<T>

Available on OrderedQuery<T>, provided by the OrderedQueryExt extension

Create a query with distinct rows from this query using the DISTINCT keyword.

fetch() → Future<List<A>>

Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension

Query the database for rows in this Query as a List.

fetch() → Future<List<(A, B, C, D, E, F, G)>>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

Query the database for rows in this Query as a List.

fetch() → Future<List<(A, B)>>

Available on OrderedQuery<(Expr<A>, Expr<B>)>, provided by the OrderedQuery2 extension

Query the database for rows in this Query as a List.

fetch() → Future<List<(A, B, C, D, E, F, G, H)>>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the OrderedQuery8 extension

Query the database for rows in this Query as a List.

fetch() → Future<List<(A, B, C)>>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

Query the database for rows in this Query as a List.

fetch() → Future<List<(A, B, C, D)>>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the OrderedQuery4 extension

Query the database for rows in this Query as a List.

fetch() → Future<List<(A, B, C, D, E)>>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the OrderedQuery5 extension

Query the database for rows in this Query as a List.

fetch() → Future<List<(A, B, C, D, E, F)>>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the OrderedQuery6 extension

Query the database for rows in this Query as a List.

limit(int limit) → OrderedQueryRange<(Expr<A>)>

Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension

Limit OrderedQuery using LIMIT clause.

limit(int limit) → OrderedQueryRange<(Expr<A>, Expr<B>)>

Available on OrderedQuery<(Expr<A>, Expr<B>)>, provided by the OrderedQuery2 extension

Limit OrderedQuery using LIMIT clause.

limit(int limit) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

Limit OrderedQuery using LIMIT clause.

limit(int limit) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the OrderedQuery4 extension

Limit OrderedQuery using LIMIT clause.

limit(int limit) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the OrderedQuery8 extension

Limit OrderedQuery using LIMIT clause.

limit(int limit) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the OrderedQuery5 extension

Limit OrderedQuery using LIMIT clause.

limit(int limit) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the OrderedQuery6 extension

Limit OrderedQuery using LIMIT clause.

limit(int limit) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

Limit OrderedQuery using LIMIT clause.

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

offset(int offset) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

Offset OrderedQuery using OFFSET clause.

offset(int offset) → OrderedQueryRange<(Expr<A>)>

Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension

Offset OrderedQuery using OFFSET clause.

offset(int offset) → OrderedQueryRange<(Expr<A>, Expr<B>)>

Available on OrderedQuery<(Expr<A>, Expr<B>)>, provided by the OrderedQuery2 extension

Offset OrderedQuery using OFFSET clause.

offset(int offset) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

Offset OrderedQuery using OFFSET clause.

offset(int offset) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the OrderedQuery8 extension

Offset OrderedQuery using OFFSET clause.

offset(int offset) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the OrderedQuery4 extension

Offset OrderedQuery using OFFSET clause.

offset(int offset) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the OrderedQuery5 extension

Offset OrderedQuery using OFFSET clause.

offset(int offset) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the OrderedQuery6 extension

Offset OrderedQuery using OFFSET clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

Order OrderedQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the OrderedQuery4 extension

Order OrderedQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a)) → OrderedQuery<(Expr<A>)>

Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension

Order OrderedQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the OrderedQuery5 extension

Order OrderedQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g, Expr<H> h)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the OrderedQuery8 extension

Order OrderedQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b)) → OrderedQuery<(Expr<A>, Expr<B>)>

Available on OrderedQuery<(Expr<A>, Expr<B>)>, provided by the OrderedQuery2 extension

Order OrderedQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the OrderedQuery6 extension

Order OrderedQuery using ORDER BY clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

Order OrderedQuery using ORDER BY clause.

select<T extends Record>(T projectionBuilder(Expr<A> a)) → ProjectedOrderedQuery<T>

Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension

Create a projection of this OrderedQuery using SELECT clause.

select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f)) → ProjectedOrderedQuery<T>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the OrderedQuery6 extension

Create a projection of this OrderedQuery using SELECT clause.

select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b, Expr<C> c)) → ProjectedOrderedQuery<T>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

Create a projection of this OrderedQuery using SELECT clause.

select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e)) → ProjectedOrderedQuery<T>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the OrderedQuery5 extension

Create a projection of this OrderedQuery using SELECT clause.

select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b)) → ProjectedOrderedQuery<T>

Available on OrderedQuery<(Expr<A>, Expr<B>)>, provided by the OrderedQuery2 extension

Create a projection of this OrderedQuery using SELECT clause.

select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g, Expr<H> h)) → ProjectedOrderedQuery<T>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the OrderedQuery8 extension

Create a projection of this OrderedQuery using SELECT clause.

select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d)) → ProjectedOrderedQuery<T>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the OrderedQuery4 extension

Create a projection of this OrderedQuery using SELECT clause.

select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g)) → ProjectedOrderedQuery<T>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

Create a projection of this OrderedQuery using SELECT clause.

stream() → Stream<(A, B, C, D, E)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the OrderedQuery5 extension

Query the database for rows in this Query as a Stream.

stream() → Stream<(A, B, C, D, E, F, G, H)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the OrderedQuery8 extension

Query the database for rows in this Query as a Stream.

stream() → Stream<(A, B, C)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

Query the database for rows in this Query as a Stream.

stream() → Stream<(A, B, C, D, E, F)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the OrderedQuery6 extension

Query the database for rows in this Query as a Stream.

stream() → Stream<(A, B, C, D, E, F, G)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

Query the database for rows in this Query as a Stream.

stream() → Stream<A>

Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension

Query the database for rows in this Query as a Stream.

stream() → Stream<(A, B)>

Available on OrderedQuery<(Expr<A>, Expr<B>)>, provided by the OrderedQuery2 extension

Query the database for rows in this Query as a Stream.

stream() → Stream<(A, B, C, D)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the OrderedQuery4 extension

Query the database for rows in this Query as a Stream.

toString() → String

A string representation of this object.

inherited

where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

Filter OrderedQuery using WHERE clause.

where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g, Expr<H> h)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the OrderedQuery8 extension

Filter OrderedQuery using WHERE clause.

where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the OrderedQuery6 extension

Filter OrderedQuery using WHERE clause.

where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the OrderedQuery5 extension

Filter OrderedQuery using WHERE clause.

where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the OrderedQuery4 extension

Filter OrderedQuery using WHERE clause.

where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

Filter OrderedQuery using WHERE clause.

where(Expr<bool> conditionBuilder(Expr<A> a)) → OrderedQuery<(Expr<A>)>

Available on OrderedQuery<(Expr<A>)>, provided by the OrderedQuery1 extension

Filter OrderedQuery using WHERE clause.

where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b)) → OrderedQuery<(Expr<A>, Expr<B>)>

Available on OrderedQuery<(Expr<A>, Expr<B>)>, provided by the OrderedQuery2 extension

Filter OrderedQuery using WHERE clause.

Operators

operator ==(Object other) → bool

The equality operator.

inherited