Uses of Class
ch.ivyteam.ivy.workflow.query.CaseQuery.AggregationQuery
Packages that use CaseQuery.AggregationQuery
-
Uses of CaseQuery.AggregationQuery in ch.ivyteam.ivy.workflow.query
Methods in ch.ivyteam.ivy.workflow.query that return CaseQuery.AggregationQueryModifier and TypeMethodDescriptionCaseQuery.IAggregationQuery.avgBusinessCorrespondentId()Deprecated.CaseQuery.IAggregationQuery.avgBusinessMainContactId()Deprecated.CaseQuery.IAggregationQuery.avgBusinessMilestoneTimestamp()Deprecated.CaseQuery.AggregationQuery.avgBusinessRuntime()CaseQuery.IAggregationQuery.avgBusinessRuntime()Adds a result columnAvgBusinessRuntimeto the query, that contains the average of the fieldBusinessRuntimeof all (grouped) rows.CaseQuery.IAggregationQuery.avgBusinessStartTimestamp()Deprecated.CaseQuery.IAggregationQuery.avgCustomDecimalField1()Deprecated.useinsteadcustomField().avgNumberField("CustomDecimalField1"))CaseQuery.IAggregationQuery.avgCustomDecimalField2()Deprecated.useinsteadcustomField().avgNumberField("CustomDecimalField2"))CaseQuery.IAggregationQuery.avgCustomDecimalField3()Deprecated.useinsteadcustomField().avgNumberField("CustomDecimalField3"))CaseQuery.IAggregationQuery.avgCustomDecimalField4()Deprecated.useinsteadcustomField().avgNumberField("CustomDecimalField4"))CaseQuery.IAggregationQuery.avgCustomDecimalField5()Deprecated.useinsteadcustomField().avgNumberField("CustomDecimalField5"))CaseQuery.IAggregationQuery.avgCustomTimestampField1()Deprecated.CaseQuery.IAggregationQuery.avgCustomTimestampField2()Deprecated.CaseQuery.IAggregationQuery.avgCustomTimestampField3()Deprecated.CaseQuery.IAggregationQuery.avgCustomTimestampField4()Deprecated.CaseQuery.IAggregationQuery.avgCustomTimestampField5()Deprecated.CaseQuery.AggregationQuery.avgEndTimestamp()CaseQuery.IAggregationQuery.avgEndTimestamp()Adds a result columnAvgEndTimestampto the query, that contains the average of the fieldEndTimestampof all (grouped) rows.CaseQuery.ICustomFieldAggregationQuery.avgNumberField(String fieldName) Adds a result customNumberfield columnAvg[fieldName]to the query that contains the average of the customNumberfield with namefieldNameof all (grouped) rows.CaseQuery.AggregationQuery.avgStartTimestamp()CaseQuery.IAggregationQuery.avgStartTimestamp()Adds a result columnAvgStartTimestampto the query, that contains the average of the fieldStartTimestampof all (grouped) rows.CaseQuery.ICustomFieldAggregationQuery.avgTimestampField(String fieldName) Adds a result customTimestampfield columnAvg[fieldName]to the query that contains the average of the customTimestampfield with namefieldNameof all (grouped) rows.CaseQuery.AggregationQuery.avgWorkingTime()CaseQuery.IAggregationQuery.avgWorkingTime()Adds a result columnAvgWorkingTimeto the query, that contains the average of the fieldWorkingTimeof all (grouped) rows.CaseQuery.AggregationQuery.countRows()CaseQuery.IAggregationQuery.countRows()Adds a result columnCountto the query, that contains the number of (grouped) rows.CaseQuery.AggregationQuery.maxBusinessCalendar()CaseQuery.IAggregationQuery.maxBusinessCalendar()Adds a result columnMaxBusinessCalendarto the query, that contains the maximum value of the fieldBusinessCalendarof all (grouped) rows.CaseQuery.IAggregationQuery.maxBusinessCorrespondentId()Deprecated.CaseQuery.IAggregationQuery.maxBusinessCreatorUser()Deprecated.useinsteadcustomField().maxStringField("BusinessCreatorUser"))CaseQuery.IAggregationQuery.maxBusinessMainContactDocDbCode()Deprecated.CaseQuery.IAggregationQuery.maxBusinessMainContactFolderId()Deprecated.CaseQuery.IAggregationQuery.maxBusinessMainContactId()Deprecated.CaseQuery.IAggregationQuery.maxBusinessMainContactName()Deprecated.CaseQuery.IAggregationQuery.maxBusinessMainContactType()Deprecated.CaseQuery.IAggregationQuery.maxBusinessMilestoneTimestamp()Deprecated.CaseQuery.IAggregationQuery.maxBusinessObjectCode()Deprecated.useinsteadcustomField().maxStringField("BusinessObjectCode"))CaseQuery.IAggregationQuery.maxBusinessObjectDocDbCode()Deprecated.CaseQuery.IAggregationQuery.maxBusinessObjectFolderId()Deprecated.CaseQuery.IAggregationQuery.maxBusinessObjectName()Deprecated.useinsteadcustomField().maxStringField("BusinessObjectName"))CaseQuery.IAggregationQuery.maxBusinessPriority()Deprecated.useinsteadcustomField().maxStringField("BusinessPriority"))CaseQuery.AggregationQuery.maxBusinessRuntime()CaseQuery.IAggregationQuery.maxBusinessRuntime()Adds a result columnMaxBusinessRuntimeto the query, that contains the maximum value of the fieldBusinessRuntimeof all (grouped) rows.CaseQuery.IAggregationQuery.maxBusinessStartTimestamp()Deprecated.CaseQuery.AggregationQuery.maxCaseId()CaseQuery.IAggregationQuery.maxCaseId()Adds a result columnMaxCaseIdto the query, that contains the maximum value of the fieldCaseIdof all (grouped) rows.CaseQuery.AggregationQuery.maxCategory()CaseQuery.IAggregationQuery.maxCategory()Adds a result columnMaxCategoryto the query, that contains the maximum value of the fieldCategoryof all (grouped) rows.CaseQuery.AggregationQuery.maxCreatorUserDisplayName()CaseQuery.IAggregationQuery.maxCreatorUserDisplayName()Adds a result columnMaxCreatorUserDisplayNameto the query, that contains the maximum value of the fieldCreatorUserDisplayNameof all (grouped) rows.CaseQuery.AggregationQuery.maxCreatorUserName()CaseQuery.IAggregationQuery.maxCreatorUserName()Adds a result columnMaxCreatorUserNameto the query, that contains the maximum value of the fieldCreatorUserNameof all (grouped) rows.CaseQuery.IAggregationQuery.maxCustomDecimalField1()Deprecated.useinsteadcustomField().maxNumberField("CustomDecimalField1"))CaseQuery.IAggregationQuery.maxCustomDecimalField2()Deprecated.useinsteadcustomField().maxNumberField("CustomDecimalField2"))CaseQuery.IAggregationQuery.maxCustomDecimalField3()Deprecated.useinsteadcustomField().maxNumberField("CustomDecimalField3"))CaseQuery.IAggregationQuery.maxCustomDecimalField4()Deprecated.useinsteadcustomField().maxNumberField("CustomDecimalField4"))CaseQuery.IAggregationQuery.maxCustomDecimalField5()Deprecated.useinsteadcustomField().maxNumberField("CustomDecimalField5"))CaseQuery.IAggregationQuery.maxCustomTimestampField1()Deprecated.CaseQuery.IAggregationQuery.maxCustomTimestampField2()Deprecated.CaseQuery.IAggregationQuery.maxCustomTimestampField3()Deprecated.CaseQuery.IAggregationQuery.maxCustomTimestampField4()Deprecated.CaseQuery.IAggregationQuery.maxCustomTimestampField5()Deprecated.CaseQuery.IAggregationQuery.maxCustomVarCharField1()Deprecated.useinsteadcustomField().maxStringField("CustomVarCharField1"))CaseQuery.IAggregationQuery.maxCustomVarCharField2()Deprecated.useinsteadcustomField().maxStringField("CustomVarCharField2"))CaseQuery.IAggregationQuery.maxCustomVarCharField3()Deprecated.useinsteadcustomField().maxStringField("CustomVarCharField3"))CaseQuery.IAggregationQuery.maxCustomVarCharField4()Deprecated.useinsteadcustomField().maxStringField("CustomVarCharField4"))CaseQuery.IAggregationQuery.maxCustomVarCharField5()Deprecated.useinsteadcustomField().maxStringField("CustomVarCharField5"))CaseQuery.AggregationQuery.maxEndTimestamp()CaseQuery.IAggregationQuery.maxEndTimestamp()Adds a result columnMaxEndTimestampto the query, that contains the maximum value of the fieldEndTimestampof all (grouped) rows.CaseQuery.IAggregationQuery.maxModifiedTimestamp()Adds a result columnMaxModifiedTimestampto the query, that contains the maximum value of the fieldModifiedTimestampof all (grouped) rows.CaseQuery.AggregationQuery.maxName()CaseQuery.IAggregationQuery.maxName()Adds a result columnMaxNameto the query, that contains the maximum value of the fieldNameof all (grouped) rows.CaseQuery.ICustomFieldAggregationQuery.maxNumberField(String fieldName) Adds a result customNumberfield columnMax[fieldName]to the query that contains the maximum value of the customNumberfield with namefieldNameof all (grouped) rows.CaseQuery.AggregationQuery.maxOwnerDisplayName()CaseQuery.IAggregationQuery.maxOwnerDisplayName()Adds a result columnMaxOwnerDisplayNameto the query, that contains the maximum value of the fieldOwnerDisplayNameof all (grouped) rows.CaseQuery.AggregationQuery.maxOwnerName()CaseQuery.IAggregationQuery.maxOwnerName()Adds a result columnMaxOwnerNameto the query, that contains the maximum value of the fieldOwnerNameof all (grouped) rows.CaseQuery.IAggregationQuery.maxProcessCategoryCode()Deprecated.useinsteadcustomField().maxStringField("ProcessCategoryCode"))CaseQuery.IAggregationQuery.maxProcessCategoryName()Deprecated.useinsteadcustomField().maxStringField("ProcessCategoryName"))CaseQuery.IAggregationQuery.maxProcessCode()Deprecated.useinsteadcustomField().maxStringField("ProcessCode"))CaseQuery.IAggregationQuery.maxProcessName()Deprecated.useinsteadcustomField().maxStringField("ProcessName"))CaseQuery.AggregationQuery.maxStage()CaseQuery.IAggregationQuery.maxStage()Adds a result columnMaxStageto the query, that contains the maximum value of the fieldStageof all (grouped) rows.CaseQuery.AggregationQuery.maxStartTimestamp()CaseQuery.IAggregationQuery.maxStartTimestamp()Adds a result columnMaxStartTimestampto the query, that contains the maximum value of the fieldStartTimestampof all (grouped) rows.CaseQuery.ICustomFieldAggregationQuery.maxStringField(String fieldName) Adds a result customStringfield columnMax[fieldName]to the query that contains the maximum value of the customStringfield with namefieldNameof all (grouped) rows.CaseQuery.IAggregationQuery.maxSubTypeCode()Deprecated.useinsteadcustomField().maxStringField("SubTypeCode"))CaseQuery.IAggregationQuery.maxSubTypeName()Deprecated.useinsteadcustomField().maxStringField("SubTypeName"))CaseQuery.ICustomFieldAggregationQuery.maxTimestampField(String fieldName) Adds a result customTimestampfield columnMax[fieldName]to the query that contains the maximum value of the customTimestampfield with namefieldNameof all (grouped) rows.CaseQuery.IAggregationQuery.maxTypeCode()Deprecated.useinsteadcustomField().maxStringField("TypeCode"))CaseQuery.IAggregationQuery.maxTypeName()Deprecated.useinsteadcustomField().maxStringField("TypeName"))CaseQuery.AggregationQuery.maxWorkingTime()CaseQuery.IAggregationQuery.maxWorkingTime()Adds a result columnMaxWorkingTimeto the query, that contains the maximum value of the fieldWorkingTimeof all (grouped) rows.CaseQuery.AggregationQuery.minBusinessCalendar()CaseQuery.IAggregationQuery.minBusinessCalendar()Adds a result columnMinBusinessCalendarto the query, that contains the minimum value of the fieldBusinessCalendarof all (grouped) rows.CaseQuery.IAggregationQuery.minBusinessCorrespondentId()Deprecated.CaseQuery.IAggregationQuery.minBusinessCreatorUser()Deprecated.useinsteadcustomField().minStringField("BusinessCreatorUser"))CaseQuery.IAggregationQuery.minBusinessMainContactDocDbCode()Deprecated.useinsteadcustomField().minStringField("BusinessMainContactDocumentDbCode"))CaseQuery.IAggregationQuery.minBusinessMainContactFolderId()Deprecated.useinsteadcustomField().minStringField("BusinessMainContactFolderId"))CaseQuery.IAggregationQuery.minBusinessMainContactId()Deprecated.CaseQuery.IAggregationQuery.minBusinessMainContactName()Deprecated.useinsteadcustomField().minStringField("BusinessMainContactName"))CaseQuery.IAggregationQuery.minBusinessMainContactType()Deprecated.useinsteadcustomField().minStringField("BusinessMainContactType"))CaseQuery.IAggregationQuery.minBusinessMilestoneTimestamp()Deprecated.useinsteadcustomField().minTimestampField("BusinessMilestoneTimestamp"))CaseQuery.IAggregationQuery.minBusinessObjectCode()Deprecated.useinsteadcustomField().minStringField("BusinessObjectCode"))CaseQuery.IAggregationQuery.minBusinessObjectDocDbCode()Deprecated.useinsteadcustomField().minStringField("BusinessObjectDocumentDbCode"))CaseQuery.IAggregationQuery.minBusinessObjectFolderId()Deprecated.useinsteadcustomField().minStringField("BusinessObjectFolderId"))CaseQuery.IAggregationQuery.minBusinessObjectName()Deprecated.useinsteadcustomField().minStringField("BusinessObjectName"))CaseQuery.IAggregationQuery.minBusinessPriority()Deprecated.useinsteadcustomField().minStringField("BusinessPriority"))CaseQuery.AggregationQuery.minBusinessRuntime()CaseQuery.IAggregationQuery.minBusinessRuntime()Adds a result columnMinBusinessRuntimeto the query, that contains the minimum value of the fieldBusinessRuntimeof all (grouped) rows.CaseQuery.IAggregationQuery.minBusinessStartTimestamp()Deprecated.useinsteadcustomField().minTimestampField("BusinessStartTimestamp"))CaseQuery.AggregationQuery.minCaseId()CaseQuery.IAggregationQuery.minCaseId()Adds a result columnMinCaseIdto the query, that contains the minimum value of the fieldCaseIdof all (grouped) rows.CaseQuery.AggregationQuery.minCategory()CaseQuery.IAggregationQuery.minCategory()Adds a result columnMinCategoryto the query, that contains the minimum value of the fieldCategoryof all (grouped) rows.CaseQuery.AggregationQuery.minCreatorUserDisplayName()CaseQuery.IAggregationQuery.minCreatorUserDisplayName()Adds a result columnMinCreatorUserDisplayNameto the query, that contains the minimum value of the fieldCreatorUserDisplayNameof all (grouped) rows.CaseQuery.AggregationQuery.minCreatorUserName()CaseQuery.IAggregationQuery.minCreatorUserName()Adds a result columnMinCreatorUserNameto the query, that contains the minimum value of the fieldCreatorUserNameof all (grouped) rows.CaseQuery.IAggregationQuery.minCustomDecimalField1()Deprecated.useinsteadcustomField().minNumberField("CustomDecimalField1"))CaseQuery.IAggregationQuery.minCustomDecimalField2()Deprecated.useinsteadcustomField().minNumberField("CustomDecimalField2"))CaseQuery.IAggregationQuery.minCustomDecimalField3()Deprecated.useinsteadcustomField().minNumberField("CustomDecimalField3"))CaseQuery.IAggregationQuery.minCustomDecimalField4()Deprecated.useinsteadcustomField().minNumberField("CustomDecimalField4"))CaseQuery.IAggregationQuery.minCustomDecimalField5()Deprecated.useinsteadcustomField().minNumberField("CustomDecimalField5"))CaseQuery.IAggregationQuery.minCustomTimestampField1()Deprecated.useinsteadcustomField().minTimestampField("CustomTimestampField1"))CaseQuery.IAggregationQuery.minCustomTimestampField2()Deprecated.useinsteadcustomField().minTimestampField("CustomTimestampField2"))CaseQuery.IAggregationQuery.minCustomTimestampField3()Deprecated.useinsteadcustomField().minTimestampField("CustomTimestampField3"))CaseQuery.IAggregationQuery.minCustomTimestampField4()Deprecated.useinsteadcustomField().minTimestampField("CustomTimestampField4"))CaseQuery.IAggregationQuery.minCustomTimestampField5()Deprecated.useinsteadcustomField().minTimestampField("CustomTimestampField5"))CaseQuery.IAggregationQuery.minCustomVarCharField1()Deprecated.useinsteadcustomField().minStringField("CustomVarCharField1"))CaseQuery.IAggregationQuery.minCustomVarCharField2()Deprecated.useinsteadcustomField().minStringField("CustomVarCharField2"))CaseQuery.IAggregationQuery.minCustomVarCharField3()Deprecated.useinsteadcustomField().minStringField("CustomVarCharField3"))CaseQuery.IAggregationQuery.minCustomVarCharField4()Deprecated.useinsteadcustomField().minStringField("CustomVarCharField4"))CaseQuery.IAggregationQuery.minCustomVarCharField5()Deprecated.useinsteadcustomField().minStringField("CustomVarCharField5"))CaseQuery.AggregationQuery.minEndTimestamp()CaseQuery.IAggregationQuery.minEndTimestamp()Adds a result columnMinEndTimestampto the query, that contains the minimum value of the fieldEndTimestampof all (grouped) rows.CaseQuery.IAggregationQuery.minModifiedTimestamp()Adds a result columnMinModifiedTimestampto the query, that contains the minimum value of the fieldModifiedTimestampof all (grouped) rows.CaseQuery.AggregationQuery.minName()CaseQuery.IAggregationQuery.minName()Adds a result columnMinNameto the query, that contains the minimum value of the fieldNameof all (grouped) rows.CaseQuery.ICustomFieldAggregationQuery.minNumberField(String fieldName) Adds a result customNumberfield columnMin[fieldName]to the query that contains the minimum value of the customNumberfield with namefieldNameof all (grouped) rows.CaseQuery.AggregationQuery.minOwnerDisplayName()CaseQuery.IAggregationQuery.minOwnerDisplayName()Adds a result columnMinOwnerDisplayNameto the query, that contains the minimum value of the fieldOwnerDisplayNameof all (grouped) rows.CaseQuery.AggregationQuery.minOwnerName()CaseQuery.IAggregationQuery.minOwnerName()Adds a result columnMinOwnerNameto the query, that contains the minimum value of the fieldOwnerNameof all (grouped) rows.CaseQuery.IAggregationQuery.minProcessCategoryCode()Deprecated.useinsteadcustomField().minStringField("ProcessCategoryCode"))CaseQuery.IAggregationQuery.minProcessCategoryName()Deprecated.useinsteadcustomField().minStringField("ProcessCategoryName"))CaseQuery.IAggregationQuery.minProcessCode()Deprecated.useinsteadcustomField().minStringField("ProcessCode"))CaseQuery.IAggregationQuery.minProcessName()Deprecated.useinsteadcustomField().minStringField("ProcessName"))CaseQuery.AggregationQuery.minStage()CaseQuery.IAggregationQuery.minStage()Adds a result columnMinStageto the query, that contains the minimum value of the fieldStageof all (grouped) rows.CaseQuery.AggregationQuery.minStartTimestamp()CaseQuery.IAggregationQuery.minStartTimestamp()Adds a result columnMinStartTimestampto the query, that contains the minimum value of the fieldStartTimestampof all (grouped) rows.CaseQuery.IAggregationQuery.minSubTypeCode()Deprecated.useinsteadcustomField().minStringField("SubTypeCode"))CaseQuery.IAggregationQuery.minSubTypeName()Deprecated.useinsteadcustomField().minStringField("SubTypeName"))CaseQuery.IAggregationQuery.minTypeCode()Deprecated.useinsteadcustomField().minStringField("TypeCode"))CaseQuery.IAggregationQuery.minTypeName()Deprecated.useinsteadcustomField().minStringField("TypeName"))CaseQuery.AggregationQuery.minWorkingTime()CaseQuery.IAggregationQuery.minWorkingTime()Adds a result columnMinWorkingTimeto the query, that contains the minimum value of the fieldWorkingTimeof all (grouped) rows.CaseQuery.IAggregationQuery.sumBusinessCorrespondentId()Deprecated.CaseQuery.IAggregationQuery.sumBusinessMainContactId()Deprecated.CaseQuery.IAggregationQuery.sumBusinessMilestoneTimestamp()Deprecated.CaseQuery.AggregationQuery.sumBusinessRuntime()CaseQuery.IAggregationQuery.sumBusinessRuntime()Adds a result columnSumBusinessRuntimeto the query, that contains the sum of the fieldBusinessRuntimeof all (grouped) rows.CaseQuery.IAggregationQuery.sumBusinessStartTimestamp()Deprecated.CaseQuery.IAggregationQuery.sumCustomDecimalField1()Deprecated.useinsteadcustomField().sumsNumberField("CustomDecimalField1"))CaseQuery.IAggregationQuery.sumCustomDecimalField2()Deprecated.useinsteadcustomField().sumsNumberField("CustomDecimalField2"))CaseQuery.IAggregationQuery.sumCustomDecimalField3()Deprecated.useinsteadcustomField().sumsNumberField("CustomDecimalField3"))CaseQuery.IAggregationQuery.sumCustomDecimalField4()Deprecated.useinsteadcustomField().sumsNumberField("CustomDecimalField4"))CaseQuery.IAggregationQuery.sumCustomDecimalField5()Deprecated.useinsteadcustomField().sumsNumberField("CustomDecimalField5"))CaseQuery.IAggregationQuery.sumCustomTimestampField1()Deprecated.CaseQuery.IAggregationQuery.sumCustomTimestampField2()Deprecated.CaseQuery.IAggregationQuery.sumCustomTimestampField3()Deprecated.CaseQuery.IAggregationQuery.sumCustomTimestampField4()Deprecated.CaseQuery.IAggregationQuery.sumCustomTimestampField5()Deprecated.CaseQuery.ICustomFieldAggregationQuery.sumNumberField(String fieldName) Adds a result customNumberfield columnSum[fieldName]to the query that contains the sum of the customNumberfield with namefieldNameof all (grouped) rows.CaseQuery.ICustomFieldAggregationQuery.sumTimestampField(String fieldName) Adds a result customTimestampfield columnSum[fieldName]to the query that contains the sum of the customTimestampfield with namefieldNameof all (grouped) rows.CaseQuery.AggregationQuery.sumWorkingTime()CaseQuery.IAggregationQuery.sumWorkingTime()Adds a result columnSumWorkingTimeto the query, that contains the sum of the fieldWorkingTimeof all (grouped) rows.
insteadcustomField().avgNumberField("BusinessCorrespondentId"))