Uses of Interface
org.hibernate.query.criteria.JpaWindow
Packages that use JpaWindow
Package
Description
The JPA-standard criteria query API defines all the operations needed express
any query written in standard JPQL.
SPI for extending
HibernateCriteriaBuilder
with additional functionality by registering a Service
.This package defines a semantic model of HQL queries.
Package for the SQM-backed Query implementation details
Nodes representing expressions in the SQM tree.
-
Uses of JpaWindow in org.hibernate.query.criteria
Methods in org.hibernate.query.criteria that return JpaWindowModifier and TypeMethodDescriptionHibernateCriteriaBuilder.createWindow()
Create an emptyJpaWindow
to use with window and aggregate functions.JpaWindow.frameExclude
(FrameExclusion frameExclusion) Set aFrameExclusion
for this window's frame.JpaWindow.frameGroups
(JpaWindowFrame startFrame, JpaWindowFrame endFrame) Add aGROUPS
frame clause to the window and define start and endJpaWindowFrame
specifications.JpaWindow.frameRange
(JpaWindowFrame startFrame, JpaWindowFrame endFrame) Add aRANGE
frame clause to the window and define start and endJpaWindowFrame
specifications.JpaWindow.frameRows
(JpaWindowFrame startFrame, JpaWindowFrame endFrame) Add aROWS
frame clause to the window and define start and endJpaWindowFrame
specifications.Add order by expressions to the window.JpaWindow.partitionBy
(Expression<?>... expressions) Add partition by expressions to the window.Methods in org.hibernate.query.criteria with parameters of type JpaWindowModifier and TypeMethodDescription<T> JpaExpression<T[]>
HibernateCriteriaBuilder.arrayAgg
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<? extends T> argument) Create aarray_agg
ordered set-aggregate function expression.<T> JpaExpression<T[]>
HibernateCriteriaBuilder.arrayAgg
(JpaOrder order, JpaWindow window, Expression<? extends T> argument) <N extends Number>
JpaExpression<Double>HibernateCriteriaBuilder.avg
(Expression<N> argument, JpaPredicate filter, JpaWindow window) Create anavg
aggregate function expression.<N extends Number>
JpaExpression<Double>HibernateCriteriaBuilder.avg
(Expression<N> argument, JpaWindow window) HibernateCriteriaBuilder.count
(Expression<?> argument, JpaPredicate filter, JpaWindow window) Create acount
aggregate function expression.HibernateCriteriaBuilder.count
(Expression<?> argument, JpaWindow window) Create acume_dist
window function expression.Create adense_rank
window function expression.<T> JpaExpression<T>
HibernateCriteriaBuilder.firstValue
(Expression<T> argument, JpaWindow window) Create afirst_value
window function expression.<T> JpaExpression<T>
HibernateCriteriaBuilder.functionAggregate
(String name, Class<T> type, JpaPredicate filter, JpaWindow window, Expression<?>... args) Create a generic aggregate function expression.<T> JpaExpression<T>
HibernateCriteriaBuilder.functionAggregate
(String name, Class<T> type, JpaWindow window, Expression<?>... args) <T> JpaExpression<T>
HibernateCriteriaBuilder.functionWithinGroup
(String name, Class<T> type, JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... args) Create a generic ordered set-aggregate function expression.<T> JpaExpression<T>
HibernateCriteriaBuilder.functionWithinGroup
(String name, Class<T> type, JpaOrder order, JpaWindow window, Expression<?>... args) <T> JpaExpression<T>
HibernateCriteriaBuilder.lastValue
(Expression<T> argument, JpaWindow window) Create alast_value
window function expression.HibernateCriteriaBuilder.listagg
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, Expression<String> separator) Create alistagg
ordered set-aggregate function expression.HibernateCriteriaBuilder.listagg
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, String separator) HibernateCriteriaBuilder.listagg
(JpaOrder order, JpaWindow window, Expression<String> argument, Expression<String> separator) HibernateCriteriaBuilder.listagg
(JpaOrder order, JpaWindow window, Expression<String> argument, String separator) <T> JpaExpression<T>
HibernateCriteriaBuilder.mode
(JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) Create amode
ordered set-aggregate function expression.<T> JpaExpression<T>
HibernateCriteriaBuilder.mode
(JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) <T> JpaExpression<T>
HibernateCriteriaBuilder.nthValue
(Expression<T> argument, int n, JpaWindow window) <T> JpaExpression<T>
HibernateCriteriaBuilder.nthValue
(Expression<T> argument, Expression<Integer> n, JpaWindow window) Create anth_value
window function expression.<T> JpaExpression<T>
HibernateCriteriaBuilder.percentileCont
(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) Create apercentile_cont
ordered set-aggregate function expression.<T> JpaExpression<T>
HibernateCriteriaBuilder.percentileCont
(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) <T> JpaExpression<T>
HibernateCriteriaBuilder.percentileDisc
(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) Create apercentile_disc
ordered set-aggregate function expression.<T> JpaExpression<T>
HibernateCriteriaBuilder.percentileDisc
(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) HibernateCriteriaBuilder.percentRank
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments) Create apercent_rank
ordered set-aggregate function expression.HibernateCriteriaBuilder.percentRank
(JpaOrder order, JpaWindow window, Expression<?>... arguments) HibernateCriteriaBuilder.percentRank
(JpaWindow window) Create apercent_rank
window function expression.HibernateCriteriaBuilder.rank
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments) Create arank
ordered set-aggregate function expression.HibernateCriteriaBuilder.rank
(JpaOrder order, JpaWindow window, Expression<?>... arguments) Create arank
window function expression.Create arow_number
window function expression.<N extends Number>
JpaExpression<Number>HibernateCriteriaBuilder.sum
(Expression<N> argument, JpaPredicate filter, JpaWindow window) Create asum
aggregate function expression.<N extends Number>
JpaExpression<Number>HibernateCriteriaBuilder.sum
(Expression<N> argument, JpaWindow window) <T> JpaExpression<T>
HibernateCriteriaBuilder.windowFunction
(String name, Class<T> type, JpaWindow window, Expression<?>... args) Create a generic window function expression that will be applied over the specifiedwindow
.HibernateCriteriaBuilder.xmlagg
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?> argument) Create axmlagg
ordered set-aggregate function expression.HibernateCriteriaBuilder.xmlagg
(JpaOrder order, JpaWindow window, Expression<?> argument) -
Uses of JpaWindow in org.hibernate.query.criteria.spi
Methods in org.hibernate.query.criteria.spi that return JpaWindowMethods in org.hibernate.query.criteria.spi with parameters of type JpaWindowModifier and TypeMethodDescription<T> JpaExpression<T[]>
HibernateCriteriaBuilderDelegate.arrayAgg
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<? extends T> argument) <T> JpaExpression<T[]>
HibernateCriteriaBuilderDelegate.arrayAgg
(JpaOrder order, JpaWindow window, Expression<? extends T> argument) <N extends Number>
JpaExpression<Double>HibernateCriteriaBuilderDelegate.avg
(Expression<N> argument, JpaPredicate filter, JpaWindow window) <N extends Number>
JpaExpression<Double>HibernateCriteriaBuilderDelegate.avg
(Expression<N> argument, JpaWindow window) HibernateCriteriaBuilderDelegate.count
(Expression<?> argument, JpaPredicate filter, JpaWindow window) HibernateCriteriaBuilderDelegate.count
(Expression<?> argument, JpaWindow window) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.firstValue
(Expression<T> argument, JpaWindow window) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.functionAggregate
(String name, Class<T> type, JpaPredicate filter, JpaWindow window, Expression<?>... args) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.functionAggregate
(String name, Class<T> type, JpaWindow window, Expression<?>... args) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.functionWithinGroup
(String name, Class<T> type, JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... args) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.functionWithinGroup
(String name, Class<T> type, JpaOrder order, JpaWindow window, Expression<?>... args) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.lastValue
(Expression<T> argument, JpaWindow window) HibernateCriteriaBuilderDelegate.listagg
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, Expression<String> separator) HibernateCriteriaBuilderDelegate.listagg
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, String separator) HibernateCriteriaBuilderDelegate.listagg
(JpaOrder order, JpaWindow window, Expression<String> argument, Expression<String> separator) HibernateCriteriaBuilderDelegate.listagg
(JpaOrder order, JpaWindow window, Expression<String> argument, String separator) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.mode
(JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.mode
(JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.nthValue
(Expression<T> argument, int n, JpaWindow window) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.nthValue
(Expression<T> argument, Expression<Integer> n, JpaWindow window) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.percentileCont
(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.percentileCont
(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.percentileDisc
(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.percentileDisc
(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) HibernateCriteriaBuilderDelegate.percentRank
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments) HibernateCriteriaBuilderDelegate.percentRank
(JpaOrder order, JpaWindow window, Expression<?>... arguments) HibernateCriteriaBuilderDelegate.percentRank
(JpaWindow window) HibernateCriteriaBuilderDelegate.rank
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments) HibernateCriteriaBuilderDelegate.rank
(JpaOrder order, JpaWindow window, Expression<?>... arguments) <N extends Number>
JpaExpression<Number>HibernateCriteriaBuilderDelegate.sum
(Expression<N> argument, JpaPredicate filter, JpaWindow window) <N extends Number>
JpaExpression<Number>HibernateCriteriaBuilderDelegate.sum
(Expression<N> argument, JpaWindow window) <T> JpaExpression<T>
HibernateCriteriaBuilderDelegate.windowFunction
(String name, Class<T> type, JpaWindow window, Expression<?>... args) HibernateCriteriaBuilderDelegate.xmlagg
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?> argument) HibernateCriteriaBuilderDelegate.xmlagg
(JpaOrder order, JpaWindow window, Expression<?> argument) -
Uses of JpaWindow in org.hibernate.query.sqm
Methods in org.hibernate.query.sqm with parameters of type JpaWindowModifier and TypeMethodDescription<T> SqmExpression<T[]>
NodeBuilder.arrayAgg
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<? extends T> argument) <T> SqmExpression<T[]>
NodeBuilder.arrayAgg
(JpaOrder order, JpaWindow window, Expression<? extends T> argument) NodeBuilder.xmlagg
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?> argument) NodeBuilder.xmlagg
(JpaOrder order, JpaWindow window, Expression<?> argument) -
Uses of JpaWindow in org.hibernate.query.sqm.internal
Methods in org.hibernate.query.sqm.internal with parameters of type JpaWindowModifier and TypeMethodDescription<T> SqmExpression<T[]>
SqmCriteriaNodeBuilder.arrayAgg
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<? extends T> argument) <T> SqmExpression<T[]>
SqmCriteriaNodeBuilder.arrayAgg
(JpaOrder order, JpaWindow window, Expression<? extends T> argument) <N extends Number>
SqmExpression<Double>SqmCriteriaNodeBuilder.avg
(Expression<N> argument, JpaPredicate filter, JpaWindow window) <N extends Number>
SqmExpression<Double>SqmCriteriaNodeBuilder.avg
(Expression<N> argument, JpaWindow window) SqmCriteriaNodeBuilder.count
(Expression<?> argument, JpaPredicate filter, JpaWindow window) SqmCriteriaNodeBuilder.count
(Expression<?> argument, JpaWindow window) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.firstValue
(Expression<T> argument, JpaWindow window) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.functionAggregate
(String name, Class<T> type, JpaPredicate filter, JpaWindow window, Expression<?>... args) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.functionAggregate
(String name, Class<T> type, JpaWindow window, Expression<?>... args) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.functionWithinGroup
(String name, Class<T> type, JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... args) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.functionWithinGroup
(String name, Class<T> type, JpaOrder order, JpaWindow window, Expression<?>... args) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.lastValue
(Expression<T> argument, JpaWindow window) SqmCriteriaNodeBuilder.listagg
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, Expression<String> separator) SqmCriteriaNodeBuilder.listagg
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, String separator) SqmCriteriaNodeBuilder.listagg
(JpaOrder order, JpaWindow window, Expression<String> argument, Expression<String> separator) SqmCriteriaNodeBuilder.listagg
(JpaOrder order, JpaWindow window, Expression<String> argument, String separator) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.mode
(JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.mode
(JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.nthValue
(Expression<T> argument, int n, JpaWindow window) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.nthValue
(Expression<T> argument, Expression<Integer> n, JpaWindow window) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.percentileCont
(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.percentileCont
(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.percentileDisc
(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.percentileDisc
(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, NullPrecedence nullPrecedence) SqmCriteriaNodeBuilder.percentRank
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments) SqmCriteriaNodeBuilder.percentRank
(JpaOrder order, JpaWindow window, Expression<?>... arguments) SqmCriteriaNodeBuilder.percentRank
(JpaWindow window) SqmCriteriaNodeBuilder.rank
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments) SqmCriteriaNodeBuilder.rank
(JpaOrder order, JpaWindow window, Expression<?>... arguments) <N extends Number>
SqmExpression<Number>SqmCriteriaNodeBuilder.sum
(Expression<N> argument, JpaPredicate filter, JpaWindow window) <N extends Number>
SqmExpression<Number>SqmCriteriaNodeBuilder.sum
(Expression<N> argument, JpaWindow window) <T> SqmExpression<T>
SqmCriteriaNodeBuilder.windowFunction
(String name, Class<T> type, JpaWindow window, Expression<?>... args) SqmCriteriaNodeBuilder.xmlagg
(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?> argument) SqmCriteriaNodeBuilder.xmlagg
(JpaOrder order, JpaWindow window, Expression<?> argument) -
Uses of JpaWindow in org.hibernate.query.sqm.tree.expression
Classes in org.hibernate.query.sqm.tree.expression that implement JpaWindowMethods in org.hibernate.query.sqm.tree.expression that return JpaWindowModifier and TypeMethodDescriptionSqmWindow.frameExclude
(FrameExclusion frameExclusion) SqmWindow.frameGroups
(JpaWindowFrame startFrame, JpaWindowFrame endFrame) SqmWindow.frameRange
(JpaWindowFrame startFrame, JpaWindowFrame endFrame) SqmWindow.frameRows
(JpaWindowFrame startFrame, JpaWindowFrame endFrame) SqmWindow.partitionBy
(Expression<?>... expressions)