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 Detail

      • 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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • displayNameTemplate

        TaskQuery.OrderByColumnQuery displayNameTemplate()

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

        Example:

        TaskQuery.create().orderBy().displayNameTemplate()

        SQL part: ORDER BY DisplayNameTemplate ASC

        Returns:
        query for further composition
        See Also:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.

      • displayDescriptionTemplate

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

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

        Example:

        TaskQuery.create().orderBy().displayDescriptionTemplate()

        SQL part: ORDER BY DisplayDescriptionTemplate ASC

        Returns:
        query for further composition
        See Also:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        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:
        TaskQuery.OrderByColumnQuery.descending(), TaskQuery.OrderByColumnQuery.ascending()
        API:
        This public API is available in IvyScript and Java. It has the visibility EXPERT.