ProjectedOrderedSubQueryRange<T extends Record> class final Writing queries

A SubQuery 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 ProjectedOrderedSubQuery 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 SubQuery using asSubQuery. 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 asSubQuery, because these must create subqueries which discards the ordering.

Available extensions

• ProjectedOrderedSubQueryRange1
• ProjectedOrderedSubQueryRange1Ext
• ProjectedOrderedSubQueryRange2
• ProjectedOrderedSubQueryRange3
• ProjectedOrderedSubQueryRange4
• ProjectedOrderedSubQueryRange5
• ProjectedOrderedSubQueryRange6
• ProjectedOrderedSubQueryRange7
• ProjectedOrderedSubQueryRange8
• ProjectedOrderedSubQueryRangeExt

Properties

asSubQuery → SubQuery<T>

Available on ProjectedOrderedSubQueryRange<T>, provided by the ProjectedOrderedSubQueryRangeExt extension

Wrap this as unordered SubQuery.

no setter

first → Expr<T?>

Available on ProjectedOrderedSubQueryRange<(Expr<T>)>, provided by the ProjectedOrderedSubQueryRange1Ext 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) → ProjectedOrderedSubQueryRange<(Expr<A>)>

Available on ProjectedOrderedSubQueryRange<(Expr<A>)>, provided by the ProjectedOrderedSubQueryRange1 extension

Limit ProjectedOrderedSubQueryRange using LIMIT clause.

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

Available on ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>)>, provided by the ProjectedOrderedSubQueryRange2 extension

Limit ProjectedOrderedSubQueryRange using LIMIT clause.

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

Available on ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>)>, provided by the ProjectedOrderedSubQueryRange3 extension

Limit ProjectedOrderedSubQueryRange using LIMIT clause.

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

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

Limit ProjectedOrderedSubQueryRange using LIMIT clause.

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

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

Limit ProjectedOrderedSubQueryRange using LIMIT clause.

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

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

Limit ProjectedOrderedSubQueryRange using LIMIT clause.

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

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

Limit ProjectedOrderedSubQueryRange using LIMIT clause.

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

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

Limit ProjectedOrderedSubQueryRange using LIMIT clause.

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

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

Available on ProjectedOrderedSubQueryRange<(Expr<A>)>, provided by the ProjectedOrderedSubQueryRange1 extension

Offset ProjectedOrderedSubQueryRange using OFFSET clause.

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

Available on ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>)>, provided by the ProjectedOrderedSubQueryRange2 extension

Offset ProjectedOrderedSubQueryRange using OFFSET clause.

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

Available on ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>)>, provided by the ProjectedOrderedSubQueryRange3 extension

Offset ProjectedOrderedSubQueryRange using OFFSET clause.

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

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

Offset ProjectedOrderedSubQueryRange using OFFSET clause.

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

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

Offset ProjectedOrderedSubQueryRange using OFFSET clause.

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

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

Offset ProjectedOrderedSubQueryRange using OFFSET clause.

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

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

Offset ProjectedOrderedSubQueryRange using OFFSET clause.

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

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

Offset ProjectedOrderedSubQueryRange using OFFSET clause.

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

Available on ProjectedOrderedSubQueryRange<(Expr<A>)>, provided by the ProjectedOrderedSubQueryRange1 extension

Order ProjectedOrderedSubQueryRange using ORDER BY clause.

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

Available on ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>)>, provided by the ProjectedOrderedSubQueryRange2 extension

Order ProjectedOrderedSubQueryRange 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 ProjectedOrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>)>, provided by the ProjectedOrderedSubQueryRange3 extension

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

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

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

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

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

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

Order ProjectedOrderedSubQueryRange using ORDER BY clause.

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited