ProjectedOrderedQueryRange<T extends Record> class final Writing queries

A Query which has an order imposed by .orderBy, is projected to a new set of columns using .select (or .distinct), and is limited to a range by .limit or .offset.

A ProjectedOrderedQuery has the following extension methods that preserve the ordering:

• .limit, and,
• .offset.

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.

To use other extension methods such as.where or .select you must use asQuery, because these must create subqueries which discards the ordering.

Available extensions

• ProjectedOrderedQueryRange1
• ProjectedOrderedQueryRange2
• ProjectedOrderedQueryRange3
• ProjectedOrderedQueryRange4
• ProjectedOrderedQueryRange5
• ProjectedOrderedQueryRange6
• ProjectedOrderedQueryRange7
• ProjectedOrderedQueryRange8
• ProjectedOrderedQueryRangeExt

Properties

asQuery → Query<T>

Available on ProjectedOrderedQueryRange<T>, provided by the ProjectedOrderedQueryRangeExt extension

Wrap this as unordered Query.

no setter

first → QuerySingle<(Expr<A>)>

Available on ProjectedOrderedQueryRange<(Expr<A>)>, provided by the ProjectedOrderedQueryRange1 extension

Limit Query to the first row using LIMIT clause.

no setter

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

Available on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>)>, provided by the ProjectedOrderedQueryRange2 extension

Limit Query to the first row using LIMIT clause.

no setter

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

Available on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>)>, provided by the ProjectedOrderedQueryRange3 extension

Limit Query to the first row using LIMIT clause.

no setter

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

Available on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the ProjectedOrderedQueryRange4 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 ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the ProjectedOrderedQueryRange5 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 ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the ProjectedOrderedQueryRange6 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 ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the ProjectedOrderedQueryRange7 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 ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the ProjectedOrderedQueryRange8 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

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

Available on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the ProjectedOrderedQueryRange5 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 ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the ProjectedOrderedQueryRange8 extension

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

fetch() → Future<List<A>>

Available on ProjectedOrderedQueryRange<(Expr<A>)>, provided by the ProjectedOrderedQueryRange1 extension

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

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

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

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

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

Available on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>)>, provided by the ProjectedOrderedQueryRange2 extension

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

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

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

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

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

Available on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>)>, provided by the ProjectedOrderedQueryRange3 extension

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

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

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

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

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

Available on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>)>, provided by the ProjectedOrderedQueryRange2 extension

Limit ProjectedOrderedQueryRange using LIMIT clause.

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

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

Limit ProjectedOrderedQueryRange using LIMIT clause.

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

Available on ProjectedOrderedQueryRange<(Expr<A>)>, provided by the ProjectedOrderedQueryRange1 extension

Limit ProjectedOrderedQueryRange using LIMIT clause.

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

Available on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>)>, provided by the ProjectedOrderedQueryRange3 extension

Limit ProjectedOrderedQueryRange using LIMIT clause.

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

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

Limit ProjectedOrderedQueryRange using LIMIT clause.

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

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

Limit ProjectedOrderedQueryRange using LIMIT clause.

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

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

Limit ProjectedOrderedQueryRange using LIMIT clause.

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

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

Limit ProjectedOrderedQueryRange using LIMIT clause.

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

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

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

Offset ProjectedOrderedQueryRange using OFFSET clause.

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

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

Offset ProjectedOrderedQueryRange using OFFSET clause.

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

Available on ProjectedOrderedQueryRange<(Expr<A>)>, provided by the ProjectedOrderedQueryRange1 extension

Offset ProjectedOrderedQueryRange using OFFSET clause.

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

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

Offset ProjectedOrderedQueryRange using OFFSET clause.

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

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

Offset ProjectedOrderedQueryRange using OFFSET clause.

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

Available on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>)>, provided by the ProjectedOrderedQueryRange2 extension

Offset ProjectedOrderedQueryRange using OFFSET clause.

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

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

Offset ProjectedOrderedQueryRange using OFFSET clause.

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

Available on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>)>, provided by the ProjectedOrderedQueryRange3 extension

Offset ProjectedOrderedQueryRange using OFFSET 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 ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the ProjectedOrderedQueryRange4 extension

Order ProjectedOrderedQueryRange 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 ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>, provided by the ProjectedOrderedQueryRange6 extension

Order ProjectedOrderedQueryRange using ORDER BY 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 ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>)>, provided by the ProjectedOrderedQueryRange3 extension

Order ProjectedOrderedQueryRange 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 ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the ProjectedOrderedQueryRange7 extension

Order ProjectedOrderedQueryRange using ORDER BY clause.

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

Available on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>)>, provided by the ProjectedOrderedQueryRange2 extension

Order ProjectedOrderedQueryRange 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 ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the ProjectedOrderedQueryRange8 extension

Order ProjectedOrderedQueryRange using ORDER BY clause.

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

Available on ProjectedOrderedQueryRange<(Expr<A>)>, provided by the ProjectedOrderedQueryRange1 extension

Order ProjectedOrderedQueryRange 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 ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the ProjectedOrderedQueryRange5 extension

Order ProjectedOrderedQueryRange using ORDER BY clause.

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

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

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

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

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

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

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

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

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

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

Available on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>)>, provided by the ProjectedOrderedQueryRange3 extension

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

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

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

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

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

Available on ProjectedOrderedQueryRange<(Expr<A>, Expr<B>)>, provided by the ProjectedOrderedQueryRange2 extension

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

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

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

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

stream() → Stream<A>

Available on ProjectedOrderedQueryRange<(Expr<A>)>, provided by the ProjectedOrderedQueryRange1 extension

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

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited