public class Having
extends java.lang.Object
AggregationInfo aggregation = new AggregationInfo(loginEnv); aggregation.addAggregationColumn("AN8", AggregationType.AGG_TYPE_SUM()); aggregation.addAggregationColumn("AN8", AggregationType.AGG_TYPE_AVG()); aggregation.addAggregationColumn("AN8", AggregationType.AGG_TYPE_MAX()); aggregation.addAggregationColumn("AN8", AggregationType.AGG_TYPE_MIN()); aggregation.addCount(); aggregation.addAggregationGroupBy("AT1"); dataAggregation.setAggregation(aggregation); aggregation.addAggregationOrderBy("AN8", AggregationType.AGG_TYPE_SUM(), OrderByDirection.ORDER_DIRECT_ASCENDING()); //having sum of AN8 in between two values Having having = new Having(loginEnv); HavingBetweenCondition havebet = having.addHavingBetweenCondition("AN8",AggregationType.AGG_TYPE_SUM()); havebet.setValues(155557, 239166); //having sum of AN8 in a list of values HavingListCondition havlc = having.addHavingListCondition("AN8", AggregationType.AGG_TYPE_SUM()); havlc.addValue(239166); havlc.addValue(44894); //having sum of AN8 greater than a value (any comparison can be uesd) having.addNumberCondition("AN8", AggregationType.AGG_TYPE_SUM(), NumericOperator.GREATER(), 39166); dataAggregation.setHaving(having);
Constructor and Description |
---|
Having(LoginEnvironment loginEnv) |
Modifier and Type | Method and Description |
---|---|
HavingBetweenCondition |
addHavingBetweenCondition(java.lang.String columnId,
AggregationType aggregType)
Deprecated.
As of release 1.5.0, replaced by
addHavingBetweenCondition(String tableId,String columnId, AggregationType aggregType) |
HavingBetweenCondition |
addHavingBetweenCondition(java.lang.String tableId,
java.lang.String columnId,
AggregationType aggregType)
Add a between condition to reduce the response to aggregation values between two other specified values.
|
HavingListCondition |
addHavingListCondition(java.lang.String columnId,
AggregationType aggregType)
Deprecated.
As of release 1.5.0, replaced by
addHavingListCondition(String tableId,String columnId, AggregationType aggregType) |
HavingListCondition |
addHavingListCondition(java.lang.String tableId,
java.lang.String columnId,
AggregationType aggregType)
Add a list condition to reduce the response to aggregation values in the list.
|
HavingNumberCondition |
addNumberCondition(java.lang.String columnId,
AggregationType aggregType,
NumericOperator numOperator,
java.math.BigDecimal value)
Deprecated.
As of release 1.5.0, replaced by
addNumberCondition(String tableId,String columnId,AggregationType aggregType, NumericOperator numOperator, BigDecimal value) |
HavingNumberCondition |
addNumberCondition(java.lang.String columnId,
AggregationType aggregType,
NumericOperator numOperator,
java.lang.Integer value)
Deprecated.
As of release 1.5.0, replaced by
addNumberCondition(String tableId,String columnId, AggregationType aggregType, NumericOperator numOperator, Integer value) |
HavingNumberCondition |
addNumberCondition(java.lang.String tableId,
java.lang.String columnId,
AggregationType aggregType,
NumericOperator numOperator,
java.math.BigDecimal value)
Add a number condition to to reduce the response to aggregation values that compare to a BigDecimal value
|
HavingNumberCondition |
addNumberCondition(java.lang.String tableId,
java.lang.String columnId,
AggregationType aggregType,
NumericOperator numOperator,
java.lang.Integer value)
Add a number condition to to reduce the response to aggregation values that compare to an Integer value
|
java.util.ArrayList<HavingCondition> |
getCondition() |
public Having(LoginEnvironment loginEnv) throws CapabilityException
CapabilityException
@Deprecated public HavingBetweenCondition addHavingBetweenCondition(java.lang.String columnId, AggregationType aggregType)
addHavingBetweenCondition(String tableId,String columnId, AggregationType aggregType)
@Deprecated public HavingListCondition addHavingListCondition(java.lang.String columnId, AggregationType aggregType)
addHavingListCondition(String tableId,String columnId, AggregationType aggregType)
@Deprecated public HavingNumberCondition addNumberCondition(java.lang.String columnId, AggregationType aggregType, NumericOperator numOperator, java.math.BigDecimal value)
addNumberCondition(String tableId,String columnId,AggregationType aggregType, NumericOperator numOperator, BigDecimal value)
@Deprecated public HavingNumberCondition addNumberCondition(java.lang.String columnId, AggregationType aggregType, NumericOperator numOperator, java.lang.Integer value)
addNumberCondition(String tableId,String columnId, AggregationType aggregType, NumericOperator numOperator, Integer value)
public HavingBetweenCondition addHavingBetweenCondition(java.lang.String tableId, java.lang.String columnId, AggregationType aggregType)
tableId
- columnId
- aggregType
- public HavingListCondition addHavingListCondition(java.lang.String tableId, java.lang.String columnId, AggregationType aggregType)
tableId
- columnId
- aggregType
- public HavingNumberCondition addNumberCondition(java.lang.String tableId, java.lang.String columnId, AggregationType aggregType, NumericOperator numOperator, java.math.BigDecimal value)
tableId
- columnId
- numOperator
- value
- public HavingNumberCondition addNumberCondition(java.lang.String tableId, java.lang.String columnId, AggregationType aggregType, NumericOperator numOperator, java.lang.Integer value)
tableId
- columnId
- numOperator
- value
- public java.util.ArrayList<HavingCondition> getCondition()
Copyright © 2017 Oracle and/or its affiliates. All Rights Reserved.