Package ch.ivyteam.ivy.workflow.query

Interface TaskQuery.IOrderByQueryColumns

All Known Implementing Classes:
TaskQuery.OrderByColumnQuery, TaskQuery.OrderByQuery
Enclosing class:
TaskQuery
public static interface TaskQuery.IOrderByQueryColumns
Provides methods to order the result by columns of ITask.

Example: 

TaskQuery.create()
  .orderBy()
    .activatorUserId()
    .priority().descending();
Corresponds to SQL: 
SELECT * FROM IWA_Task
  ORDER BY
    ActivatorUserId ASC,
    Priority DESC

API:
This is a public API.

  • Method Details

    • taskId

      TaskQuery.OrderByColumnQuery taskId()

      Adds an order by statement for the column TaskId in the default direction ascending.
      To change the order to descending use taskId().descending()

      Example:

      TaskQuery.create().orderBy().taskId()

      SQL part: ORDER BY TaskId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • caseId

      TaskQuery.OrderByColumnQuery caseId()

      Adds an order by statement for the column CaseId in the default direction ascending.
      To change the order to descending use caseId().descending()

      Example:

      TaskQuery.create().orderBy().caseId()

      SQL part: ORDER BY CaseId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • businessCaseId

      TaskQuery.OrderByColumnQuery businessCaseId()

      Adds an order by statement for the column BusinessCaseId in the default direction ascending.
      To change the order to descending use businessCaseId().descending()

      Example:

      TaskQuery.create().orderBy().businessCaseId()

      SQL part: ORDER BY BusinessCaseId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • processModelId

      TaskQuery.OrderByColumnQuery processModelId()

      Adds an order by statement for the column ProcessModelId in the default direction ascending.
      To change the order to descending use processModelId().descending()

      Example:

      TaskQuery.create().orderBy().processModelId()

      SQL part: ORDER BY ProcessModelId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • securitySystemId

      TaskQuery.OrderByColumnQuery securitySystemId()

      Adds an order by statement for the column SecuritySystemId in the default direction ascending.
      To change the order to descending use securitySystemId().descending()

      Example:

      TaskQuery.create().orderBy().securitySystemId()

      SQL part: ORDER BY SecuritySystemId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • applicationId

      TaskQuery.OrderByColumnQuery applicationId()

      Adds an order by statement for the column ApplicationId in the default direction ascending.
      To change the order to descending use applicationId().descending()

      Example:

      TaskQuery.create().orderBy().applicationId()

      SQL part: ORDER BY ApplicationId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • startTaskSwitchEventId

      TaskQuery.OrderByColumnQuery startTaskSwitchEventId()

      Adds an order by statement for the column StartTaskSwitchEventId in the default direction ascending.
      To change the order to descending use startTaskSwitchEventId().descending()

      Example:

      TaskQuery.create().orderBy().startTaskSwitchEventId()

      SQL part: ORDER BY StartTaskSwitchEventId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • endTaskSwitchEventId

      TaskQuery.OrderByColumnQuery endTaskSwitchEventId()

      Adds an order by statement for the column EndTaskSwitchEventId in the default direction ascending.
      To change the order to descending use endTaskSwitchEventId().descending()

      Example:

      TaskQuery.create().orderBy().endTaskSwitchEventId()

      SQL part: ORDER BY EndTaskSwitchEventId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • taskStartId

      TaskQuery.OrderByColumnQuery taskStartId()

      Adds an order by statement for the column TaskStartId in the default direction ascending.
      To change the order to descending use taskStartId().descending()

      Example:

      TaskQuery.create().orderBy().taskStartId()

      SQL part: ORDER BY TaskStartId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • taskEndId

      TaskQuery.OrderByColumnQuery taskEndId()

      Adds an order by statement for the column TaskEndId in the default direction ascending.
      To change the order to descending use taskEndId().descending()

      Example:

      TaskQuery.create().orderBy().taskEndId()

      SQL part: ORDER BY TaskEndId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • workerId

      TaskQuery.OrderByColumnQuery workerId()

      Adds an order by statement for the column WorkerId in the default direction ascending.
      To change the order to descending use workerId().descending()

      Example:

      TaskQuery.create().orderBy().workerId()

      SQL part: ORDER BY WorkerId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • workerUserName

      TaskQuery.OrderByColumnQuery workerUserName()

      Adds an order by statement for the column WorkerUserName in the default direction ascending.
      To change the order to descending use workerUserName().descending()

      Example:

      TaskQuery.create().orderBy().workerUserName()

      SQL part: ORDER BY WorkerUserName ASC

      This is a virtual column. It contains the same value as the column Name of the referenced Worker.


      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • workerUserDisplayName

      TaskQuery.OrderByColumnQuery workerUserDisplayName()

      Adds an order by statement for the column WorkerUserDisplayName in the default direction ascending.
      To change the order to descending use workerUserDisplayName().descending()

      Example:

      TaskQuery.create().orderBy().workerUserDisplayName()

      SQL part: ORDER BY WorkerUserDisplayName ASC

      This is a virtual column. It contains the same value as the column DisplayName of the referenced Worker.


      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • workerSessionId

      TaskQuery.OrderByColumnQuery workerSessionId()

      Adds an order by statement for the column WorkerSessionId in the default direction ascending.
      To change the order to descending use workerSessionId().descending()

      Example:

      TaskQuery.create().orderBy().workerSessionId()

      SQL part: ORDER BY WorkerSessionId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • activatorId

      TaskQuery.OrderByColumnQuery activatorId()

      Adds an order by statement for the column ActivatorId in the default direction ascending.
      To change the order to descending use activatorId().descending()

      Example:

      TaskQuery.create().orderBy().activatorId()

      SQL part: ORDER BY ActivatorId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • originalActivatorId

      TaskQuery.OrderByColumnQuery originalActivatorId()

      Adds an order by statement for the column OriginalActivatorId in the default direction ascending.
      To change the order to descending use originalActivatorId().descending()

      Example:

      TaskQuery.create().orderBy().originalActivatorId()

      SQL part: ORDER BY OriginalActivatorId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • originalActivatorName

      TaskQuery.OrderByColumnQuery originalActivatorName()

      Adds an order by statement for the column OriginalActivatorName in the default direction ascending.
      To change the order to descending use originalActivatorName().descending()

      Example:

      TaskQuery.create().orderBy().originalActivatorName()

      SQL part: ORDER BY OriginalActivatorName ASC

      This is a virtual column. It contains the same value as the column MemberName of the referenced OriginalActivator.


      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • originalActivatorDisplayName

      TaskQuery.OrderByColumnQuery originalActivatorDisplayName()

      Adds an order by statement for the column OriginalActivatorDisplayName in the default direction ascending.
      To change the order to descending use originalActivatorDisplayName().descending()

      Example:

      TaskQuery.create().orderBy().originalActivatorDisplayName()

      SQL part: ORDER BY OriginalActivatorDisplayName ASC

      This is a virtual column. It contains the same value as the column DisplayName of the referenced OriginalActivator.


      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • expiryActivatorId

      TaskQuery.OrderByColumnQuery expiryActivatorId()

      Adds an order by statement for the column ExpiryActivatorId in the default direction ascending.
      To change the order to descending use expiryActivatorId().descending()

      Example:

      TaskQuery.create().orderBy().expiryActivatorId()

      SQL part: ORDER BY ExpiryActivatorId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • expiryActivatorName

      TaskQuery.OrderByColumnQuery expiryActivatorName()

      Adds an order by statement for the column ExpiryActivatorName in the default direction ascending.
      To change the order to descending use expiryActivatorName().descending()

      Example:

      TaskQuery.create().orderBy().expiryActivatorName()

      SQL part: ORDER BY ExpiryActivatorName ASC

      This is a virtual column. It contains the same value as the column MemberName of the referenced ExpiryActivator.


      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • expiryActivatorDisplayName

      TaskQuery.OrderByColumnQuery expiryActivatorDisplayName()

      Adds an order by statement for the column ExpiryActivatorDisplayName in the default direction ascending.
      To change the order to descending use expiryActivatorDisplayName().descending()

      Example:

      TaskQuery.create().orderBy().expiryActivatorDisplayName()

      SQL part: ORDER BY ExpiryActivatorDisplayName ASC

      This is a virtual column. It contains the same value as the column DisplayName of the referenced ExpiryActivator.


      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • expiryPriority

      TaskQuery.OrderByColumnQuery expiryPriority()

      Adds an order by statement for the column ExpiryPriority in the default direction ascending.
      To change the order to descending use expiryPriority().descending()

      Example:

      TaskQuery.create().orderBy().expiryPriority()

      SQL part: ORDER BY ExpiryPriority ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • expiryTimestamp

      TaskQuery.OrderByColumnQuery expiryTimestamp()

      Adds an order by statement for the column ExpiryTimestamp in the default direction ascending.
      To change the order to descending use expiryTimestamp().descending()

      Example:

      TaskQuery.create().orderBy().expiryTimestamp()

      SQL part: ORDER BY ExpiryTimestamp ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • expiryTaskStartElementPid

      TaskQuery.OrderByColumnQuery expiryTaskStartElementPid()

      Adds an order by statement for the column ExpiryTaskStartElementPid in the default direction ascending.
      To change the order to descending use expiryTaskStartElementPid().descending()

      Example:

      TaskQuery.create().orderBy().expiryTaskStartElementPid()

      SQL part: ORDER BY ExpiryTaskStartElementPid ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • isExpired

      TaskQuery.OrderByColumnQuery isExpired()

      Adds an order by statement for the column IsExpired in the default direction ascending.
      To change the order to descending use isExpired().descending()

      Example:

      TaskQuery.create().orderBy().isExpired()

      SQL part: ORDER BY IsExpired ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • expiredCreatorTaskId

      TaskQuery.OrderByColumnQuery expiredCreatorTaskId()

      Adds an order by statement for the column ExpiredCreatorTaskId in the default direction ascending.
      To change the order to descending use expiredCreatorTaskId().descending()

      Example:

      TaskQuery.create().orderBy().expiredCreatorTaskId()

      SQL part: ORDER BY ExpiredCreatorTaskId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • timeoutedCreatorIntrmdtEventId

      TaskQuery.OrderByColumnQuery timeoutedCreatorIntrmdtEventId()

      Adds an order by statement for the column TimeoutedCreatorIntrmdtEventId in the default direction ascending.
      To change the order to descending use timeoutedCreatorIntrmdtEventId().descending()

      Example:

      TaskQuery.create().orderBy().timeoutedCreatorIntrmdtEventId()

      SQL part: ORDER BY TimeoutedCreatorIntrmdtEventId ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • delayTimestamp

      TaskQuery.OrderByColumnQuery delayTimestamp()

      Adds an order by statement for the column DelayTimestamp in the default direction ascending.
      To change the order to descending use delayTimestamp().descending()

      Example:

      TaskQuery.create().orderBy().delayTimestamp()

      SQL part: ORDER BY DelayTimestamp ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • state

      TaskQuery.OrderByColumnQuery state()

      Adds an order by statement for the column State in the default direction ascending.
      To change the order to descending use state().descending()

      Example:

      TaskQuery.create().orderBy().state()

      SQL part: ORDER BY State ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • requestPath

      TaskQuery.OrderByColumnQuery requestPath()

      Adds an order by statement for the column RequestPath in the default direction ascending.
      To change the order to descending use requestPath().descending()

      Example:

      TaskQuery.create().orderBy().requestPath()

      SQL part: ORDER BY RequestPath ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • name

      TaskQuery.OrderByColumnQuery name()

      Adds an order by statement for the column Name in the default direction ascending.
      To change the order to descending use name().descending()

      Example:

      TaskQuery.create().orderBy().name()

      SQL part: ORDER BY Name ASC

      This is a virtual column. It contains the same value as the column Name of the referenced TaskLocalized.


      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • description

      @Deprecated TaskQuery.OrderByColumnQuery description()
      Deprecated.
      ordering by CLOB fields is not possible.

      Adds an order by statement for the column Description in the default direction ascending.
      To change the order to descending use description().descending()

      Example:

      TaskQuery.create().orderBy().description()

      SQL part: ORDER BY Description ASC

      This is a virtual column. It contains the same value as the column Description of the referenced TaskLocalized.


      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • priority

      TaskQuery.OrderByColumnQuery priority()

      Adds an order by statement for the column Priority in the default direction ascending.
      To change the order to descending use priority().descending()

      Example:

      TaskQuery.create().orderBy().priority()

      SQL part: ORDER BY Priority ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • originalPriority

      TaskQuery.OrderByColumnQuery originalPriority()

      Adds an order by statement for the column OriginalPriority in the default direction ascending.
      To change the order to descending use originalPriority().descending()

      Example:

      TaskQuery.create().orderBy().originalPriority()

      SQL part: ORDER BY OriginalPriority ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • startTimestamp

      TaskQuery.OrderByColumnQuery startTimestamp()

      Adds an order by statement for the column StartTimestamp in the default direction ascending.
      To change the order to descending use startTimestamp().descending()

      Example:

      TaskQuery.create().orderBy().startTimestamp()

      SQL part: ORDER BY StartTimestamp ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • endTimestamp

      TaskQuery.OrderByColumnQuery endTimestamp()

      Adds an order by statement for the column EndTimestamp in the default direction ascending.
      To change the order to descending use endTimestamp().descending()

      Example:

      TaskQuery.create().orderBy().endTimestamp()

      SQL part: ORDER BY EndTimestamp ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • businessCalendar

      TaskQuery.OrderByColumnQuery businessCalendar()

      Adds an order by statement for the column BusinessCalendar in the default direction ascending.
      To change the order to descending use businessCalendar().descending()

      Example:

      TaskQuery.create().orderBy().businessCalendar()

      SQL part: ORDER BY BusinessCalendar ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • workingTime

      TaskQuery.OrderByColumnQuery workingTime()

      Adds an order by statement for the column WorkingTime in the default direction ascending.
      To change the order to descending use workingTime().descending()

      Example:

      TaskQuery.create().orderBy().workingTime()

      SQL part: ORDER BY WorkingTime ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • businessRuntime

      TaskQuery.OrderByColumnQuery businessRuntime()

      Adds an order by statement for the column BusinessRuntime in the default direction ascending.
      To change the order to descending use businessRuntime().descending()

      Example:

      TaskQuery.create().orderBy().businessRuntime()

      SQL part: ORDER BY BusinessRuntime ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • failedTimeoutTimestamp

      TaskQuery.OrderByColumnQuery failedTimeoutTimestamp()

      Adds an order by statement for the column FailedTimeoutTimestamp in the default direction ascending.
      To change the order to descending use failedTimeoutTimestamp().descending()

      Example:

      TaskQuery.create().orderBy().failedTimeoutTimestamp()

      SQL part: ORDER BY FailedTimeoutTimestamp ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • numberOfFailures

      TaskQuery.OrderByColumnQuery numberOfFailures()

      Adds an order by statement for the column NumberOfFailures in the default direction ascending.
      To change the order to descending use numberOfFailures().descending()

      Example:

      TaskQuery.create().orderBy().numberOfFailures()

      SQL part: ORDER BY NumberOfFailures ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • numberOfResumes

      TaskQuery.OrderByColumnQuery numberOfResumes()

      Adds an order by statement for the column NumberOfResumes in the default direction ascending.
      To change the order to descending use numberOfResumes().descending()

      Example:

      TaskQuery.create().orderBy().numberOfResumes()

      SQL part: ORDER BY NumberOfResumes ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • category

      TaskQuery.OrderByColumnQuery category()

      Adds an order by statement for the column Category in the default direction ascending.
      To change the order to descending use category().descending()

      Example:

      TaskQuery.create().orderBy().category()

      SQL part: ORDER BY Category ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • isUpdatedOnStart

      TaskQuery.OrderByColumnQuery isUpdatedOnStart()

      Adds an order by statement for the column IsUpdatedOnStart in the default direction ascending.
      To change the order to descending use isUpdatedOnStart().descending()

      Example:

      TaskQuery.create().orderBy().isUpdatedOnStart()

      SQL part: ORDER BY IsUpdatedOnStart ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • isOffline

      TaskQuery.OrderByColumnQuery isOffline()

      Adds an order by statement for the column IsOffline in the default direction ascending.
      To change the order to descending use isOffline().descending()

      Example:

      TaskQuery.create().orderBy().isOffline()

      SQL part: ORDER BY IsOffline ASC

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • activatorName

      TaskQuery.OrderByColumnQuery activatorName()

      Adds an order by statement for the column ActivatorName in the default direction ascending.
      To change the order to descending use activatorName().descending()

      Example:

      TaskQuery.create().orderBy().activatorName()

      SQL part: ORDER BY ActivatorName ASC

      This is a virtual column. It contains the same value as the column MemberName of the referenced Activator.


      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • activatorDisplayName

      TaskQuery.OrderByColumnQuery activatorDisplayName()

      Adds an order by statement for the column ActivatorDisplayName in the default direction ascending.
      To change the order to descending use activatorDisplayName().descending()

      Example:

      TaskQuery.create().orderBy().activatorDisplayName()

      SQL part: ORDER BY ActivatorDisplayName ASC

      This is a virtual column. It contains the same value as the column DisplayName of the referenced Activator.


      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • languageId

      TaskQuery.OrderByColumnQuery languageId()

      Adds an order by statement for the column LanguageId in the default direction ascending.
      To change the order to descending use languageId().descending()

      Example:

      TaskQuery.create().orderBy().languageId()

      SQL part: ORDER BY LanguageId ASC

      This is a virtual column. It contains the same value as the column LanguageId of the referenced TaskLocalized.


      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • customField

      TaskQuery.ICustomFieldOrderBy customField()

      Adds an order by statement for a custom field in the default direction ascending.
      To change the order to descending use customField().descending()

      Example:

      TaskQuery.create().orderBy().customField().stringField("myStringField")

      Returns:
      query for further composition
      See Also:
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.