OrderedSubQuery<T extends Record> class final Writing queries

A SubQuery which has an order imposed by .orderBy.

An OrderedSubQuery 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 SubQuery using asSubQuery. 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 asSubQuery, if you wish to do such operations.

Available extensions

• OrderedSubQuery1
• OrderedSubQuery1Ext
• OrderedSubQuery2
• OrderedSubQuery3
• OrderedSubQuery4
• OrderedSubQuery5
• OrderedSubQuery6
• OrderedSubQuery7
• OrderedSubQuery8
• OrderedSubQueryExt

Properties

asSubQuery → SubQuery<T>

Available on OrderedSubQuery<T>, provided by the OrderedSubQueryExt extension

Wrap this as unordered SubQuery.

no setter

first → Expr<T?>

Available on OrderedSubQuery<(Expr<T>)>, provided by the OrderedSubQuery1Ext 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

distinct() → ProjectedOrderedSubQuery<T>

Available on OrderedSubQuery<T>, provided by the OrderedSubQueryExt extension

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

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

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

Limit OrderedSubQuery using LIMIT clause.

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

Available on OrderedSubQuery<(Expr<A>)>, provided by the OrderedSubQuery1 extension

Limit OrderedSubQuery using LIMIT clause.

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

Available on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedSubQuery3 extension

Limit OrderedSubQuery using LIMIT clause.

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

Available on OrderedSubQuery<(Expr<A>, Expr<B>)>, provided by the OrderedSubQuery2 extension

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

Limit OrderedSubQuery using LIMIT clause.

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

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

Limit OrderedSubQuery using LIMIT clause.

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

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

Limit OrderedSubQuery using LIMIT clause.

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

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

Limit OrderedSubQuery 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>, Expr<E>, Expr<F>, Expr<G>)>

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

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

Offset OrderedSubQuery using OFFSET clause.

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

Available on OrderedSubQuery<(Expr<A>)>, provided by the OrderedSubQuery1 extension

Offset OrderedSubQuery using OFFSET clause.

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

Available on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedSubQuery3 extension

Offset OrderedSubQuery using OFFSET clause.

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

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

Offset OrderedSubQuery using OFFSET clause.

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

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

Offset OrderedSubQuery using OFFSET clause.

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

Available on OrderedSubQuery<(Expr<A>, Expr<B>)>, provided by the OrderedSubQuery2 extension

Offset OrderedSubQuery using OFFSET clause.

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

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

Offset OrderedSubQuery using OFFSET clause.

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

Available on OrderedSubQuery<(Expr<A>, Expr<B>)>, provided by the OrderedSubQuery2 extension

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

Order OrderedSubQuery using ORDER BY clause.

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

Available on OrderedSubQuery<(Expr<A>)>, provided by the OrderedSubQuery1 extension

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

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

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

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

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

Order OrderedSubQuery using ORDER BY clause.

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

Available on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedSubQuery3 extension

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

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

Create a projection of this OrderedSubQuery using SELECT clause.

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

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

Create a projection of this OrderedSubQuery using SELECT clause.

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

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

Create a projection of this OrderedSubQuery using SELECT clause.

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

Available on OrderedSubQuery<(Expr<A>)>, provided by the OrderedSubQuery1 extension

Create a projection of this OrderedSubQuery using SELECT clause.

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

Available on OrderedSubQuery<(Expr<A>, Expr<B>)>, provided by the OrderedSubQuery2 extension

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

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

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

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

Create a projection of this OrderedSubQuery using SELECT clause.

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

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

Filter OrderedSubQuery using WHERE clause.

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

Available on OrderedSubQuery<(Expr<A>, Expr<B>)>, provided by the OrderedSubQuery2 extension

Filter OrderedSubQuery using WHERE clause.

where(Expr<bool> conditionBuilder(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 OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the OrderedSubQuery5 extension

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

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

Filter OrderedSubQuery using WHERE clause.

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

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

Filter OrderedSubQuery using WHERE clause.

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

Available on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedSubQuery3 extension

Filter OrderedSubQuery using WHERE clause.

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

Available on OrderedSubQuery<(Expr<A>)>, provided by the OrderedSubQuery1 extension

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

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

Filter OrderedSubQuery using WHERE clause.

Operators

operator ==(Object other) → bool

The equality operator.

inherited