Uses of Interface
org.hibernate.query.criteria.JpaWindow
-
Packages that use JpaWindow Package Description org.hibernate.query.criteria The JPA-standard criteria query API defines all the operations needed express any query written in standard JPQL.org.hibernate.query.criteria.spi SPI for extendingHibernateCriteriaBuilder
with additional functionality by registering aService
.org.hibernate.query.sqm.internal Package for the SQM-backed Query implementation detailsorg.hibernate.query.sqm.tree.expression Nodes representing expressions in the SQM tree. -
-
Uses of JpaWindow in org.hibernate.query.criteria
Methods in org.hibernate.query.criteria that return JpaWindow Modifier and Type Method Description JpaWindow
HibernateCriteriaBuilder. createWindow()
Create an emptyJpaWindow
to use with window and aggregate functions.JpaWindow
JpaWindow. frameExclude(FrameExclusion frameExclusion)
Set aFrameExclusion
for this window's frame.JpaWindow
JpaWindow. frameGroups(JpaWindowFrame startFrame, JpaWindowFrame endFrame)
Add aGROUPS
frame clause to the window and define start and endJpaWindowFrame
specifications.JpaWindow
JpaWindow. frameRange(JpaWindowFrame startFrame, JpaWindowFrame endFrame)
Add aRANGE
frame clause to the window and define start and endJpaWindowFrame
specifications.JpaWindow
JpaWindow. frameRows(JpaWindowFrame startFrame, JpaWindowFrame endFrame)
Add aROWS
frame clause to the window and define start and endJpaWindowFrame
specifications.JpaWindow
JpaWindow. orderBy(Order... expressions)
Add order by expressions to the window.JpaWindow
JpaWindow. partitionBy(Expression<?>... expressions)
Add partition by expressions to the window.Methods in org.hibernate.query.criteria with parameters of type JpaWindow Modifier and Type Method Description <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)
JpaExpression<Long>
HibernateCriteriaBuilder. count(Expression<?> argument, JpaPredicate filter, JpaWindow window)
Create acount
aggregate function expression.JpaExpression<Long>
HibernateCriteriaBuilder. count(Expression<?> argument, JpaWindow window)
JpaExpression<Double>
HibernateCriteriaBuilder. cumeDist(JpaWindow window)
Create acume_dist
window function expression.JpaExpression<Long>
HibernateCriteriaBuilder. denseRank(JpaWindow window)
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.JpaExpression<String>
HibernateCriteriaBuilder. listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, Expression<String> separator)
Create alistagg
ordered set-aggregate function expression.JpaExpression<String>
HibernateCriteriaBuilder. listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, String separator)
JpaExpression<String>
HibernateCriteriaBuilder. listagg(JpaOrder order, JpaWindow window, Expression<String> argument, Expression<String> separator)
JpaExpression<String>
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)
JpaExpression<Double>
HibernateCriteriaBuilder. percentRank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)
Create apercent_rank
ordered set-aggregate function expression.JpaExpression<Double>
HibernateCriteriaBuilder. percentRank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
JpaExpression<Double>
HibernateCriteriaBuilder. percentRank(JpaWindow window)
Create apercent_rank
window function expression.JpaExpression<Long>
HibernateCriteriaBuilder. rank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)
Create arank
ordered set-aggregate function expression.JpaExpression<Long>
HibernateCriteriaBuilder. rank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
JpaExpression<Long>
HibernateCriteriaBuilder. rank(JpaWindow window)
Create arank
window function expression.JpaExpression<Long>
HibernateCriteriaBuilder. rowNumber(JpaWindow window)
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
. -
Uses of JpaWindow in org.hibernate.query.criteria.spi
Methods in org.hibernate.query.criteria.spi that return JpaWindow Modifier and Type Method Description JpaWindow
HibernateCriteriaBuilderDelegate. createWindow()
Methods in org.hibernate.query.criteria.spi with parameters of type JpaWindow Modifier and Type Method Description <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)
JpaExpression<Long>
HibernateCriteriaBuilderDelegate. count(Expression<?> argument, JpaPredicate filter, JpaWindow window)
JpaExpression<Long>
HibernateCriteriaBuilderDelegate. count(Expression<?> argument, JpaWindow window)
JpaExpression<Double>
HibernateCriteriaBuilderDelegate. cumeDist(JpaWindow window)
JpaExpression<Long>
HibernateCriteriaBuilderDelegate. denseRank(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)
JpaExpression<String>
HibernateCriteriaBuilderDelegate. listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, Expression<String> separator)
JpaExpression<String>
HibernateCriteriaBuilderDelegate. listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, String separator)
JpaExpression<String>
HibernateCriteriaBuilderDelegate. listagg(JpaOrder order, JpaWindow window, Expression<String> argument, Expression<String> separator)
JpaExpression<String>
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)
JpaExpression<Double>
HibernateCriteriaBuilderDelegate. percentRank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)
JpaExpression<Double>
HibernateCriteriaBuilderDelegate. percentRank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
JpaExpression<Double>
HibernateCriteriaBuilderDelegate. percentRank(JpaWindow window)
JpaExpression<Long>
HibernateCriteriaBuilderDelegate. rank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)
JpaExpression<Long>
HibernateCriteriaBuilderDelegate. rank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
JpaExpression<Long>
HibernateCriteriaBuilderDelegate. rank(JpaWindow window)
JpaExpression<Long>
HibernateCriteriaBuilderDelegate. rowNumber(JpaWindow window)
<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)
-
Uses of JpaWindow in org.hibernate.query.sqm.internal
Methods in org.hibernate.query.sqm.internal with parameters of type JpaWindow Modifier and Type Method Description <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)
SqmExpression<Long>
SqmCriteriaNodeBuilder. count(Expression<?> argument, JpaPredicate filter, JpaWindow window)
SqmExpression<Long>
SqmCriteriaNodeBuilder. count(Expression<?> argument, JpaWindow window)
SqmExpression<Double>
SqmCriteriaNodeBuilder. cumeDist(JpaWindow window)
SqmExpression<Long>
SqmCriteriaNodeBuilder. denseRank(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)
SqmExpression<String>
SqmCriteriaNodeBuilder. listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, Expression<String> separator)
SqmExpression<String>
SqmCriteriaNodeBuilder. listagg(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<String> argument, String separator)
SqmExpression<String>
SqmCriteriaNodeBuilder. listagg(JpaOrder order, JpaWindow window, Expression<String> argument, Expression<String> separator)
SqmExpression<String>
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)
SqmExpression<Double>
SqmCriteriaNodeBuilder. percentRank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)
SqmExpression<Double>
SqmCriteriaNodeBuilder. percentRank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
SqmExpression<Double>
SqmCriteriaNodeBuilder. percentRank(JpaWindow window)
SqmExpression<Long>
SqmCriteriaNodeBuilder. rank(JpaOrder order, JpaPredicate filter, JpaWindow window, Expression<?>... arguments)
SqmExpression<Long>
SqmCriteriaNodeBuilder. rank(JpaOrder order, JpaWindow window, Expression<?>... arguments)
SqmExpression<Long>
SqmCriteriaNodeBuilder. rank(JpaWindow window)
SqmExpression<Long>
SqmCriteriaNodeBuilder. rowNumber(JpaWindow window)
<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)
-
Uses of JpaWindow in org.hibernate.query.sqm.tree.expression
Classes in org.hibernate.query.sqm.tree.expression that implement JpaWindow Modifier and Type Class Description class
SqmWindow
Methods in org.hibernate.query.sqm.tree.expression that return JpaWindow Modifier and Type Method Description JpaWindow
SqmWindow. frameExclude(FrameExclusion frameExclusion)
JpaWindow
SqmWindow. frameGroups(JpaWindowFrame startFrame, JpaWindowFrame endFrame)
JpaWindow
SqmWindow. frameRange(JpaWindowFrame startFrame, JpaWindowFrame endFrame)
JpaWindow
SqmWindow. frameRows(JpaWindowFrame startFrame, JpaWindowFrame endFrame)
JpaWindow
SqmWindow. orderBy(Order... orders)
JpaWindow
SqmWindow. partitionBy(Expression<?>... expressions)
-