Package ch.ivyteam.ivy.workflow.query

Class CaseQuery.StringValueOrderByColumnQuery

java.lang.Object

ch.ivyteam.ivy.persistence.query.Query<ICase>

ch.ivyteam.ivy.workflow.query.CaseQuery

ch.ivyteam.ivy.workflow.query.CaseQuery.OrderByQuery

ch.ivyteam.ivy.workflow.query.CaseQuery.OrderByColumnQuery

ch.ivyteam.ivy.workflow.query.CaseQuery.StringValueOrderByColumnQuery

All Implemented Interfaces:

CaseQuery.IOrderByQueryColumns

Enclosing class:

CaseQuery

public class CaseQuery.StringValueOrderByColumnQuery
extends CaseQuery.OrderByColumnQuery

API:

This is a public API.

Nested Class Summary

Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery

CaseQuery.AggregationQuery, CaseQuery.EnumValueOrderByColumnQuery<T extends ch.ivyteam.ivy.persistence.IPersistentEnumeration>, CaseQuery.FilterLink, CaseQuery.FilterQuery, CaseQuery.GroupByQuery, CaseQuery.IAggregationQuery, CaseQuery.IBoolFilterQuery, CaseQuery.ICaseBusinessStateFilterQuery, CaseQuery.ICaseStateFilterQuery, CaseQuery.IClobColumnFilterQuery, CaseQuery.IColumnFilterQuery, CaseQuery.ICustomFieldAggregationQuery, CaseQuery.ICustomFieldFilterQuery, CaseQuery.ICustomFieldGroupBy, CaseQuery.ICustomFieldOrderBy, CaseQuery.IDateColumnFilterQuery, CaseQuery.IFilterableColumns, CaseQuery.IFilterLink, CaseQuery.IFilterQuery, CaseQuery.IGroupByQueryColumns, CaseQuery.IIntegerColumnFilterQuery, CaseQuery.INumberColumnFilterQuery, CaseQuery.IOrderByQueryColumns, CaseQuery.IPatternColumnFilterQuery, CaseQuery.IStringColumnFilterQuery, CaseQuery.IUUIDColumnFilterQuery, CaseQuery.IWorkflowPriorityFilterQuery, CaseQuery.LongValueOrderByColumnQuery, CaseQuery.OrderByColumnQuery, CaseQuery.OrderByQuery, CaseQuery.StringValueOrderByColumnQuery

Method Summary

Modifier and Type	Method	Description
CaseQuery.OrderByColumnQuery	values(String... valueOrder)	Adds an order by statement for the specified column in the order of the given values.
CaseQuery.OrderByColumnQuery	values(List<String> valueOrder)	Adds an order by statement for the specified column in the order of the given values.

Methods inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery.OrderByColumnQuery

ascending, ascendingNullFirst, ascendingNullLast, descending, descendingNullFirst, descendingNullLast

Methods inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery.OrderByQuery

activatorId, applicationId, businessCalendar, businessCalendarId, businessCaseId, businessRuntime, businessState, caseId, category, creatorId, creatorTaskId, creatorUserDisplayName, creatorUserName, customField, description, displayDescriptionTemplate, displayNameTemplate, endTimestamp, languageId, name, ownerDisplayName, ownerId, ownerName, priority, processModelId, securitySystemId, stage, startTimestamp, state, taskStartId, workingTime

Methods inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery

aggregate, asJson, businessCases, create, executor, fromJson, groupBy, orderBy, subCases, toType, where

Methods inherited from class ch.ivyteam.ivy.persistence.query.Query

equals, hashCode

Method Details

values

public CaseQuery.OrderByColumnQuery values(List<String> valueOrder)

Adds an order by statement for the specified column in the order of the given values.

Example:

TaskQuery.create().orderBy().customField().stringField("ProductKind").values(List.of("Food", "Hardware", "Clothes"))

SQL part: ORDER BY CASE WHEN ProductKind='Food' THEN 0 WHEN PrroductKind='Hardware' THEN 1 WHEN ProductKind='Clothes' THEN 2 ELSE 3 END ASC

Parameters:

valueOrder - List of strings that define the order of the result

Returns:

query for further composition

API:

This public API is available in Java.

values

public CaseQuery.OrderByColumnQuery values(String... valueOrder)

Adds an order by statement for the specified column in the order of the given values.

Example:

TaskQuery.create().orderBy().customField().stringField("ProductKind").values("Food", "Hardware", "Clothes")

SQL part: ORDER BY CASE WHEN ProductKind='Food' THEN 0 WHEN PrroductKind='Hardware' THEN 1 WHEN ProductKind='Clothes' THEN 2 ELSE 3 END ASC

Parameters:

valueOrder - List of strings that define the order of the result

Returns:

query for further composition

API:

This public API is available in Java.