Interface TaskQuery.IAggregationQuery
- All Known Implementing Classes:
TaskQuery.AggregationQuery
- Enclosing class:
- TaskQuery
Example:
Corresponds to SQL:
TaskQuery.create().aggregate().sumWorkingTime().avgWorkingTime();
SELECT SUM(WorkingTime) AS SumWorkingTime, AVG(WorkingTime) AS AvgWorkingTime FROM IWA_Task
- API:
- This is a public API.
-
Method Summary
Modifier and TypeMethodDescriptionDeprecated.Deprecated.Adds a result columnAvgBusinessRuntime
to the query, that contains the average of the fieldBusinessRuntime
of all (grouped) rows.Deprecated.Deprecated.use
insteadcustomField()
.avgNumberField("CustomDecimalField1"))
Deprecated.use
insteadcustomField()
.avgNumberField("CustomDecimalField2"))
Deprecated.use
insteadcustomField()
.avgNumberField("CustomDecimalField3"))
Deprecated.use
insteadcustomField()
.avgNumberField("CustomDecimalField4"))
Deprecated.use
insteadcustomField()
.avgNumberField("CustomDecimalField5"))
Deprecated.Deprecated.Deprecated.Deprecated.Deprecated.Adds a result columnAvgDelayTimestamp
to the query, that contains the average of the fieldDelayTimestamp
of all (grouped) rows.Adds a result columnAvgEndTimestamp
to the query, that contains the average of the fieldEndTimestamp
of all (grouped) rows.Adds a result columnAvgExpiryTimestamp
to the query, that contains the average of the fieldExpiryTimestamp
of all (grouped) rows.Adds a result columnAvgFailedTimeoutTimestamp
to the query, that contains the average of the fieldFailedTimeoutTimestamp
of all (grouped) rows.Adds a result columnAvgNumberOfFailures
to the query, that contains the average of the fieldNumberOfFailures
of all (grouped) rows.Adds a result columnAvgNumberOfResumes
to the query, that contains the average of the fieldNumberOfResumes
of all (grouped) rows.Adds a result columnAvgStartTimestamp
to the query, that contains the average of the fieldStartTimestamp
of all (grouped) rows.Adds a result columnAvgWorkerSessionId
to the query, that contains the average of the fieldWorkerSessionId
of all (grouped) rows.Adds a result columnAvgWorkingTime
to the query, that contains the average of the fieldWorkingTime
of all (grouped) rows.Adds a result columnCount
to the query, that contains the number of (grouped) rows.Adds a result custom field to the query.Adds a result columnMaxActivatorDisplayName
to the query, that contains the maximum value of the fieldActivatorDisplayName
of all (grouped) rows.Adds a result columnMaxActivatorName
to the query, that contains the maximum value of the fieldActivatorName
of all (grouped) rows.Adds a result columnMaxBusinessCalendar
to the query, that contains the maximum value of the fieldBusinessCalendar
of all (grouped) rows.Deprecated.use
insteadcustomField()
.maxStringField("BusinessCreatorUser"))
Deprecated.Deprecated.Deprecated.Deprecated.use
insteadcustomField()
.maxStringField("BusinessObjectCode"))
Deprecated.use
insteadcustomField()
.maxStringField("BusinessObjectName"))
Adds a result columnMaxBusinessRuntime
to the query, that contains the maximum value of the fieldBusinessRuntime
of all (grouped) rows.Deprecated.Adds a result columnMaxCategory
to the query, that contains the maximum value of the fieldCategory
of all (grouped) rows.Deprecated.use
insteadcustomField()
.maxNumberField("CustomDecimalField1"))
Deprecated.use
insteadcustomField()
.maxNumberField("CustomDecimalField2"))
Deprecated.use
insteadcustomField()
.maxNumberField("CustomDecimalField3"))
Deprecated.use
insteadcustomField()
.maxNumberField("CustomDecimalField4"))
Deprecated.use
insteadcustomField()
.maxNumberField("CustomDecimalField5"))
Deprecated.Deprecated.Deprecated.Deprecated.Deprecated.Deprecated.use
insteadcustomField()
.maxStringField("CustomVarCharField1"))
Deprecated.use
insteadcustomField()
.maxStringField("CustomVarCharField2"))
Deprecated.use
insteadcustomField()
.maxStringField("CustomVarCharField3"))
Deprecated.use
insteadcustomField()
.maxStringField("CustomVarCharField4"))
Deprecated.use
insteadcustomField()
.maxStringField("CustomVarCharField5"))
Adds a result columnMaxDelayTimestamp
to the query, that contains the maximum value of the fieldDelayTimestamp
of all (grouped) rows.Adds a result columnMaxEndTimestamp
to the query, that contains the maximum value of the fieldEndTimestamp
of all (grouped) rows.Adds a result columnMaxExpiryActivatorDisplayName
to the query, that contains the maximum value of the fieldExpiryActivatorDisplayName
of all (grouped) rows.Adds a result columnMaxExpiryActivatorName
to the query, that contains the maximum value of the fieldExpiryActivatorName
of all (grouped) rows.Adds a result columnMaxExpiryTaskStartElementPid
to the query, that contains the maximum value of the fieldExpiryTaskStartElementPid
of all (grouped) rows.Adds a result columnMaxExpiryTimestamp
to the query, that contains the maximum value of the fieldExpiryTimestamp
of all (grouped) rows.Adds a result columnMaxFailedTimeoutTimestamp
to the query, that contains the maximum value of the fieldFailedTimeoutTimestamp
of all (grouped) rows.Deprecated.use
insteadcustomField()
.maxStringField("KindCode"))
Deprecated.use
insteadcustomField()
.maxStringField("KindName"))
Adds a result columnMaxModifiedTimestamp
to the query, that contains the maximum value of the fieldModifiedTimestamp
of all (grouped) rows.maxName()
Adds a result columnMaxName
to the query, that contains the maximum value of the fieldName
of all (grouped) rows.Adds a result columnMaxNumberOfFailures
to the query, that contains the maximum value of the fieldNumberOfFailures
of all (grouped) rows.Adds a result columnMaxNumberOfResumes
to the query, that contains the maximum value of the fieldNumberOfResumes
of all (grouped) rows.Adds a result columnMaxOriginalActivatorDisplayName
to the query, that contains the maximum value of the fieldOriginalActivatorDisplayName
of all (grouped) rows.Adds a result columnMaxOriginalActivatorName
to the query, that contains the maximum value of the fieldOriginalActivatorName
of all (grouped) rows.Deprecated.use
insteadcustomField()
.maxStringField("ProcessCategoryCode"))
Deprecated.use
insteadcustomField()
.maxStringField("ProcessCategoryName"))
Deprecated.use
insteadcustomField()
.maxStringField("ProcessCode"))
Deprecated.use
insteadcustomField()
.maxStringField("ProcessName"))
Adds a result columnMaxRequestPath
to the query, that contains the maximum value of the fieldRequestPath
of all (grouped) rows.Adds a result columnMaxStartTimestamp
to the query, that contains the maximum value of the fieldStartTimestamp
of all (grouped) rows.Deprecated.use
insteadcustomField()
.maxStringField("SubTypeCode"))
Deprecated.use
insteadcustomField()
.maxStringField("SubTypeName"))
Adds a result columnMaxTaskId
to the query, that contains the maximum value of the fieldTaskId
of all (grouped) rows.Deprecated.use
insteadcustomField()
.maxStringField("TypeCode"))
Deprecated.use
insteadcustomField()
.maxStringField("TypeName"))
Adds a result columnMaxWorkerSessionId
to the query, that contains the maximum value of the fieldWorkerSessionId
of all (grouped) rows.Adds a result columnMaxWorkerUserDisplayName
to the query, that contains the maximum value of the fieldWorkerUserDisplayName
of all (grouped) rows.Adds a result columnMaxWorkerUserName
to the query, that contains the maximum value of the fieldWorkerUserName
of all (grouped) rows.Adds a result columnMaxWorkingTime
to the query, that contains the maximum value of the fieldWorkingTime
of all (grouped) rows.Adds a result columnMinActivatorDisplayName
to the query, that contains the minimum value of the fieldActivatorDisplayName
of all (grouped) rows.Adds a result columnMinActivatorName
to the query, that contains the minimum value of the fieldActivatorName
of all (grouped) rows.Adds a result columnMinBusinessCalendar
to the query, that contains the minimum value of the fieldBusinessCalendar
of all (grouped) rows.Deprecated.use
insteadcustomField()
.minStringField("BusinessCreatorUser"))
Deprecated.Deprecated.use
insteadcustomField()
.minStringField("BusinessMainContactName"))
Deprecated.use
insteadcustomField()
.minTimestampField("BusinessMilestoneTimestamp"))
Deprecated.use
insteadcustomField()
.minStringField("BusinessObjectCode"))
Deprecated.use
insteadcustomField()
.minStringField("BusinessObjectName"))
Adds a result columnMinBusinessRuntime
to the query, that contains the minimum value of the fieldBusinessRuntime
of all (grouped) rows.Deprecated.use
insteadcustomField()
.minTimestampField("BusinessStartTimestamp"))
Adds a result columnMinCategory
to the query, that contains the minimum value of the fieldCategory
of all (grouped) rows.Deprecated.use
insteadcustomField()
.minNumberField("CustomDecimalField1"))
Deprecated.use
insteadcustomField()
.minNumberField("CustomDecimalField2"))
Deprecated.use
insteadcustomField()
.minNumberField("CustomDecimalField3"))
Deprecated.use
insteadcustomField()
.minNumberField("CustomDecimalField4"))
Deprecated.use
insteadcustomField()
.minNumberField("CustomDecimalField5"))
Deprecated.use
insteadcustomField()
.minTimestampField("CustomTimestampField1"))
Deprecated.use
insteadcustomField()
.minTimestampField("CustomTimestampField2"))
Deprecated.use
insteadcustomField()
.minTimestampField("CustomTimestampField3"))
Deprecated.use
insteadcustomField()
.minTimestampField("CustomTimestampField4"))
Deprecated.use
insteadcustomField()
.minTimestampField("CustomTimestampField5"))
Deprecated.use
insteadcustomField()
.minStringField("CustomVarCharField1"))
Deprecated.use
insteadcustomField()
.minStringField("CustomVarCharField2"))
Deprecated.use
insteadcustomField()
.minStringField("CustomVarCharField3"))
Deprecated.use
insteadcustomField()
.minStringField("CustomVarCharField4"))
Deprecated.use
insteadcustomField()
.minStringField("CustomVarCharField5"))
Adds a result columnMinDelayTimestamp
to the query, that contains the minimum value of the fieldDelayTimestamp
of all (grouped) rows.Adds a result columnMinEndTimestamp
to the query, that contains the minimum value of the fieldEndTimestamp
of all (grouped) rows.Adds a result columnMinExpiryActivatorDisplayName
to the query, that contains the minimum value of the fieldExpiryActivatorDisplayName
of all (grouped) rows.Adds a result columnMinExpiryActivatorName
to the query, that contains the minimum value of the fieldExpiryActivatorName
of all (grouped) rows.Adds a result columnMinExpiryTaskStartElementPid
to the query, that contains the minimum value of the fieldExpiryTaskStartElementPid
of all (grouped) rows.Adds a result columnMinExpiryTimestamp
to the query, that contains the minimum value of the fieldExpiryTimestamp
of all (grouped) rows.Adds a result columnMinFailedTimeoutTimestamp
to the query, that contains the minimum value of the fieldFailedTimeoutTimestamp
of all (grouped) rows.Deprecated.use
insteadcustomField()
.minStringField("KindCode"))
Deprecated.use
insteadcustomField()
.minStringField("KindName"))
Adds a result columnMinModifiedTimestamp
to the query, that contains the minimum value of the fieldModifiedTimestamp
of all (grouped) rows.minName()
Adds a result columnMinName
to the query, that contains the minimum value of the fieldName
of all (grouped) rows.Adds a result columnMinNumberOfFailures
to the query, that contains the minimum value of the fieldNumberOfFailures
of all (grouped) rows.Adds a result columnMinNumberOfResumes
to the query, that contains the minimum value of the fieldNumberOfResumes
of all (grouped) rows.Adds a result columnMinOriginalActivatorDisplayName
to the query, that contains the minimum value of the fieldOriginalActivatorDisplayName
of all (grouped) rows.Adds a result columnMinOriginalActivatorName
to the query, that contains the minimum value of the fieldOriginalActivatorName
of all (grouped) rows.Deprecated.use
insteadcustomField()
.minStringField("ProcessCategoryCode"))
Deprecated.use
insteadcustomField()
.minStringField("ProcessCategoryName"))
Deprecated.use
insteadcustomField()
.minStringField("ProcessCode"))
Deprecated.use
insteadcustomField()
.minStringField("ProcessName"))
Adds a result columnMinRequestPath
to the query, that contains the minimum value of the fieldRequestPath
of all (grouped) rows.Adds a result columnMinStartTimestamp
to the query, that contains the minimum value of the fieldStartTimestamp
of all (grouped) rows.Deprecated.use
insteadcustomField()
.minStringField("SubTypeCode"))
Deprecated.use
insteadcustomField()
.minStringField("SubTypeName"))
Adds a result columnMinTaskId
to the query, that contains the minimum value of the fieldTaskId
of all (grouped) rows.Deprecated.use
insteadcustomField()
.minStringField("TypeCode"))
Deprecated.use
insteadcustomField()
.minStringField("TypeName"))
Adds a result columnMinWorkerSessionId
to the query, that contains the minimum value of the fieldWorkerSessionId
of all (grouped) rows.Adds a result columnMinWorkerUserDisplayName
to the query, that contains the minimum value of the fieldWorkerUserDisplayName
of all (grouped) rows.Adds a result columnMinWorkerUserName
to the query, that contains the minimum value of the fieldWorkerUserName
of all (grouped) rows.Adds a result columnMinWorkingTime
to the query, that contains the minimum value of the fieldWorkingTime
of all (grouped) rows.Deprecated.Deprecated.Adds a result columnSumBusinessRuntime
to the query, that contains the sum of the fieldBusinessRuntime
of all (grouped) rows.Deprecated.Deprecated.use
insteadcustomField()
.sumsNumberField("CustomDecimalField1"))
Deprecated.use
insteadcustomField()
.sumsNumberField("CustomDecimalField2"))
Deprecated.use
insteadcustomField()
.sumsNumberField("CustomDecimalField3"))
Deprecated.use
insteadcustomField()
.sumsNumberField("CustomDecimalField4"))
Deprecated.use
insteadcustomField()
.sumsNumberField("CustomDecimalField5"))
Deprecated.Deprecated.Deprecated.Deprecated.Deprecated.Adds a result columnSumNumberOfFailures
to the query, that contains the sum of the fieldNumberOfFailures
of all (grouped) rows.Adds a result columnSumNumberOfResumes
to the query, that contains the sum of the fieldNumberOfResumes
of all (grouped) rows.Adds a result columnSumWorkerSessionId
to the query, that contains the sum of the fieldWorkerSessionId
of all (grouped) rows.Adds a result columnSumWorkingTime
to the query, that contains the sum of the fieldWorkingTime
of all (grouped) rows.
-
Method Details
-
countRows
TaskQuery.AggregationQuery countRows()Adds a result column
Count
to the query, that contains the number of (grouped) rows.SQL part:
COUNT(*) AS Count
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minTaskId
TaskQuery.AggregationQuery minTaskId()Adds a result column
MinTaskId
to the query, that contains the minimum value of the fieldTaskId
of all (grouped) rows.SQL part:
MIN(TaskId) AS MinTaskId
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxTaskId
TaskQuery.AggregationQuery maxTaskId()Adds a result column
MaxTaskId
to the query, that contains the maximum value of the fieldTaskId
of all (grouped) rows.SQL part:
MAX(TaskId) AS MaxTaskId
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minWorkerUserName
TaskQuery.AggregationQuery minWorkerUserName()Adds a result column
MinWorkerUserName
to the query, that contains the minimum value of the fieldWorkerUserName
of all (grouped) rows.SQL part:
MIN(WorkerUserName) AS MinWorkerUserName
This is a virtual column. It contains the same value as the column
Name
of the referencedWorker
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxWorkerUserName
TaskQuery.AggregationQuery maxWorkerUserName()Adds a result column
MaxWorkerUserName
to the query, that contains the maximum value of the fieldWorkerUserName
of all (grouped) rows.SQL part:
MAX(WorkerUserName) AS MaxWorkerUserName
This is a virtual column. It contains the same value as the column
Name
of the referencedWorker
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minWorkerUserDisplayName
TaskQuery.AggregationQuery minWorkerUserDisplayName()Adds a result column
MinWorkerUserDisplayName
to the query, that contains the minimum value of the fieldWorkerUserDisplayName
of all (grouped) rows.SQL part:
MIN(WorkerUserDisplayName) AS MinWorkerUserDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedWorker
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxWorkerUserDisplayName
TaskQuery.AggregationQuery maxWorkerUserDisplayName()Adds a result column
MaxWorkerUserDisplayName
to the query, that contains the maximum value of the fieldWorkerUserDisplayName
of all (grouped) rows.SQL part:
MAX(WorkerUserDisplayName) AS MaxWorkerUserDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedWorker
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumWorkerSessionId
TaskQuery.AggregationQuery sumWorkerSessionId()Adds a result column
SumWorkerSessionId
to the query, that contains the sum of the fieldWorkerSessionId
of all (grouped) rows.SQL part:
SUM(WorkerSessionId) AS SumWorkerSessionId
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgWorkerSessionId
TaskQuery.AggregationQuery avgWorkerSessionId()Adds a result column
AvgWorkerSessionId
to the query, that contains the average of the fieldWorkerSessionId
of all (grouped) rows.SQL part:
AVG(WorkerSessionId) AS AvgWorkerSessionId
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minWorkerSessionId
TaskQuery.AggregationQuery minWorkerSessionId()Adds a result column
MinWorkerSessionId
to the query, that contains the minimum value of the fieldWorkerSessionId
of all (grouped) rows.SQL part:
MIN(WorkerSessionId) AS MinWorkerSessionId
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxWorkerSessionId
TaskQuery.AggregationQuery maxWorkerSessionId()Adds a result column
MaxWorkerSessionId
to the query, that contains the maximum value of the fieldWorkerSessionId
of all (grouped) rows.SQL part:
MAX(WorkerSessionId) AS MaxWorkerSessionId
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minOriginalActivatorName
TaskQuery.AggregationQuery minOriginalActivatorName()Adds a result column
MinOriginalActivatorName
to the query, that contains the minimum value of the fieldOriginalActivatorName
of all (grouped) rows.SQL part:
MIN(OriginalActivatorName) AS MinOriginalActivatorName
This is a virtual column. It contains the same value as the column
MemberName
of the referencedOriginalActivator
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxOriginalActivatorName
TaskQuery.AggregationQuery maxOriginalActivatorName()Adds a result column
MaxOriginalActivatorName
to the query, that contains the maximum value of the fieldOriginalActivatorName
of all (grouped) rows.SQL part:
MAX(OriginalActivatorName) AS MaxOriginalActivatorName
This is a virtual column. It contains the same value as the column
MemberName
of the referencedOriginalActivator
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minOriginalActivatorDisplayName
TaskQuery.AggregationQuery minOriginalActivatorDisplayName()Adds a result column
MinOriginalActivatorDisplayName
to the query, that contains the minimum value of the fieldOriginalActivatorDisplayName
of all (grouped) rows.SQL part:
MIN(OriginalActivatorDisplayName) AS MinOriginalActivatorDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedOriginalActivator
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxOriginalActivatorDisplayName
TaskQuery.AggregationQuery maxOriginalActivatorDisplayName()Adds a result column
MaxOriginalActivatorDisplayName
to the query, that contains the maximum value of the fieldOriginalActivatorDisplayName
of all (grouped) rows.SQL part:
MAX(OriginalActivatorDisplayName) AS MaxOriginalActivatorDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedOriginalActivator
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minExpiryActivatorName
TaskQuery.AggregationQuery minExpiryActivatorName()Adds a result column
MinExpiryActivatorName
to the query, that contains the minimum value of the fieldExpiryActivatorName
of all (grouped) rows.SQL part:
MIN(ExpiryActivatorName) AS MinExpiryActivatorName
This is a virtual column. It contains the same value as the column
MemberName
of the referencedExpiryActivator
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxExpiryActivatorName
TaskQuery.AggregationQuery maxExpiryActivatorName()Adds a result column
MaxExpiryActivatorName
to the query, that contains the maximum value of the fieldExpiryActivatorName
of all (grouped) rows.SQL part:
MAX(ExpiryActivatorName) AS MaxExpiryActivatorName
This is a virtual column. It contains the same value as the column
MemberName
of the referencedExpiryActivator
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minExpiryActivatorDisplayName
TaskQuery.AggregationQuery minExpiryActivatorDisplayName()Adds a result column
MinExpiryActivatorDisplayName
to the query, that contains the minimum value of the fieldExpiryActivatorDisplayName
of all (grouped) rows.SQL part:
MIN(ExpiryActivatorDisplayName) AS MinExpiryActivatorDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedExpiryActivator
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxExpiryActivatorDisplayName
TaskQuery.AggregationQuery maxExpiryActivatorDisplayName()Adds a result column
MaxExpiryActivatorDisplayName
to the query, that contains the maximum value of the fieldExpiryActivatorDisplayName
of all (grouped) rows.SQL part:
MAX(ExpiryActivatorDisplayName) AS MaxExpiryActivatorDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedExpiryActivator
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgExpiryTimestamp
TaskQuery.AggregationQuery avgExpiryTimestamp()Adds a result column
AvgExpiryTimestamp
to the query, that contains the average of the fieldExpiryTimestamp
of all (grouped) rows.SQL part:
AVG(ExpiryTimestamp) AS AvgExpiryTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minExpiryTimestamp
TaskQuery.AggregationQuery minExpiryTimestamp()Adds a result column
MinExpiryTimestamp
to the query, that contains the minimum value of the fieldExpiryTimestamp
of all (grouped) rows.SQL part:
MIN(ExpiryTimestamp) AS MinExpiryTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxExpiryTimestamp
TaskQuery.AggregationQuery maxExpiryTimestamp()Adds a result column
MaxExpiryTimestamp
to the query, that contains the maximum value of the fieldExpiryTimestamp
of all (grouped) rows.SQL part:
MAX(ExpiryTimestamp) AS MaxExpiryTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minExpiryTaskStartElementPid
TaskQuery.AggregationQuery minExpiryTaskStartElementPid()Adds a result column
MinExpiryTaskStartElementPid
to the query, that contains the minimum value of the fieldExpiryTaskStartElementPid
of all (grouped) rows.SQL part:
MIN(ExpiryTaskStartElementPid) AS MinExpiryTaskStartElementPid
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxExpiryTaskStartElementPid
TaskQuery.AggregationQuery maxExpiryTaskStartElementPid()Adds a result column
MaxExpiryTaskStartElementPid
to the query, that contains the maximum value of the fieldExpiryTaskStartElementPid
of all (grouped) rows.SQL part:
MAX(ExpiryTaskStartElementPid) AS MaxExpiryTaskStartElementPid
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgDelayTimestamp
TaskQuery.AggregationQuery avgDelayTimestamp()Adds a result column
AvgDelayTimestamp
to the query, that contains the average of the fieldDelayTimestamp
of all (grouped) rows.SQL part:
AVG(DelayTimestamp) AS AvgDelayTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minDelayTimestamp
TaskQuery.AggregationQuery minDelayTimestamp()Adds a result column
MinDelayTimestamp
to the query, that contains the minimum value of the fieldDelayTimestamp
of all (grouped) rows.SQL part:
MIN(DelayTimestamp) AS MinDelayTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxDelayTimestamp
TaskQuery.AggregationQuery maxDelayTimestamp()Adds a result column
MaxDelayTimestamp
to the query, that contains the maximum value of the fieldDelayTimestamp
of all (grouped) rows.SQL part:
MAX(DelayTimestamp) AS MaxDelayTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minRequestPath
TaskQuery.AggregationQuery minRequestPath()Adds a result column
MinRequestPath
to the query, that contains the minimum value of the fieldRequestPath
of all (grouped) rows.SQL part:
MIN(RequestPath) AS MinRequestPath
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxRequestPath
TaskQuery.AggregationQuery maxRequestPath()Adds a result column
MaxRequestPath
to the query, that contains the maximum value of the fieldRequestPath
of all (grouped) rows.SQL part:
MAX(RequestPath) AS MaxRequestPath
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minName
TaskQuery.AggregationQuery minName()Adds a result column
MinName
to the query, that contains the minimum value of the fieldName
of all (grouped) rows.SQL part:
MIN(Name) AS MinName
This is a virtual column. It contains the same value as the column
Name
of the referencedTaskLocalized
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxName
TaskQuery.AggregationQuery maxName()Adds a result column
MaxName
to the query, that contains the maximum value of the fieldName
of all (grouped) rows.SQL part:
MAX(Name) AS MaxName
This is a virtual column. It contains the same value as the column
Name
of the referencedTaskLocalized
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgStartTimestamp
TaskQuery.AggregationQuery avgStartTimestamp()Adds a result column
AvgStartTimestamp
to the query, that contains the average of the fieldStartTimestamp
of all (grouped) rows.SQL part:
AVG(StartTimestamp) AS AvgStartTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minStartTimestamp
TaskQuery.AggregationQuery minStartTimestamp()Adds a result column
MinStartTimestamp
to the query, that contains the minimum value of the fieldStartTimestamp
of all (grouped) rows.SQL part:
MIN(StartTimestamp) AS MinStartTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxStartTimestamp
TaskQuery.AggregationQuery maxStartTimestamp()Adds a result column
MaxStartTimestamp
to the query, that contains the maximum value of the fieldStartTimestamp
of all (grouped) rows.SQL part:
MAX(StartTimestamp) AS MaxStartTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgEndTimestamp
TaskQuery.AggregationQuery avgEndTimestamp()Adds a result column
AvgEndTimestamp
to the query, that contains the average of the fieldEndTimestamp
of all (grouped) rows.SQL part:
AVG(EndTimestamp) AS AvgEndTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minEndTimestamp
TaskQuery.AggregationQuery minEndTimestamp()Adds a result column
MinEndTimestamp
to the query, that contains the minimum value of the fieldEndTimestamp
of all (grouped) rows.SQL part:
MIN(EndTimestamp) AS MinEndTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxEndTimestamp
TaskQuery.AggregationQuery maxEndTimestamp()Adds a result column
MaxEndTimestamp
to the query, that contains the maximum value of the fieldEndTimestamp
of all (grouped) rows.SQL part:
MAX(EndTimestamp) AS MaxEndTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minModifiedTimestamp
TaskQuery.AggregationQuery minModifiedTimestamp()Adds a result column
MinModifiedTimestamp
to the query, that contains the minimum value of the fieldModifiedTimestamp
of all (grouped) rows.SQL part:
MIN(ModifiedTimestamp) AS MinModifiedTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxModifiedTimestamp
TaskQuery.AggregationQuery maxModifiedTimestamp()Adds a result column
MaxModifiedTimestamp
to the query, that contains the maximum value of the fieldModifiedTimestamp
of all (grouped) rows.SQL part:
MAX(ModifiedTimestamp) AS MaxModifiedTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minBusinessCalendar
TaskQuery.AggregationQuery minBusinessCalendar()Adds a result column
MinBusinessCalendar
to the query, that contains the minimum value of the fieldBusinessCalendar
of all (grouped) rows.SQL part:
MIN(BusinessCalendar) AS MinBusinessCalendar
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxBusinessCalendar
TaskQuery.AggregationQuery maxBusinessCalendar()Adds a result column
MaxBusinessCalendar
to the query, that contains the maximum value of the fieldBusinessCalendar
of all (grouped) rows.SQL part:
MAX(BusinessCalendar) AS MaxBusinessCalendar
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumWorkingTime
TaskQuery.AggregationQuery sumWorkingTime()Adds a result column
SumWorkingTime
to the query, that contains the sum of the fieldWorkingTime
of all (grouped) rows.SQL part:
SUM(WorkingTime) AS SumWorkingTime
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgWorkingTime
TaskQuery.AggregationQuery avgWorkingTime()Adds a result column
AvgWorkingTime
to the query, that contains the average of the fieldWorkingTime
of all (grouped) rows.SQL part:
AVG(WorkingTime) AS AvgWorkingTime
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minWorkingTime
TaskQuery.AggregationQuery minWorkingTime()Adds a result column
MinWorkingTime
to the query, that contains the minimum value of the fieldWorkingTime
of all (grouped) rows.SQL part:
MIN(WorkingTime) AS MinWorkingTime
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxWorkingTime
TaskQuery.AggregationQuery maxWorkingTime()Adds a result column
MaxWorkingTime
to the query, that contains the maximum value of the fieldWorkingTime
of all (grouped) rows.SQL part:
MAX(WorkingTime) AS MaxWorkingTime
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumBusinessRuntime
TaskQuery.AggregationQuery sumBusinessRuntime()Adds a result column
SumBusinessRuntime
to the query, that contains the sum of the fieldBusinessRuntime
of all (grouped) rows.SQL part:
SUM(BusinessRuntime) AS SumBusinessRuntime
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgBusinessRuntime
TaskQuery.AggregationQuery avgBusinessRuntime()Adds a result column
AvgBusinessRuntime
to the query, that contains the average of the fieldBusinessRuntime
of all (grouped) rows.SQL part:
AVG(BusinessRuntime) AS AvgBusinessRuntime
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minBusinessRuntime
TaskQuery.AggregationQuery minBusinessRuntime()Adds a result column
MinBusinessRuntime
to the query, that contains the minimum value of the fieldBusinessRuntime
of all (grouped) rows.SQL part:
MIN(BusinessRuntime) AS MinBusinessRuntime
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxBusinessRuntime
TaskQuery.AggregationQuery maxBusinessRuntime()Adds a result column
MaxBusinessRuntime
to the query, that contains the maximum value of the fieldBusinessRuntime
of all (grouped) rows.SQL part:
MAX(BusinessRuntime) AS MaxBusinessRuntime
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgFailedTimeoutTimestamp
TaskQuery.AggregationQuery avgFailedTimeoutTimestamp()Adds a result column
AvgFailedTimeoutTimestamp
to the query, that contains the average of the fieldFailedTimeoutTimestamp
of all (grouped) rows.SQL part:
AVG(FailedTimeoutTimestamp) AS AvgFailedTimeoutTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minFailedTimeoutTimestamp
TaskQuery.AggregationQuery minFailedTimeoutTimestamp()Adds a result column
MinFailedTimeoutTimestamp
to the query, that contains the minimum value of the fieldFailedTimeoutTimestamp
of all (grouped) rows.SQL part:
MIN(FailedTimeoutTimestamp) AS MinFailedTimeoutTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxFailedTimeoutTimestamp
TaskQuery.AggregationQuery maxFailedTimeoutTimestamp()Adds a result column
MaxFailedTimeoutTimestamp
to the query, that contains the maximum value of the fieldFailedTimeoutTimestamp
of all (grouped) rows.SQL part:
MAX(FailedTimeoutTimestamp) AS MaxFailedTimeoutTimestamp
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumNumberOfFailures
TaskQuery.AggregationQuery sumNumberOfFailures()Adds a result column
SumNumberOfFailures
to the query, that contains the sum of the fieldNumberOfFailures
of all (grouped) rows.SQL part:
SUM(NumberOfFailures) AS SumNumberOfFailures
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgNumberOfFailures
TaskQuery.AggregationQuery avgNumberOfFailures()Adds a result column
AvgNumberOfFailures
to the query, that contains the average of the fieldNumberOfFailures
of all (grouped) rows.SQL part:
AVG(NumberOfFailures) AS AvgNumberOfFailures
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minNumberOfFailures
TaskQuery.AggregationQuery minNumberOfFailures()Adds a result column
MinNumberOfFailures
to the query, that contains the minimum value of the fieldNumberOfFailures
of all (grouped) rows.SQL part:
MIN(NumberOfFailures) AS MinNumberOfFailures
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxNumberOfFailures
TaskQuery.AggregationQuery maxNumberOfFailures()Adds a result column
MaxNumberOfFailures
to the query, that contains the maximum value of the fieldNumberOfFailures
of all (grouped) rows.SQL part:
MAX(NumberOfFailures) AS MaxNumberOfFailures
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumNumberOfResumes
TaskQuery.AggregationQuery sumNumberOfResumes()Adds a result column
SumNumberOfResumes
to the query, that contains the sum of the fieldNumberOfResumes
of all (grouped) rows.SQL part:
SUM(NumberOfResumes) AS SumNumberOfResumes
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgNumberOfResumes
TaskQuery.AggregationQuery avgNumberOfResumes()Adds a result column
AvgNumberOfResumes
to the query, that contains the average of the fieldNumberOfResumes
of all (grouped) rows.SQL part:
AVG(NumberOfResumes) AS AvgNumberOfResumes
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minNumberOfResumes
TaskQuery.AggregationQuery minNumberOfResumes()Adds a result column
MinNumberOfResumes
to the query, that contains the minimum value of the fieldNumberOfResumes
of all (grouped) rows.SQL part:
MIN(NumberOfResumes) AS MinNumberOfResumes
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxNumberOfResumes
TaskQuery.AggregationQuery maxNumberOfResumes()Adds a result column
MaxNumberOfResumes
to the query, that contains the maximum value of the fieldNumberOfResumes
of all (grouped) rows.SQL part:
MAX(NumberOfResumes) AS MaxNumberOfResumes
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCategory
TaskQuery.AggregationQuery minCategory()Adds a result column
MinCategory
to the query, that contains the minimum value of the fieldCategory
of all (grouped) rows.SQL part:
MIN(Category) AS MinCategory
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCategory
TaskQuery.AggregationQuery maxCategory()Adds a result column
MaxCategory
to the query, that contains the maximum value of the fieldCategory
of all (grouped) rows.SQL part:
MAX(Category) AS MaxCategory
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minActivatorName
TaskQuery.AggregationQuery minActivatorName()Adds a result column
MinActivatorName
to the query, that contains the minimum value of the fieldActivatorName
of all (grouped) rows.SQL part:
MIN(ActivatorName) AS MinActivatorName
This is a virtual column. It contains the same value as the column
MemberName
of the referencedActivator
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxActivatorName
TaskQuery.AggregationQuery maxActivatorName()Adds a result column
MaxActivatorName
to the query, that contains the maximum value of the fieldActivatorName
of all (grouped) rows.SQL part:
MAX(ActivatorName) AS MaxActivatorName
This is a virtual column. It contains the same value as the column
MemberName
of the referencedActivator
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minActivatorDisplayName
TaskQuery.AggregationQuery minActivatorDisplayName()Adds a result column
MinActivatorDisplayName
to the query, that contains the minimum value of the fieldActivatorDisplayName
of all (grouped) rows.SQL part:
MIN(ActivatorDisplayName) AS MinActivatorDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedActivator
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxActivatorDisplayName
TaskQuery.AggregationQuery maxActivatorDisplayName()Adds a result column
MaxActivatorDisplayName
to the query, that contains the maximum value of the fieldActivatorDisplayName
of all (grouped) rows.SQL part:
MAX(ActivatorDisplayName) AS MaxActivatorDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedActivator
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
customField
TaskQuery.ICustomFieldAggregationQuery customField()Adds a result custom field to the query. Type and name are specified during further query composition.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomVarCharField1
Deprecated.use
insteadcustomField()
.minStringField("CustomVarCharField1"))
Adds a result custom field "CustomVarCharField1" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomVarCharField1
Deprecated.use
insteadcustomField()
.maxStringField("CustomVarCharField1"))
Adds a result custom field "CustomVarCharField1" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomVarCharField2
Deprecated.use
insteadcustomField()
.minStringField("CustomVarCharField2"))
Adds a result custom field "CustomVarCharField2" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomVarCharField2
Deprecated.use
insteadcustomField()
.maxStringField("CustomVarCharField2"))
Adds a result custom field "CustomVarCharField2" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomVarCharField3
Deprecated.use
insteadcustomField()
.minStringField("CustomVarCharField3"))
Adds a result custom field "CustomVarCharField3" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomVarCharField3
Deprecated.use
insteadcustomField()
.maxStringField("CustomVarCharField3"))
Adds a result custom field "CustomVarCharField3" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomVarCharField4
Deprecated.use
insteadcustomField()
.minStringField("CustomVarCharField4"))
Adds a result custom field "CustomVarCharField4" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomVarCharField4
Deprecated.use
insteadcustomField()
.maxStringField("CustomVarCharField4"))
Adds a result custom field "CustomVarCharField4" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomVarCharField5
Deprecated.use
insteadcustomField()
.minStringField("CustomVarCharField5"))
Adds a result custom field "CustomVarCharField5" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomVarCharField5
Deprecated.use
insteadcustomField()
.maxStringField("CustomVarCharField5"))
Adds a result custom field "CustomVarCharField5" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomDecimalField1
Deprecated.use
insteadcustomField()
.minNumberField("CustomDecimalField1"))
Adds a result custom field "CustomDecimalField1" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomDecimalField1
Deprecated.use
insteadcustomField()
.maxNumberField("CustomDecimalField1"))
Adds a result custom field "CustomDecimalField1" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgCustomDecimalField1
Deprecated.use
insteadcustomField()
.avgNumberField("CustomDecimalField1"))
Adds a result column "CustomDecimalField1" to the query, that contains the average of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumCustomDecimalField1
Deprecated.use
insteadcustomField()
.sumsNumberField("CustomDecimalField1"))
Adds a result column "CustomDecimalField1" to the query, that contains the sum of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomDecimalField2
Deprecated.use
insteadcustomField()
.minNumberField("CustomDecimalField2"))
Adds a result custom field "CustomDecimalField2" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomDecimalField2
Deprecated.use
insteadcustomField()
.maxNumberField("CustomDecimalField2"))
Adds a result custom field "CustomDecimalField2" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgCustomDecimalField2
Deprecated.use
insteadcustomField()
.avgNumberField("CustomDecimalField2"))
Adds a result column "CustomDecimalField2" to the query, that contains the average of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumCustomDecimalField2
Deprecated.use
insteadcustomField()
.sumsNumberField("CustomDecimalField2"))
Adds a result column "CustomDecimalField2" to the query, that contains the sum of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomDecimalField3
Deprecated.use
insteadcustomField()
.minNumberField("CustomDecimalField3"))
Adds a result custom field "CustomDecimalField3" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomDecimalField3
Deprecated.use
insteadcustomField()
.maxNumberField("CustomDecimalField3"))
Adds a result custom field "CustomDecimalField3" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgCustomDecimalField3
Deprecated.use
insteadcustomField()
.avgNumberField("CustomDecimalField3"))
Adds a result column "CustomDecimalField3" to the query, that contains the average of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumCustomDecimalField3
Deprecated.use
insteadcustomField()
.sumsNumberField("CustomDecimalField3"))
Adds a result column "CustomDecimalField3" to the query, that contains the sum of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomDecimalField4
Deprecated.use
insteadcustomField()
.minNumberField("CustomDecimalField4"))
Adds a result custom field "CustomDecimalField4" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomDecimalField4
Deprecated.use
insteadcustomField()
.maxNumberField("CustomDecimalField4"))
Adds a result custom field "CustomDecimalField4" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgCustomDecimalField4
Deprecated.use
insteadcustomField()
.avgNumberField("CustomDecimalField4"))
Adds a result column "CustomDecimalField4" to the query, that contains the average of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumCustomDecimalField4
Deprecated.use
insteadcustomField()
.sumsNumberField("CustomDecimalField4"))
Adds a result column "CustomDecimalField4" to the query, that contains the sum of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomDecimalField5
Deprecated.use
insteadcustomField()
.minNumberField("CustomDecimalField5"))
Adds a result custom field "CustomDecimalField5" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomDecimalField5
Deprecated.use
insteadcustomField()
.maxNumberField("CustomDecimalField5"))
Adds a result custom field "CustomDecimalField5" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgCustomDecimalField5
Deprecated.use
insteadcustomField()
.avgNumberField("CustomDecimalField5"))
Adds a result column "CustomDecimalField5" to the query, that contains the average of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumCustomDecimalField5
Deprecated.use
insteadcustomField()
.sumsNumberField("CustomDecimalField5"))
Adds a result column "CustomDecimalField5" to the query, that contains the sum of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomTimestampField1
Deprecated.use
insteadcustomField()
.minTimestampField("CustomTimestampField1"))
Adds a result custom field "CustomTimestampField1" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomTimestampField1
Deprecated.Adds a result custom field "CustomTimestampField1" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgCustomTimestampField1
Deprecated.Adds a result column "CustomTimestampField1" to the query, that contains the average of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumCustomTimestampField1
Deprecated.Adds a result column "CustomTimestampField1" to the query, that contains the sum of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomTimestampField2
Deprecated.use
insteadcustomField()
.minTimestampField("CustomTimestampField2"))
Adds a result custom field "CustomTimestampField2" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomTimestampField2
Deprecated.Adds a result custom field "CustomTimestampField2" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgCustomTimestampField2
Deprecated.Adds a result column "CustomTimestampField2" to the query, that contains the average of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumCustomTimestampField2
Deprecated.Adds a result column "CustomTimestampField2" to the query, that contains the sum of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomTimestampField3
Deprecated.use
insteadcustomField()
.minTimestampField("CustomTimestampField3"))
Adds a result custom field "CustomTimestampField3" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomTimestampField3
Deprecated.Adds a result custom field "CustomTimestampField3" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgCustomTimestampField3
Deprecated.Adds a result column "CustomTimestampField3" to the query, that contains the average of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumCustomTimestampField3
Deprecated.Adds a result column "CustomTimestampField3" to the query, that contains the sum of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomTimestampField4
Deprecated.use
insteadcustomField()
.minTimestampField("CustomTimestampField4"))
Adds a result custom field "CustomTimestampField4" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomTimestampField4
Deprecated.Adds a result custom field "CustomTimestampField4" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgCustomTimestampField4
Deprecated.Adds a result column "CustomTimestampField4" to the query, that contains the average of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumCustomTimestampField4
Deprecated.Adds a result column "CustomTimestampField4" to the query, that contains the sum of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minCustomTimestampField5
Deprecated.use
insteadcustomField()
.minTimestampField("CustomTimestampField5"))
Adds a result custom field "CustomTimestampField5" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxCustomTimestampField5
Deprecated.Adds a result custom field "CustomTimestampField5" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgCustomTimestampField5
Deprecated.Adds a result column "CustomTimestampField5" to the query, that contains the average of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumCustomTimestampField5
Deprecated.Adds a result column "CustomTimestampField5" to the query, that contains the sum of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minBusinessMilestoneTimestamp
Deprecated.use
insteadcustomField()
.minTimestampField("BusinessMilestoneTimestamp"))
Adds a result custom field "BusinessMilestoneTimestamp" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxBusinessMilestoneTimestamp
Deprecated.Adds a result custom field "BusinessMilestoneTimestamp" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgBusinessMilestoneTimestamp
Deprecated.Adds a result column "BusinessMilestoneTimestamp" to the query, that contains the average of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumBusinessMilestoneTimestamp
Deprecated.Adds a result column "BusinessMilestoneTimestamp" to the query, that contains the sum of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minBusinessCreatorUser
Deprecated.use
insteadcustomField()
.minStringField("BusinessCreatorUser"))
Adds a result custom field "BusinessCreatorUser" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxBusinessCreatorUser
Deprecated.use
insteadcustomField()
.maxStringField("BusinessCreatorUser"))
Adds a result custom field "BusinessCreatorUser" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minBusinessMainContactId
Deprecated.Adds a result custom field "BusinessMainContactId" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxBusinessMainContactId
Deprecated.Adds a result custom field "BusinessMainContactId" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgBusinessMainContactId
Deprecated.Adds a result column "BusinessMainContactId" to the query, that contains the average of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumBusinessMainContactId
Deprecated.Adds a result column "BusinessMainContactId" to the query, that contains the sum of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minBusinessMainContactName
Deprecated.use
insteadcustomField()
.minStringField("BusinessMainContactName"))
Adds a result custom field "BusinessMainContactName" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxBusinessMainContactName
Deprecated.Adds a result custom field "BusinessMainContactName" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minBusinessObjectCode
Deprecated.use
insteadcustomField()
.minStringField("BusinessObjectCode"))
Adds a result custom field "BusinessObjectCode" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxBusinessObjectCode
Deprecated.use
insteadcustomField()
.maxStringField("BusinessObjectCode"))
Adds a result custom field "BusinessObjectCode" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minBusinessObjectName
Deprecated.use
insteadcustomField()
.minStringField("BusinessObjectName"))
Adds a result custom field "BusinessObjectName" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxBusinessObjectName
Deprecated.use
insteadcustomField()
.maxStringField("BusinessObjectName"))
Adds a result custom field "BusinessObjectName" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minBusinessStartTimestamp
Deprecated.use
insteadcustomField()
.minTimestampField("BusinessStartTimestamp"))
Adds a result custom field "BusinessStartTimestamp" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxBusinessStartTimestamp
Deprecated.Adds a result custom field "BusinessStartTimestamp" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgBusinessStartTimestamp
Deprecated.Adds a result column "BusinessStartTimestamp" to the query, that contains the average of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
sumBusinessStartTimestamp
Deprecated.Adds a result column "BusinessStartTimestamp" to the query, that contains the sum of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minKindCode
Deprecated.use
insteadcustomField()
.minStringField("KindCode"))
Adds a result custom field "KindCode" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxKindCode
Deprecated.use
insteadcustomField()
.maxStringField("KindCode"))
Adds a result custom field "KindCode" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minKindName
Deprecated.use
insteadcustomField()
.minStringField("KindName"))
Adds a result custom field "KindName" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxKindName
Deprecated.use
insteadcustomField()
.maxStringField("KindName"))
Adds a result custom field "KindName" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minProcessCode
Deprecated.use
insteadcustomField()
.minStringField("ProcessCode"))
Adds a result custom field "ProcessCode" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxProcessCode
Deprecated.use
insteadcustomField()
.maxStringField("ProcessCode"))
Adds a result custom field "ProcessCode" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minProcessName
Deprecated.use
insteadcustomField()
.minStringField("ProcessName"))
Adds a result custom field "ProcessName" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxProcessName
Deprecated.use
insteadcustomField()
.maxStringField("ProcessName"))
Adds a result custom field "ProcessName" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minProcessCategoryCode
Deprecated.use
insteadcustomField()
.minStringField("ProcessCategoryCode"))
Adds a result custom field "ProcessCategoryCode" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxProcessCategoryCode
Deprecated.use
insteadcustomField()
.maxStringField("ProcessCategoryCode"))
Adds a result custom field "ProcessCategoryCode" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minProcessCategoryName
Deprecated.use
insteadcustomField()
.minStringField("ProcessCategoryName"))
Adds a result custom field "ProcessCategoryName" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxProcessCategoryName
Deprecated.use
insteadcustomField()
.maxStringField("ProcessCategoryName"))
Adds a result custom field "ProcessCategoryName" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minTypeCode
Deprecated.use
insteadcustomField()
.minStringField("TypeCode"))
Adds a result custom field "TypeCode" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxTypeCode
Deprecated.use
insteadcustomField()
.maxStringField("TypeCode"))
Adds a result custom field "TypeCode" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minTypeName
Deprecated.use
insteadcustomField()
.minStringField("TypeName"))
Adds a result custom field "TypeName" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxTypeName
Deprecated.use
insteadcustomField()
.maxStringField("TypeName"))
Adds a result custom field "TypeName" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minSubTypeCode
Deprecated.use
insteadcustomField()
.minStringField("SubTypeCode"))
Adds a result custom field "SubTypeCode" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxSubTypeCode
Deprecated.use
insteadcustomField()
.maxStringField("SubTypeCode"))
Adds a result custom field "SubTypeCode" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minSubTypeName
Deprecated.use
insteadcustomField()
.minStringField("SubTypeName"))
Adds a result custom field "SubTypeName" to the query, that contains the minimum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxSubTypeName
Deprecated.use
insteadcustomField()
.maxStringField("SubTypeName"))
Adds a result custom field "SubTypeName" to the query, that contains the maximum value of all (grouped) rows.
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
insteadcustomField()
.avgNumberField("BusinessMainContactId"))