OrderedSubQueryRange<T extends Record> class final Writing queries

A SubQuery which has an order imposed by .orderBy and is limited to a range by .limit or .offset.

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

• .limit,
• .offset, and,
• .select.

Tip

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

To use .where after imposing a range with .limit or .offset you must use asSubQuery, because .where will create a subquery which discards the ordering.

Available extensions

• OrderedSubQueryRange1
• OrderedSubQueryRange1Ext
• OrderedSubQueryRange2
• OrderedSubQueryRange3
• OrderedSubQueryRange4
• OrderedSubQueryRange5
• OrderedSubQueryRange6
• OrderedSubQueryRange7
• OrderedSubQueryRange8
• OrderedSubQueryRangeExt

Properties

asSubQuery → SubQuery<T>

Available on OrderedSubQueryRange<T>, provided by the OrderedSubQueryRangeExt extension

Wrap this as unordered SubQuery.

no setter

first → Expr<T?>

Available on OrderedSubQueryRange<(Expr<T>)>, provided by the OrderedSubQueryRange1Ext extension

Use the first row of this query as subquery expression.

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

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

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

Limit OrderedSubQueryRange using LIMIT clause.

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

Available on OrderedSubQueryRange<(Expr<A>)>, provided by the OrderedSubQueryRange1 extension

Limit OrderedSubQueryRange using LIMIT clause.

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

Available on OrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedSubQueryRange3 extension

Limit OrderedSubQueryRange using LIMIT clause.

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

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

Limit OrderedSubQueryRange using LIMIT clause.

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

Available on OrderedSubQueryRange<(Expr<A>, Expr<B>)>, provided by the OrderedSubQueryRange2 extension

Limit OrderedSubQueryRange using LIMIT clause.

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

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

Limit OrderedSubQueryRange using LIMIT clause.

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

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

Limit OrderedSubQueryRange using LIMIT clause.

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

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

Limit OrderedSubQueryRange using LIMIT clause.

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

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

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

Offset OrderedSubQueryRange using OFFSET clause.

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

Available on OrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedSubQueryRange3 extension

Offset OrderedSubQueryRange using OFFSET clause.

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

Available on OrderedSubQueryRange<(Expr<A>)>, provided by the OrderedSubQueryRange1 extension

Offset OrderedSubQueryRange using OFFSET clause.

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

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

Offset OrderedSubQueryRange using OFFSET clause.

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

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

Offset OrderedSubQueryRange using OFFSET clause.

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

Available on OrderedSubQueryRange<(Expr<A>, Expr<B>)>, provided by the OrderedSubQueryRange2 extension

Offset OrderedSubQueryRange using OFFSET clause.

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

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

Offset OrderedSubQueryRange using OFFSET clause.

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

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

Offset OrderedSubQueryRange using OFFSET 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)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

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

Order OrderedSubQueryRange 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)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

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

Order OrderedSubQueryRange using ORDER BY clause.

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

Available on OrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedSubQueryRange3 extension

Order OrderedSubQueryRange using ORDER BY clause.

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

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

Order OrderedSubQueryRange 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)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>)>

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

Order OrderedSubQueryRange 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)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

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

Order OrderedSubQueryRange using ORDER BY clause.

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

Available on OrderedSubQueryRange<(Expr<A>, Expr<B>)>, provided by the OrderedSubQueryRange2 extension

Order OrderedSubQueryRange using ORDER BY clause.

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

Available on OrderedSubQueryRange<(Expr<A>)>, provided by the OrderedSubQueryRange1 extension

Order OrderedSubQueryRange using ORDER BY clause.

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

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

Create a projection of this OrderedSubQueryRange 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)) → ProjectedOrderedSubQueryRange<T>

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

Create a projection of this OrderedSubQueryRange using SELECT clause.

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

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

Create a projection of this OrderedSubQueryRange using SELECT clause.

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

Available on OrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedSubQueryRange3 extension

Create a projection of this OrderedSubQueryRange 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)) → ProjectedOrderedSubQueryRange<T>

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

Create a projection of this OrderedSubQueryRange using SELECT clause.

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

Available on OrderedSubQueryRange<(Expr<A>, Expr<B>)>, provided by the OrderedSubQueryRange2 extension

Create a projection of this OrderedSubQueryRange using SELECT clause.

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

Available on OrderedSubQueryRange<(Expr<A>)>, provided by the OrderedSubQueryRange1 extension

Create a projection of this OrderedSubQueryRange 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)) → ProjectedOrderedSubQueryRange<T>

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

Create a projection of this OrderedSubQueryRange using SELECT clause.

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited