Interface CaseQuery.ICustomFieldAggregationQuery
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description CaseQuery.AggregationQuery
avgNumberField(String fieldName)
Adds a result customNumber
field columnAvg[fieldName]
to the query that contains the average of the customNumber
field with namefieldName
of all (grouped) rows.CaseQuery.AggregationQuery
avgTimestampField(String fieldName)
Adds a result customTimestamp
field columnAvg[fieldName]
to the query that contains the average of the customTimestamp
field with namefieldName
of all (grouped) rows.CaseQuery.AggregationQuery
maxNumberField(String fieldName)
Adds a result customNumber
field columnMax[fieldName]
to the query that contains the maximum value of the customNumber
field with namefieldName
of all (grouped) rows.CaseQuery.AggregationQuery
maxStringField(String fieldName)
Adds a result customString
field columnMax[fieldName]
to the query that contains the maximum value of the customString
field with namefieldName
of all (grouped) rows.CaseQuery.AggregationQuery
maxTimestampField(String fieldName)
Adds a result customTimestamp
field columnMax[fieldName]
to the query that contains the maximum value of the customTimestamp
field with namefieldName
of all (grouped) rows.CaseQuery.AggregationQuery
minNumberField(String fieldName)
Adds a result customNumber
field columnMin[fieldName]
to the query that contains the minimum value of the customNumber
field with namefieldName
of all (grouped) rows.CaseQuery.AggregationQuery
sumNumberField(String fieldName)
Adds a result customNumber
field columnSum[fieldName]
to the query that contains the sum of the customNumber
field with namefieldName
of all (grouped) rows.CaseQuery.AggregationQuery
sumTimestampField(String fieldName)
Adds a result customTimestamp
field columnSum[fieldName]
to the query that contains the sum of the customTimestamp
field with namefieldName
of all (grouped) rows.
-
-
-
Method Detail
-
maxStringField
CaseQuery.AggregationQuery maxStringField(String fieldName)
Adds a result custom
String
field columnMax[fieldName]
to the query that contains the maximum value of the customString
field with namefieldName
of all (grouped) rows.- Parameters:
fieldName
- Name of the customString
field.- Returns:
- Query for further composition.
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minNumberField
CaseQuery.AggregationQuery minNumberField(String fieldName)
Adds a result custom
Number
field columnMin[fieldName]
to the query that contains the minimum value of the customNumber
field with namefieldName
of all (grouped) rows.- Parameters:
fieldName
- Name of the customNumber
field.- Returns:
- Query for further composition.
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxNumberField
CaseQuery.AggregationQuery maxNumberField(String fieldName)
Adds a result custom
Number
field columnMax[fieldName]
to the query that contains the maximum value of the customNumber
field with namefieldName
of all (grouped) rows.- Parameters:
fieldName
- Name of the customNumber
field.- Returns:
- Query for further composition.
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
avgNumberField
CaseQuery.AggregationQuery avgNumberField(String fieldName)
Adds a result custom
Number
field columnAvg[fieldName]
to the query that contains the average of the customNumber
field with namefieldName
of all (grouped) rows.- Parameters:
fieldName
- Name of the customNumber
field.- Returns:
- Query for further composition.
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
sumNumberField
CaseQuery.AggregationQuery sumNumberField(String fieldName)
Adds a result custom
Number
field columnSum[fieldName]
to the query that contains the sum of the customNumber
field with namefieldName
of all (grouped) rows.- Parameters:
fieldName
- Name of the customNumber
field.- Returns:
- Query for further composition.
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxTimestampField
CaseQuery.AggregationQuery maxTimestampField(String fieldName)
Adds a result custom
Timestamp
field columnMax[fieldName]
to the query that contains the maximum value of the customTimestamp
field with namefieldName
of all (grouped) rows.- Parameters:
fieldName
- Name of the customTimestamp
field.- Returns:
- Query for further composition.
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
avgTimestampField
CaseQuery.AggregationQuery avgTimestampField(String fieldName)
Adds a result custom
Timestamp
field columnAvg[fieldName]
to the query that contains the average of the customTimestamp
field with namefieldName
of all (grouped) rows.- Parameters:
fieldName
- Name of the customTimestamp
field.- Returns:
- Query for further composition.
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
sumTimestampField
CaseQuery.AggregationQuery sumTimestampField(String fieldName)
Adds a result custom
Timestamp
field columnSum[fieldName]
to the query that contains the sum of the customTimestamp
field with namefieldName
of all (grouped) rows.- Parameters:
fieldName
- Name of the customTimestamp
field.- Returns:
- Query for further composition.
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
-