Package ch.ivyteam.ivy.workflow.query

Interface CaseQuery.IOrderByQueryColumns

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

Example: 

CaseQuery.businessCases()
  .orderBy()
    .ownerUserId()
    .startTimestamp().descending();
Corresponds to SQL: 
SELECT * FROM IWA_Case
  ORDER BY
    OwnerUserId ASC,
    StartTimestamp DESC

API:
This is a public API.

  • Method Summary

    Modifier and Type
    Method
    Description
    CaseQuery.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()
    CaseQuery.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()
    CaseQuery.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()
    CaseQuery.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()
    CaseQuery.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()
    CaseQuery.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()
    CaseQuery.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()
    CaseQuery.OrderByColumnQuery
    creatorId()
    Adds an order by statement for the column CreatorId in the default direction ascending.
    To change the order to descending use creatorId().descending()
    CaseQuery.OrderByColumnQuery
    creatorTaskId()
    Adds an order by statement for the column CreatorTaskId in the default direction ascending.
    To change the order to descending use creatorTaskId().descending()
    CaseQuery.OrderByColumnQuery
    creatorUserDisplayName()
    Adds an order by statement for the column CreatorUserDisplayName in the default direction ascending.
    To change the order to descending use creatorUserDisplayName().descending()
    CaseQuery.OrderByColumnQuery
    creatorUserName()
    Adds an order by statement for the column CreatorUserName in the default direction ascending.
    To change the order to descending use creatorUserName().descending()
    CaseQuery.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()
    CaseQuery.OrderByColumnQuery
    description()
    Deprecated.
    ordering by CLOB fields is not possible.
    CaseQuery.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()
    CaseQuery.OrderByColumnQuery
    environment()
    Adds an order by statement for the column Environment in the default direction ascending.
    To change the order to descending use environment().descending()
    CaseQuery.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()
    CaseQuery.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()
    CaseQuery.OrderByColumnQuery
    ownerDisplayName()
    Adds an order by statement for the column OwnerDisplayName in the default direction ascending.
    To change the order to descending use ownerDisplayName().descending()
    CaseQuery.OrderByColumnQuery
    ownerId()
    Adds an order by statement for the column OwnerId in the default direction ascending.
    To change the order to descending use ownerId().descending()
    CaseQuery.OrderByColumnQuery
    ownerName()
    Adds an order by statement for the column OwnerName in the default direction ascending.
    To change the order to descending use ownerName().descending()
    CaseQuery.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()
    CaseQuery.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()
    CaseQuery.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()
    CaseQuery.OrderByColumnQuery
    stage()
    Adds an order by statement for the column Stage in the default direction ascending.
    To change the order to descending use stage().descending()
    CaseQuery.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()
    CaseQuery.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()
    CaseQuery.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()
    CaseQuery.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()

  • Method Details

    • caseId

      CaseQuery.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:

      CaseQuery.businessCases().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

      CaseQuery.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:

      CaseQuery.businessCases().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.

    • securitySystemId

      CaseQuery.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:

      CaseQuery.businessCases().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

      CaseQuery.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:

      CaseQuery.businessCases().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.

    • processModelId

      CaseQuery.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:

      CaseQuery.businessCases().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.

    • taskStartId

      CaseQuery.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:

      CaseQuery.businessCases().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.

    • activatorId

      CaseQuery.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:

      CaseQuery.businessCases().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.

    • creatorId

      CaseQuery.OrderByColumnQuery creatorId()

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

      Example:

      CaseQuery.businessCases().orderBy().creatorId()

      SQL part: ORDER BY CreatorId ASC

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

    • creatorUserName

      CaseQuery.OrderByColumnQuery creatorUserName()

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

      Example:

      CaseQuery.businessCases().orderBy().creatorUserName()

      SQL part: ORDER BY CreatorUserName ASC

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


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

    • creatorUserDisplayName

      CaseQuery.OrderByColumnQuery creatorUserDisplayName()

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

      Example:

      CaseQuery.businessCases().orderBy().creatorUserDisplayName()

      SQL part: ORDER BY CreatorUserDisplayName ASC

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


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

    • creatorTaskId

      CaseQuery.OrderByColumnQuery creatorTaskId()

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

      Example:

      CaseQuery.businessCases().orderBy().creatorTaskId()

      SQL part: ORDER BY CreatorTaskId ASC

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

    • environment

      CaseQuery.OrderByColumnQuery environment()

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

      Example:

      CaseQuery.businessCases().orderBy().environment()

      SQL part: ORDER BY Environment ASC

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

    • name

      CaseQuery.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:

      CaseQuery.businessCases().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 CaseLocalized.


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

    • description

      @Deprecated CaseQuery.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:

      CaseQuery.businessCases().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 CaseLocalized.


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

    • startTimestamp

      CaseQuery.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:

      CaseQuery.businessCases().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

      CaseQuery.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:

      CaseQuery.businessCases().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

      CaseQuery.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:

      CaseQuery.businessCases().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

      CaseQuery.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:

      CaseQuery.businessCases().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

      CaseQuery.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:

      CaseQuery.businessCases().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.

    • state

      CaseQuery.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:

      CaseQuery.businessCases().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.

    • priority

      CaseQuery.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:

      CaseQuery.businessCases().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.

    • stage

      CaseQuery.OrderByColumnQuery stage()

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

      Example:

      CaseQuery.businessCases().orderBy().stage()

      SQL part: ORDER BY Stage ASC

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

    • ownerId

      CaseQuery.OrderByColumnQuery ownerId()

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

      Example:

      CaseQuery.businessCases().orderBy().ownerId()

      SQL part: ORDER BY OwnerId ASC

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

    • ownerName

      CaseQuery.OrderByColumnQuery ownerName()

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

      Example:

      CaseQuery.businessCases().orderBy().ownerName()

      SQL part: ORDER BY OwnerName ASC

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


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

    • ownerDisplayName

      CaseQuery.OrderByColumnQuery ownerDisplayName()

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

      Example:

      CaseQuery.businessCases().orderBy().ownerDisplayName()

      SQL part: ORDER BY OwnerDisplayName ASC

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


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

    • category

      CaseQuery.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:

      CaseQuery.businessCases().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.

    • languageId

      CaseQuery.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:

      CaseQuery.businessCases().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 CaseLocalized.


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

    • customField

      CaseQuery.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:

      CaseQuery.businessCases().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.