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 emptyJpaWindowto use with window and aggregate functions.JpaWindow.frameExclude(FrameExclusion frameExclusion) Set aFrameExclusionfor this window's frame.JpaWindow.frameGroups(JpaWindowFrame startFrame, JpaWindowFrame endFrame) Add aGROUPSframe clause to the window and define start and endJpaWindowFramespecifications.JpaWindow.frameRange(JpaWindowFrame startFrame, JpaWindowFrame endFrame) Add aRANGEframe clause to the window and define start and endJpaWindowFramespecifications.JpaWindow.frameRows(JpaWindowFrame startFrame, JpaWindowFrame endFrame) Add aROWSframe clause to the window and define start and endJpaWindowFramespecifications.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_aggordered 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 anavgaggregate function expression.<N extends Number>
JpaExpression<Double> HibernateCriteriaBuilder.avg(Expression<N> argument, JpaWindow window) HibernateCriteriaBuilder.count(Expression<?> argument, JpaPredicate filter, JpaWindow window) Create acountaggregate function expression.HibernateCriteriaBuilder.count(Expression<?> argument, JpaWindow window) Create acume_distwindow function expression.Create adense_rankwindow function expression.<T> JpaExpression<T> HibernateCriteriaBuilder.firstValue(Expression<T> argument, JpaWindow window) Create afirst_valuewindow 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_valuewindow function expression.HibernateCriteriaBuilder.listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, Expression<String> separator) Create alistaggordered 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, Nulls nullPrecedence) Create amodeordered set-aggregate function expression.<T> JpaExpression<T> HibernateCriteriaBuilder.mode(JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls 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_valuewindow function expression.<T> JpaExpression<T> HibernateCriteriaBuilder.percentileCont(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence) Create apercentile_contordered set-aggregate function expression.<T> JpaExpression<T> HibernateCriteriaBuilder.percentileCont(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence) <T> JpaExpression<T> HibernateCriteriaBuilder.percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence) Create apercentile_discordered set-aggregate function expression.<T> JpaExpression<T> HibernateCriteriaBuilder.percentileDisc(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence) HibernateCriteriaBuilder.percentRank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments) Create apercent_rankordered set-aggregate function expression.HibernateCriteriaBuilder.percentRank(JpaOrder order, JpaWindow window, Expression<?>... arguments) HibernateCriteriaBuilder.percentRank(JpaWindow window) Create apercent_rankwindow function expression.HibernateCriteriaBuilder.rank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments) Create arankordered set-aggregate function expression.HibernateCriteriaBuilder.rank(JpaOrder order, JpaWindow window, Expression<?>... arguments) Create arankwindow function expression.Create arow_numberwindow function expression.<N extends Number>
JpaExpression<Number> HibernateCriteriaBuilder.sum(Expression<N> argument, JpaPredicate filter, JpaWindow window) Create asumaggregate 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 axmlaggordered 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, Nulls nullPrecedence) <T> JpaExpression<T> HibernateCriteriaBuilderDelegate.mode(JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls 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, Nulls nullPrecedence) <T> JpaExpression<T> HibernateCriteriaBuilderDelegate.percentileCont(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence) <T> JpaExpression<T> HibernateCriteriaBuilderDelegate.percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence) <T> JpaExpression<T> HibernateCriteriaBuilderDelegate.percentileDisc(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls 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, Nulls nullPrecedence) <T> SqmExpression<T> SqmCriteriaNodeBuilder.mode(JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls 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, Nulls nullPrecedence) <T> SqmExpression<T> SqmCriteriaNodeBuilder.percentileCont(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence) <T> SqmExpression<T> SqmCriteriaNodeBuilder.percentileDisc(Expression<? extends Number> argument, JpaPredicate filter, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls nullPrecedence) <T> SqmExpression<T> SqmCriteriaNodeBuilder.percentileDisc(Expression<? extends Number> argument, JpaWindow window, Expression<T> sortExpression, SortDirection sortOrder, Nulls 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)