Class TaskBoundarySignalEventReceiverQuery.AggregationQuery
- All Implemented Interfaces:
TaskBoundarySignalEventReceiverQuery.IAggregationQuery
- Enclosing class:
- TaskBoundarySignalEventReceiverQuery
- API:
- This is a public API.
-
Nested Class Summary
Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.TaskBoundarySignalEventReceiverQuery
TaskBoundarySignalEventReceiverQuery.AggregationQuery, TaskBoundarySignalEventReceiverQuery.FilterLink, TaskBoundarySignalEventReceiverQuery.FilterQuery, TaskBoundarySignalEventReceiverQuery.GroupByQuery, TaskBoundarySignalEventReceiverQuery.IAggregationQuery, TaskBoundarySignalEventReceiverQuery.IBoolFilterQuery, TaskBoundarySignalEventReceiverQuery.IColumnFilterQuery, TaskBoundarySignalEventReceiverQuery.IFilterableColumns, TaskBoundarySignalEventReceiverQuery.IFilterLink, TaskBoundarySignalEventReceiverQuery.IFilterQuery, TaskBoundarySignalEventReceiverQuery.IGroupByQueryColumns, TaskBoundarySignalEventReceiverQuery.IIntegerColumnFilterQuery, TaskBoundarySignalEventReceiverQuery.INumberColumnFilterQuery, TaskBoundarySignalEventReceiverQuery.IOrderByQueryColumns, TaskBoundarySignalEventReceiverQuery.IPatternColumnFilterQuery, TaskBoundarySignalEventReceiverQuery.IStringColumnFilterQuery, TaskBoundarySignalEventReceiverQuery.OrderByColumnQuery, TaskBoundarySignalEventReceiverQuery.OrderByQuery
-
Method Summary
Modifier and TypeMethodDescriptionAdds a result columnCount
to the query, that contains the number of (grouped) rows.Adds a result columnMaxSignalCodePattern
to the query, that contains the maximum value of the fieldSignalCodePattern
of all (grouped) rows.Adds a result columnMaxTaskSignalEventId
to the query, that contains the maximum value of the fieldTaskSignalEventId
of all (grouped) rows.Adds a result columnMinSignalCodePattern
to the query, that contains the minimum value of the fieldSignalCodePattern
of all (grouped) rows.Adds a result columnMinTaskSignalEventId
to the query, that contains the minimum value of the fieldTaskSignalEventId
of all (grouped) rows.
-
Method Details
-
countRows
Description copied from interface:TaskBoundarySignalEventReceiverQuery.IAggregationQuery
Adds a result column
Count
to the query, that contains the number of (grouped) rows.SQL part:
COUNT(*) AS Count
- Specified by:
countRows
in interfaceTaskBoundarySignalEventReceiverQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minTaskSignalEventId
Description copied from interface:TaskBoundarySignalEventReceiverQuery.IAggregationQuery
Adds a result column
MinTaskSignalEventId
to the query, that contains the minimum value of the fieldTaskSignalEventId
of all (grouped) rows.SQL part:
MIN(TaskSignalEventId) AS MinTaskSignalEventId
- Specified by:
minTaskSignalEventId
in interfaceTaskBoundarySignalEventReceiverQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxTaskSignalEventId
Description copied from interface:TaskBoundarySignalEventReceiverQuery.IAggregationQuery
Adds a result column
MaxTaskSignalEventId
to the query, that contains the maximum value of the fieldTaskSignalEventId
of all (grouped) rows.SQL part:
MAX(TaskSignalEventId) AS MaxTaskSignalEventId
- Specified by:
maxTaskSignalEventId
in interfaceTaskBoundarySignalEventReceiverQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minSignalCodePattern
Description copied from interface:TaskBoundarySignalEventReceiverQuery.IAggregationQuery
Adds a result column
MinSignalCodePattern
to the query, that contains the minimum value of the fieldSignalCodePattern
of all (grouped) rows.SQL part:
MIN(SignalCodePattern) AS MinSignalCodePattern
- Specified by:
minSignalCodePattern
in interfaceTaskBoundarySignalEventReceiverQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxSignalCodePattern
Description copied from interface:TaskBoundarySignalEventReceiverQuery.IAggregationQuery
Adds a result column
MaxSignalCodePattern
to the query, that contains the maximum value of the fieldSignalCodePattern
of all (grouped) rows.SQL part:
MAX(SignalCodePattern) AS MaxSignalCodePattern
- Specified by:
maxSignalCodePattern
in interfaceTaskBoundarySignalEventReceiverQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-