Class TaskQueryImpl

java.lang.Object
io.kadai.task.internal.TaskQueryImpl
All Implemented Interfaces:
io.kadai.common.api.BaseQuery<TaskSummary,TaskQueryColumnName>, TaskQuery

public class TaskQueryImpl extends Object implements TaskQuery
TaskQuery for generating dynamic sql.
  • Method Details

    • idIn

      public TaskQuery idIn(String... taskIds)
      Description copied from interface: TaskQuery
      Filter for summaries which contain one of the given taskIds.
      Specified by:
      idIn in interface TaskQuery
      Parameters:
      taskIds - The ids of the searched-for tasks.
      Returns:
      the taskQuery
    • idNotIn

      public TaskQuery idNotIn(String... taskIds)
      Description copied from interface: TaskQuery
      Exclude summaries which contain one of the given taskIds.
      Specified by:
      idNotIn in interface TaskQuery
      Parameters:
      taskIds - The ids of the searched-for tasks.
      Returns:
      the taskQuery
    • orderByTaskId

      public TaskQuery orderByTaskId(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the primary task id.
      Specified by:
      orderByTaskId in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • externalIdIn

      public TaskQuery externalIdIn(String... externalIds)
      Description copied from interface: TaskQuery
      Add your external ids to your query.
      Specified by:
      externalIdIn in interface TaskQuery
      Parameters:
      externalIds - the external ids as Strings
      Returns:
      the query
    • externalIdNotIn

      public TaskQuery externalIdNotIn(String... externalIds)
      Description copied from interface: TaskQuery
      Exclude these external ids from your query.
      Specified by:
      externalIdNotIn in interface TaskQuery
      Parameters:
      externalIds - the external ids as Strings
      Returns:
      the query
    • receivedWithin

      public TaskQuery receivedWithin(io.kadai.common.api.TimeInterval... intervals)
      Description copied from interface: TaskQuery
      Add the time intervals within which the task is received to your query. For each time interval, the database query will search for tasks whose received timestamp is before the interval's begin and after the interval's end. If more than one interval is specified, the query will connect them with the OR keyword. If either begin or end of an interval are null, these values will not be specified in the query.
      Specified by:
      receivedWithin in interface TaskQuery
      Parameters:
      intervals - - the TimeIntervals within which the task is received
      Returns:
      the query
    • receivedNotWithin

      public TaskQuery receivedNotWithin(io.kadai.common.api.TimeInterval... intervals)
      Description copied from interface: TaskQuery
      Exclude the time intervals within which the task wasn't received from your query. For each time interval, the database query will search for tasks whose received timestamp is before the interval's begin and after the interval's end. If more than one interval is specified, the query will connect them with the OR keyword. If either begin or end of an interval are null, these values will not be specified in the query.
      Specified by:
      receivedNotWithin in interface TaskQuery
      Parameters:
      intervals - - the TimeIntervals within which the task wasn't received
      Returns:
      the query
    • orderByReceived

      public TaskQuery orderByReceived(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the received timestamp.
      Specified by:
      orderByReceived in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • createdWithin

      public TaskQuery createdWithin(io.kadai.common.api.TimeInterval... intervals)
      Description copied from interface: TaskQuery
      Add the time intervals within which the task was created to your query. For each time interval, the database query will search for tasks whose created timestamp is after or at the interval's begin and before or at the interval's end. If more than one interval is specified, the query will connect them with the OR keyword. If either begin or end of an interval are null, these values will not be specified in the query.
      Specified by:
      createdWithin in interface TaskQuery
      Parameters:
      intervals - - the TimeIntervals within which the task was created
      Returns:
      the query
    • createdNotWithin

      public TaskQuery createdNotWithin(io.kadai.common.api.TimeInterval... intervals)
      Description copied from interface: TaskQuery
      Exclude the time intervals within which the task wasn't created from your query. For each time interval, the database query will search for tasks whose created timestamp is before the interval's begin and after the interval's end. If more than one interval is specified, the query will connect them with the OR keyword. If either begin or end of an interval are null, these values will not be specified in the query.
      Specified by:
      createdNotWithin in interface TaskQuery
      Parameters:
      intervals - - the TimeIntervals within which the task wasn't created
      Returns:
      the query
    • orderByCreated

      public TaskQuery orderByCreated(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the created timestamp.
      Specified by:
      orderByCreated in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • claimedWithin

      public TaskQuery claimedWithin(io.kadai.common.api.TimeInterval... intervals)
      Description copied from interface: TaskQuery
      Add the time intervals within which the task was claimed to your query. For each time interval, the database query will search for tasks whose claimed timestamp is after or at the interval's begin and before or at the interval's end. If more than one interval is specified, the query will connect them with the OR keyword. If either begin or end of an interval are null, these values will not be specified in the query.
      Specified by:
      claimedWithin in interface TaskQuery
      Parameters:
      intervals - - the TimeIntervals within which the task was claimed
      Returns:
      the query
    • claimedNotWithin

      public TaskQuery claimedNotWithin(io.kadai.common.api.TimeInterval... intervals)
      Description copied from interface: TaskQuery
      Exclude the time intervals within which the task wasn't claimed from your query. For each time interval, the database query will search for tasks whose claimed timestamp is before the interval's begin and after the interval's end. If more than one interval is specified, the query will connect them with the OR keyword. If either begin or end of an interval are null, these values will not be specified in the query.
      Specified by:
      claimedNotWithin in interface TaskQuery
      Parameters:
      intervals - - the TimeIntervals within which the task wasn't claimed
      Returns:
      the query
    • orderByClaimed

      public TaskQuery orderByClaimed(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the claimed timestamp.
      Specified by:
      orderByClaimed in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • modifiedWithin

      public TaskQuery modifiedWithin(io.kadai.common.api.TimeInterval... intervals)
      Description copied from interface: TaskQuery
      Add the time intervals within which the task wasn't modified to your query. For each time interval, the database query will search for tasks whose modified timestamp is after or at the interval's begin and before or at the interval's end. If more than one interval is specified, the query will connect them with the OR keyword. If either begin or end of an interval are null, these values will not be specified in the query.
      Specified by:
      modifiedWithin in interface TaskQuery
      Parameters:
      intervals - - the TimeIntervals within which the task was modified
      Returns:
      the query
    • modifiedNotWithin

      public TaskQuery modifiedNotWithin(io.kadai.common.api.TimeInterval... intervals)
      Description copied from interface: TaskQuery
      Exclude the time intervals within which the task wasn't modified from your query. For each time interval, the database query will search for tasks whose modified timestamp is before the interval's begin and after the interval's end. If more than one interval is specified, the query will connect them with the OR keyword. If either begin or end of an interval are null, these values will not be specified in the query.
      Specified by:
      modifiedNotWithin in interface TaskQuery
      Parameters:
      intervals - - the TimeIntervals within which the task wasn't modified
      Returns:
      the query
    • orderByModified

      public TaskQuery orderByModified(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the modified timestamp.
      Specified by:
      orderByModified in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • plannedWithin

      public TaskQuery plannedWithin(io.kadai.common.api.TimeInterval... intervals)
      Description copied from interface: TaskQuery
      Add the time intervals within which the task is planned to your query. For each time interval, the database query will search for tasks whose planned timestamp is after or at the interval's begin and before or at the interval's end. If more than one interval is specified, the query will connect them with the OR keyword. If either begin or end of an interval are null, these values will not be specified in the query.
      Specified by:
      plannedWithin in interface TaskQuery
      Parameters:
      intervals - - the TimeIntervals within which the task is planned
      Returns:
      the query
    • plannedNotWithin

      public TaskQuery plannedNotWithin(io.kadai.common.api.TimeInterval... intervals)
      Description copied from interface: TaskQuery
      Exclude the time intervals within which the task isn't planned from your query. For each time interval, the database query will search for tasks whose planned timestamp is before the interval's begin and after the interval's end. If more than one interval is specified, the query will connect them with the OR keyword. If either begin or end of an interval are null, these values will not be specified in the query.
      Specified by:
      plannedNotWithin in interface TaskQuery
      Parameters:
      intervals - - the TimeIntervals within which the task isn't planned
      Returns:
      the query
    • orderByPlanned

      public TaskQuery orderByPlanned(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the planned timestamp.
      Specified by:
      orderByPlanned in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • dueWithin

      public TaskQuery dueWithin(io.kadai.common.api.TimeInterval... intervals)
      Description copied from interface: TaskQuery
      Add the time intervals within which the task is due to your query. For each time interval, the database query will search for tasks whose due timestamp is after or at the interval's begin and before or at the interval's end. If more than one interval is specified, the query will connect them with the OR keyword. If either begin or end of an interval are null, these values will not be specified in the query.
      Specified by:
      dueWithin in interface TaskQuery
      Parameters:
      intervals - - the TimeIntervals within which the task is due
      Returns:
      the query
    • dueNotWithin

      public TaskQuery dueNotWithin(io.kadai.common.api.TimeInterval... intervals)
      Description copied from interface: TaskQuery
      Exclude the time intervals within which the task isn't due from your query. For each time interval, the database query will search for tasks whose due timestamp is before the interval's begin and after the interval's end. If more than one interval is specified, the query will connect them with the OR keyword. If either begin or end of an interval are null, these values will not be specified in the query.
      Specified by:
      dueNotWithin in interface TaskQuery
      Parameters:
      intervals - - the TimeIntervals within which the task isn't due
      Returns:
      the query
    • orderByDue

      public TaskQuery orderByDue(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the due timestamp.
      Specified by:
      orderByDue in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • completedWithin

      public TaskQuery completedWithin(io.kadai.common.api.TimeInterval... intervals)
      Description copied from interface: TaskQuery
      Add the time intervals within which the task was completed to your query. For each time interval, the database query will search for tasks whose completed timestamp is before the interval's begin and after the interval's end. If more than one interval is specified, the query will connect them with the OR keyword. If either begin or end of an interval are null, these values will not be specified in the query.
      Specified by:
      completedWithin in interface TaskQuery
      Parameters:
      intervals - - the TimeIntervals within which the task was completed
      Returns:
      the query
    • completedNotWithin

      public TaskQuery completedNotWithin(io.kadai.common.api.TimeInterval... intervals)
      Description copied from interface: TaskQuery
      Exclude the time intervals within which the task wasn't completed from your query. For each time interval, the database query will search for tasks whose completed timestamp is before the interval's begin and after the interval's end. If more than one interval is specified, the query will connect them with the OR keyword. If either begin or end of an interval are null, these values will not be specified in the query.
      Specified by:
      completedNotWithin in interface TaskQuery
      Parameters:
      intervals - - the TimeIntervals within which the task wasn't completed
      Returns:
      the query
    • orderByCompleted

      public TaskQuery orderByCompleted(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the completed timestamp.
      Specified by:
      orderByCompleted in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • nameIn

      public TaskQuery nameIn(String... names)
      Description copied from interface: TaskQuery
      Add your names to your query.
      Specified by:
      nameIn in interface TaskQuery
      Parameters:
      names - the names as Strings
      Returns:
      the query
    • nameNotIn

      public TaskQuery nameNotIn(String... names)
      Description copied from interface: TaskQuery
      Exclude these names from your query.
      Specified by:
      nameNotIn in interface TaskQuery
      Parameters:
      names - the names as Strings
      Returns:
      the query
    • nameLike

      public TaskQuery nameLike(String... names)
      Description copied from interface: TaskQuery
      Add your name for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      nameLike in interface TaskQuery
      Parameters:
      names - your names
      Returns:
      the query
    • nameNotLike

      public TaskQuery nameNotLike(String... names)
      Description copied from interface: TaskQuery
      Exclude these names for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      nameNotLike in interface TaskQuery
      Parameters:
      names - your names
      Returns:
      the query
    • orderByName

      public TaskQuery orderByName(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to name.
      Specified by:
      orderByName in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • creatorIn

      public TaskQuery creatorIn(String... creators)
      Description copied from interface: TaskQuery
      Add the UserIds of the creator to your query.
      Specified by:
      creatorIn in interface TaskQuery
      Parameters:
      creators - of the queried tasks
      Returns:
      the query
    • creatorNotIn

      public TaskQuery creatorNotIn(String... creators)
      Description copied from interface: TaskQuery
      Exclude the UserIds of the creator from your query.
      Specified by:
      creatorNotIn in interface TaskQuery
      Parameters:
      creators - of the queried tasks
      Returns:
      the query
    • creatorLike

      public TaskQuery creatorLike(String... creators)
      Description copied from interface: TaskQuery
      Add the UserIds of the creator for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      creatorLike in interface TaskQuery
      Parameters:
      creators - of the queried tasks
      Returns:
      the query
    • creatorNotLike

      public TaskQuery creatorNotLike(String... creators)
      Description copied from interface: TaskQuery
      Exclude the UserIds of the creator for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      creatorNotLike in interface TaskQuery
      Parameters:
      creators - of the queried tasks
      Returns:
      the query
    • orderByCreator

      public TaskQuery orderByCreator(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to creators name.
      Specified by:
      orderByCreator in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • noteLike

      public TaskQuery noteLike(String... notes)
      Description copied from interface: TaskQuery
      Add your custom note for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      noteLike in interface TaskQuery
      Parameters:
      notes - your custom notes
      Returns:
      the query
    • noteNotLike

      public TaskQuery noteNotLike(String... notes)
      Description copied from interface: TaskQuery
      Exclude your custom note for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      noteNotLike in interface TaskQuery
      Parameters:
      notes - your custom notes
      Returns:
      the query
    • orderByNote

      public TaskQuery orderByNote(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the note.
      Specified by:
      orderByNote in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • descriptionLike

      public TaskQuery descriptionLike(String... descriptions)
      Description copied from interface: TaskQuery
      Add your description for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      descriptionLike in interface TaskQuery
      Parameters:
      descriptions - your descriptions
      Returns:
      the query
    • descriptionNotLike

      public TaskQuery descriptionNotLike(String... descriptions)
      Description copied from interface: TaskQuery
      Exclude your description for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      descriptionNotLike in interface TaskQuery
      Parameters:
      descriptions - your descriptions
      Returns:
      the query
    • priorityIn

      public TaskQuery priorityIn(int... priorities)
      Description copied from interface: TaskQuery
      Add your priorities to your query.
      Specified by:
      priorityIn in interface TaskQuery
      Parameters:
      priorities - as a integer
      Returns:
      the query
    • priorityNotIn

      public TaskQuery priorityNotIn(int... priorities)
      Description copied from interface: TaskQuery
      Exclude the priorities from your query.
      Specified by:
      priorityNotIn in interface TaskQuery
      Parameters:
      priorities - as a integer
      Returns:
      the query
    • priorityWithin

      public TaskQuery priorityWithin(io.kadai.common.api.IntInterval... priorities)
      Description copied from interface: TaskQuery
      Includes the priorities in the provided range (inclusive) to your query (eg. priorities = [1,3] includes 1,2,3).
      Specified by:
      priorityWithin in interface TaskQuery
      Parameters:
      priorities - as an integer intervals
      Returns:
      the query
    • priorityNotWithin

      public TaskQuery priorityNotWithin(io.kadai.common.api.IntInterval... priorities)
      Description copied from interface: TaskQuery
      Excludes the priorities in the provided range (inclusive) to your query (eg. priorities = [1,3] excludes 1,2,3).
      Specified by:
      priorityNotWithin in interface TaskQuery
      Parameters:
      priorities - as an integer intervals
      Returns:
      the query
    • orderByPriority

      public TaskQuery orderByPriority(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the priority.
      Specified by:
      orderByPriority in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • stateIn

      public TaskQuery stateIn(TaskState... states)
      Description copied from interface: TaskQuery
      Add your state to your query.
      Specified by:
      stateIn in interface TaskQuery
      Parameters:
      states - the states as TaskState
      Returns:
      the query
    • stateNotIn

      public TaskQuery stateNotIn(TaskState... states)
      Description copied from interface: TaskQuery
      Exclude these states from your query.
      Specified by:
      stateNotIn in interface TaskQuery
      Parameters:
      states - the states as TaskState
      Returns:
      the query
    • orderByState

      public TaskQuery orderByState(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the state.
      Specified by:
      orderByState in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • hasComments

      public TaskQuery hasComments(Boolean hasComments)
      Description copied from interface: TaskQuery
      Add the hasComments flag to the query.
      Specified by:
      hasComments in interface TaskQuery
      Parameters:
      hasComments - as Boolean. If null, it won't be integrated into the statement. It will only be integrated into the statement if set to true or false
      Returns:
      the query
    • classificationIdIn

      public TaskQuery classificationIdIn(String... classificationIds)
      Description copied from interface: TaskQuery
      Add your classificationId to your query.
      Specified by:
      classificationIdIn in interface TaskQuery
      Parameters:
      classificationIds - the classification Ids
      Returns:
      the query
    • classificationIdNotIn

      public TaskQuery classificationIdNotIn(String... classificationIds)
      Description copied from interface: TaskQuery
      Exclude these classificationIds from your query.
      Specified by:
      classificationIdNotIn in interface TaskQuery
      Parameters:
      classificationIds - the classification Ids
      Returns:
      the query
    • classificationKeyIn

      public TaskQuery classificationKeyIn(String... classificationKeys)
      Description copied from interface: TaskQuery
      Add your classificationKey to your query.
      Specified by:
      classificationKeyIn in interface TaskQuery
      Parameters:
      classificationKeys - the classification key
      Returns:
      the query
    • classificationKeyNotIn

      public TaskQuery classificationKeyNotIn(String... classificationKeys)
      Description copied from interface: TaskQuery
      Exclude these classificationKeys from your query.
      Specified by:
      classificationKeyNotIn in interface TaskQuery
      Parameters:
      classificationKeys - the classification key
      Returns:
      the query
    • classificationKeyLike

      public TaskQuery classificationKeyLike(String... classificationKeys)
      Description copied from interface: TaskQuery
      Add your classificationKey for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      classificationKeyLike in interface TaskQuery
      Parameters:
      classificationKeys - the classification key
      Returns:
      the query
    • classificationKeyNotLike

      public TaskQuery classificationKeyNotLike(String... classificationKeys)
      Description copied from interface: TaskQuery
      Exclude the classificationKeys for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      classificationKeyNotLike in interface TaskQuery
      Parameters:
      classificationKeys - the classification key
      Returns:
      the query
    • orderByClassificationKey

      public TaskQuery orderByClassificationKey(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the classification key.
      Specified by:
      orderByClassificationKey in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • classificationParentKeyIn

      public TaskQuery classificationParentKeyIn(String... classificationParentKeys)
      Description copied from interface: TaskQuery
      Add these keys of the parent Classification to your query.
      Specified by:
      classificationParentKeyIn in interface TaskQuery
      Parameters:
      classificationParentKeys - the classification parent keys
      Returns:
      the query
    • classificationParentKeyNotIn

      public TaskQuery classificationParentKeyNotIn(String... classificationParentKeys)
      Description copied from interface: TaskQuery
      Exclude these keys of the parent Classification from your query.
      Specified by:
      classificationParentKeyNotIn in interface TaskQuery
      Parameters:
      classificationParentKeys - the keys of the parent Classifications
      Returns:
      the query
    • classificationParentKeyLike

      public TaskQuery classificationParentKeyLike(String... classificationParentKeys)
      Description copied from interface: TaskQuery
      Add these keys of the parent Classification for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      classificationParentKeyLike in interface TaskQuery
      Parameters:
      classificationParentKeys - the keys of the parent Classification
      Returns:
      the query
    • classificationParentKeyNotLike

      public TaskQuery classificationParentKeyNotLike(String... classificationParentKeys)
      Description copied from interface: TaskQuery
      Exclude these keys of the parent Classification for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      classificationParentKeyNotLike in interface TaskQuery
      Parameters:
      classificationParentKeys - the keys of the parent Classification
      Returns:
      the query
    • classificationCategoryIn

      public TaskQuery classificationCategoryIn(String... classificationCategories)
      Description copied from interface: TaskQuery
      Add your classificationCategory to your query.
      Specified by:
      classificationCategoryIn in interface TaskQuery
      Parameters:
      classificationCategories - the classification category for filtering
      Returns:
      the query
    • classificationCategoryNotIn

      public TaskQuery classificationCategoryNotIn(String... classificationCategories)
      Description copied from interface: TaskQuery
      Exclude the classificationCategory from your query.
      Specified by:
      classificationCategoryNotIn in interface TaskQuery
      Parameters:
      classificationCategories - the classification category for filtering
      Returns:
      the query
    • classificationCategoryLike

      public TaskQuery classificationCategoryLike(String... classificationCategories)
      Description copied from interface: TaskQuery
      Add your classificationCategory for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      classificationCategoryLike in interface TaskQuery
      Parameters:
      classificationCategories - the classification categories for filtering
      Returns:
      the query
    • classificationCategoryNotLike

      public TaskQuery classificationCategoryNotLike(String... classificationCategories)
      Description copied from interface: TaskQuery
      Exclude the classificationCategory for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      classificationCategoryNotLike in interface TaskQuery
      Parameters:
      classificationCategories - the classification categories for filtering
      Returns:
      the query
    • classificationNameIn

      public TaskQuery classificationNameIn(String... classificationNames)
      Description copied from interface: TaskQuery
      Add your classificationName to your query.
      Specified by:
      classificationNameIn in interface TaskQuery
      Parameters:
      classificationNames - the classification name
      Returns:
      the query
    • classificationNameNotIn

      public TaskQuery classificationNameNotIn(String... classificationNames)
      Description copied from interface: TaskQuery
      Exclude the classificationName from your query.
      Specified by:
      classificationNameNotIn in interface TaskQuery
      Parameters:
      classificationNames - the classification name
      Returns:
      the query
    • classificationNameLike

      public TaskQuery classificationNameLike(String... classificationNames)
      Description copied from interface: TaskQuery
      Add your classificationName for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword. *
      Specified by:
      classificationNameLike in interface TaskQuery
      Parameters:
      classificationNames - the classification name
      Returns:
      the query
    • classificationNameNotLike

      public TaskQuery classificationNameNotLike(String... classificationNames)
      Description copied from interface: TaskQuery
      Exclude the classificationName for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword. *
      Specified by:
      classificationNameNotLike in interface TaskQuery
      Parameters:
      classificationNames - the classification name
      Returns:
      the query
    • orderByClassificationName

      public TaskQuery orderByClassificationName(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the classification name.
      Specified by:
      orderByClassificationName in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • workbasketIdIn

      public TaskQuery workbasketIdIn(String... workbasketIds)
      Description copied from interface: TaskQuery
      Add your workbasket id to the query.
      Specified by:
      workbasketIdIn in interface TaskQuery
      Parameters:
      workbasketIds - the ids of workbaskets
      Returns:
      the query
    • workbasketIdNotIn

      public TaskQuery workbasketIdNotIn(String... workbasketIds)
      Description copied from interface: TaskQuery
      Exclude the workbasket id from the query.
      Specified by:
      workbasketIdNotIn in interface TaskQuery
      Parameters:
      workbasketIds - the ids of workbaskets
      Returns:
      the query
    • orderByWorkbasketId

      public TaskQuery orderByWorkbasketId(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the workbasket-Id of the tasks.
      Specified by:
      orderByWorkbasketId in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • workbasketKeyDomainIn

      public TaskQuery workbasketKeyDomainIn(io.kadai.common.api.KeyDomain... workbasketIdentifiers)
      Description copied from interface: TaskQuery
      Add your workbasket key to the query.
      Specified by:
      workbasketKeyDomainIn in interface TaskQuery
      Parameters:
      workbasketIdentifiers - the key - domain combinations that identify workbaskets
      Returns:
      the query
    • workbasketKeyDomainNotIn

      public TaskQuery workbasketKeyDomainNotIn(io.kadai.common.api.KeyDomain... workbasketIdentifiers)
      Description copied from interface: TaskQuery
      Exclude the workbasket key from the query.
      Specified by:
      workbasketKeyDomainNotIn in interface TaskQuery
      Parameters:
      workbasketIdentifiers - the key - domain combinations that identify workbaskets
      Returns:
      the query
    • businessProcessIdIn

      public TaskQuery businessProcessIdIn(String... businessProcessIds)
      Description copied from interface: TaskQuery
      Add the business process ids for exact matching to your query.
      Specified by:
      businessProcessIdIn in interface TaskQuery
      Parameters:
      businessProcessIds - the businessProcessIds of the searched for tasks
      Returns:
      the query
    • businessProcessIdNotIn

      public TaskQuery businessProcessIdNotIn(String... businessProcessIds)
      Description copied from interface: TaskQuery
      Exclude the business process ids for exact matching from your query.
      Specified by:
      businessProcessIdNotIn in interface TaskQuery
      Parameters:
      businessProcessIds - the businessProcessIds of the searched for tasks
      Returns:
      the query
    • businessProcessIdLike

      public TaskQuery businessProcessIdLike(String... businessProcessIds)
      Description copied from interface: TaskQuery
      Add your businessProcessId for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword. *
      Specified by:
      businessProcessIdLike in interface TaskQuery
      Parameters:
      businessProcessIds - the classification name
      Returns:
      the query
    • businessProcessIdNotLike

      public TaskQuery businessProcessIdNotLike(String... businessProcessIds)
      Description copied from interface: TaskQuery
      Exclude your businessProcessId for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword. *
      Specified by:
      businessProcessIdNotLike in interface TaskQuery
      Parameters:
      businessProcessIds - the classification name
      Returns:
      the query
    • orderByBusinessProcessId

      public TaskQuery orderByBusinessProcessId(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the business process id.
      Specified by:
      orderByBusinessProcessId in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • parentBusinessProcessIdIn

      public TaskQuery parentBusinessProcessIdIn(String... parentBusinessProcessIds)
      Description copied from interface: TaskQuery
      Add the parent business process ids for exact matching to your query.
      Specified by:
      parentBusinessProcessIdIn in interface TaskQuery
      Parameters:
      parentBusinessProcessIds - the parent businessProcessIds of the searched for tasks
      Returns:
      the query
    • parentBusinessProcessIdNotIn

      public TaskQuery parentBusinessProcessIdNotIn(String... parentBusinessProcessIds)
      Description copied from interface: TaskQuery
      Exclude the parent business process ids for exact matching from your query.
      Specified by:
      parentBusinessProcessIdNotIn in interface TaskQuery
      Parameters:
      parentBusinessProcessIds - the parent businessProcessIds of the searched for tasks
      Returns:
      the query
    • parentBusinessProcessIdLike

      public TaskQuery parentBusinessProcessIdLike(String... businessProcessIds)
      Description copied from interface: TaskQuery
      Add your parent business process id for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword. *
      Specified by:
      parentBusinessProcessIdLike in interface TaskQuery
      Parameters:
      businessProcessIds - the classification name
      Returns:
      the query
    • parentBusinessProcessIdNotLike

      public TaskQuery parentBusinessProcessIdNotLike(String... businessProcessIds)
      Description copied from interface: TaskQuery
      Exclude your parent business process id for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword. *
      Specified by:
      parentBusinessProcessIdNotLike in interface TaskQuery
      Parameters:
      businessProcessIds - the classification name
      Returns:
      the query
    • orderByParentBusinessProcessId

      public TaskQuery orderByParentBusinessProcessId(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the parent business process id.
      Specified by:
      orderByParentBusinessProcessId in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • ownerIn

      public TaskQuery ownerIn(String... owners)
      Description copied from interface: TaskQuery
      Add the owners to your query.
      Specified by:
      ownerIn in interface TaskQuery
      Parameters:
      owners - the owners as String
      Returns:
      the query
    • ownerNotIn

      public TaskQuery ownerNotIn(String... owners)
      Description copied from interface: TaskQuery
      Filter out owners.
      Specified by:
      ownerNotIn in interface TaskQuery
      Parameters:
      owners - the owners as String
      Returns:
      the query
    • ownerLike

      public TaskQuery ownerLike(String... owners)
      Description copied from interface: TaskQuery
      Add the owner for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern.

      If you specify multiple arguments they are combined with the OR keyword.

      Specified by:
      ownerLike in interface TaskQuery
      Parameters:
      owners - the owners of the searched tasks
      Returns:
      the query
    • ownerNotLike

      public TaskQuery ownerNotLike(String... owners)
      Description copied from interface: TaskQuery
      Exclude the owner for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern.

      If you specify multiple arguments they are combined with the OR keyword.

      Specified by:
      ownerNotLike in interface TaskQuery
      Parameters:
      owners - the owners of the searched tasks
      Returns:
      the query
    • orderByOwner

      public TaskQuery orderByOwner(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the owner.
      Specified by:
      orderByOwner in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • ownerLongNameIn

      public TaskQuery ownerLongNameIn(String... longNames)
      Description copied from interface: TaskQuery
      Adds the long names of the owners to your query.
      Specified by:
      ownerLongNameIn in interface TaskQuery
      Parameters:
      longNames - the long names as String
      Returns:
      the query
    • ownerLongNameNotIn

      public TaskQuery ownerLongNameNotIn(String... longNames)
      Description copied from interface: TaskQuery
      Adds the long names of the owners to your query, which should not be contained.
      Specified by:
      ownerLongNameNotIn in interface TaskQuery
      Parameters:
      longNames - the long names as String
      Returns:
      the query
    • ownerLongNameLike

      public TaskQuery ownerLongNameLike(String... longNames)
      Description copied from interface: TaskQuery
      Adds the long names of the owner for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern.

      If you specify multiple arguments they are combined with the OR keyword.

      Specified by:
      ownerLongNameLike in interface TaskQuery
      Parameters:
      longNames - the owners of the searched tasks
      Returns:
      the query
    • ownerLongNameNotLike

      public TaskQuery ownerLongNameNotLike(String... longNames)
      Description copied from interface: TaskQuery
      Adds the long names of the owner for pattern matching to your query, which should not be contained. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern.

      If you specify multiple arguments they are combined with the OR keyword.

      Specified by:
      ownerLongNameNotLike in interface TaskQuery
      Parameters:
      longNames - the owners of the searched tasks
      Returns:
      the query
    • primaryObjectReferenceIn

      public TaskQuery primaryObjectReferenceIn(ObjectReference... objectReferences)
      Description copied from interface: TaskQuery
      Add the ObjectReference to exact match to your query. Each individual value has to match. Fields with the value 'null' will be ignored. The id of each ObjectReference will be ignored

      If you specify multiple arguments they are combined with the OR keyword.

      Specified by:
      primaryObjectReferenceIn in interface TaskQuery
      Parameters:
      objectReferences - the combined values which are searched together.
      Returns:
      the query
    • primaryObjectReferenceCompanyIn

      public TaskQuery primaryObjectReferenceCompanyIn(String... companies)
      Description copied from interface: TaskQuery
      Add the companies of the primary object reference for exact matching to your query.
      Specified by:
      primaryObjectReferenceCompanyIn in interface TaskQuery
      Parameters:
      companies - the companies of your primary object reference
      Returns:
      the query
    • primaryObjectReferenceCompanyNotIn

      public TaskQuery primaryObjectReferenceCompanyNotIn(String... companies)
      Description copied from interface: TaskQuery
      Exclude the companies of the primary object reference for exact matching from your query.
      Specified by:
      primaryObjectReferenceCompanyNotIn in interface TaskQuery
      Parameters:
      companies - the companies of your primary object reference
      Returns:
      the query
    • primaryObjectReferenceCompanyLike

      public TaskQuery primaryObjectReferenceCompanyLike(String... companies)
      Description copied from interface: TaskQuery
      Add the company of the primary object reference for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      primaryObjectReferenceCompanyLike in interface TaskQuery
      Parameters:
      companies - the companies of your primary object reference
      Returns:
      the query
    • primaryObjectReferenceCompanyNotLike

      public TaskQuery primaryObjectReferenceCompanyNotLike(String... companies)
      Description copied from interface: TaskQuery
      Exclude the company of the primary object reference for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      primaryObjectReferenceCompanyNotLike in interface TaskQuery
      Parameters:
      companies - the companies of your primary object reference
      Returns:
      the query
    • orderByPrimaryObjectReferenceCompany

      public TaskQuery orderByPrimaryObjectReferenceCompany(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the company of the primary object reference.
      Specified by:
      orderByPrimaryObjectReferenceCompany in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • primaryObjectReferenceSystemIn

      public TaskQuery primaryObjectReferenceSystemIn(String... systems)
      Description copied from interface: TaskQuery
      Add the systems of the primary object reference for exact matching to your query.
      Specified by:
      primaryObjectReferenceSystemIn in interface TaskQuery
      Parameters:
      systems - the systems of your primary object reference
      Returns:
      the query
    • primaryObjectReferenceSystemNotIn

      public TaskQuery primaryObjectReferenceSystemNotIn(String... systems)
      Description copied from interface: TaskQuery
      Exclude the systems of the primary object reference for exact matching from your query.
      Specified by:
      primaryObjectReferenceSystemNotIn in interface TaskQuery
      Parameters:
      systems - the systems of your primary object reference
      Returns:
      the query
    • primaryObjectReferenceSystemLike

      public TaskQuery primaryObjectReferenceSystemLike(String... systems)
      Description copied from interface: TaskQuery
      Add the system of the primary object reference for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      primaryObjectReferenceSystemLike in interface TaskQuery
      Parameters:
      systems - the system of your primary object reference
      Returns:
      the query
    • primaryObjectReferenceSystemNotLike

      public TaskQuery primaryObjectReferenceSystemNotLike(String... systems)
      Description copied from interface: TaskQuery
      Exclude the system of the primary object reference for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      primaryObjectReferenceSystemNotLike in interface TaskQuery
      Parameters:
      systems - the system of your primary object reference
      Returns:
      the query
    • orderByPrimaryObjectReferenceSystem

      public TaskQuery orderByPrimaryObjectReferenceSystem(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the system of the primary object reference.
      Specified by:
      orderByPrimaryObjectReferenceSystem in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • primaryObjectReferenceSystemInstanceIn

      public TaskQuery primaryObjectReferenceSystemInstanceIn(String... systemInstances)
      Description copied from interface: TaskQuery
      Add the system instances of the primary object reference for exact matching to your query.
      Specified by:
      primaryObjectReferenceSystemInstanceIn in interface TaskQuery
      Parameters:
      systemInstances - the system instances of your primary object reference
      Returns:
      the query
    • primaryObjectReferenceSystemInstanceNotIn

      public TaskQuery primaryObjectReferenceSystemInstanceNotIn(String... systemInstances)
      Description copied from interface: TaskQuery
      Exclude the system instances of the primary object reference for exact matching from your query.
      Specified by:
      primaryObjectReferenceSystemInstanceNotIn in interface TaskQuery
      Parameters:
      systemInstances - the system instances of your primary object reference
      Returns:
      the query
    • primaryObjectReferenceSystemInstanceLike

      public TaskQuery primaryObjectReferenceSystemInstanceLike(String... systemInstances)
      Description copied from interface: TaskQuery
      Add the system instance of the primary object reference for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      primaryObjectReferenceSystemInstanceLike in interface TaskQuery
      Parameters:
      systemInstances - the system instances of your primary object reference
      Returns:
      the query
    • primaryObjectReferenceSystemInstanceNotLike

      public TaskQuery primaryObjectReferenceSystemInstanceNotLike(String... systemInstances)
      Description copied from interface: TaskQuery
      Exclude the system instance of the primary object reference for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      primaryObjectReferenceSystemInstanceNotLike in interface TaskQuery
      Parameters:
      systemInstances - the system instances of your primary object reference
      Returns:
      the query
    • orderByPrimaryObjectReferenceSystemInstance

      public TaskQuery orderByPrimaryObjectReferenceSystemInstance(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the system instance of the primary object reference.
      Specified by:
      orderByPrimaryObjectReferenceSystemInstance in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • primaryObjectReferenceTypeIn

      public TaskQuery primaryObjectReferenceTypeIn(String... types)
      Description copied from interface: TaskQuery
      Add the types of the primary object reference for exact matching to your query.
      Specified by:
      primaryObjectReferenceTypeIn in interface TaskQuery
      Parameters:
      types - the types your primary object reference
      Returns:
      the query
    • primaryObjectReferenceTypeNotIn

      public TaskQuery primaryObjectReferenceTypeNotIn(String... types)
      Description copied from interface: TaskQuery
      Exclude the types of the primary object reference for exact matching from your query.
      Specified by:
      primaryObjectReferenceTypeNotIn in interface TaskQuery
      Parameters:
      types - the types your primary object reference
      Returns:
      the query
    • primaryObjectReferenceTypeLike

      public TaskQuery primaryObjectReferenceTypeLike(String... types)
      Description copied from interface: TaskQuery
      Add the type of the primary object reference for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      primaryObjectReferenceTypeLike in interface TaskQuery
      Parameters:
      types - the types of your primary object reference
      Returns:
      the query
    • primaryObjectReferenceTypeNotLike

      public TaskQuery primaryObjectReferenceTypeNotLike(String... types)
      Description copied from interface: TaskQuery
      Exclude the type of the primary object reference for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      primaryObjectReferenceTypeNotLike in interface TaskQuery
      Parameters:
      types - the types of your primary object reference
      Returns:
      the query
    • orderByPrimaryObjectReferenceType

      public TaskQuery orderByPrimaryObjectReferenceType(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the type of the primary object reference.
      Specified by:
      orderByPrimaryObjectReferenceType in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • primaryObjectReferenceValueIn

      public TaskQuery primaryObjectReferenceValueIn(String... values)
      Description copied from interface: TaskQuery
      Add the values of the primary object reference for exact matching to your query.
      Specified by:
      primaryObjectReferenceValueIn in interface TaskQuery
      Parameters:
      values - the values of your primary object reference
      Returns:
      the query
    • primaryObjectReferenceValueNotIn

      public TaskQuery primaryObjectReferenceValueNotIn(String... values)
      Description copied from interface: TaskQuery
      Exclude the values of the primary object reference for exact matching from your query.
      Specified by:
      primaryObjectReferenceValueNotIn in interface TaskQuery
      Parameters:
      values - the values of your primary object reference
      Returns:
      the query
    • primaryObjectReferenceValueLike

      public TaskQuery primaryObjectReferenceValueLike(String... values)
      Description copied from interface: TaskQuery
      Add the value of the primary object reference for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      primaryObjectReferenceValueLike in interface TaskQuery
      Parameters:
      values - the values of your primary object reference
      Returns:
      the query
    • primaryObjectReferenceValueNotLike

      public TaskQuery primaryObjectReferenceValueNotLike(String... values)
      Description copied from interface: TaskQuery
      Exclude the value of the primary object reference for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      primaryObjectReferenceValueNotLike in interface TaskQuery
      Parameters:
      values - the values of your primary object reference
      Returns:
      the query
    • orderByPrimaryObjectReferenceValue

      public TaskQuery orderByPrimaryObjectReferenceValue(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the value of the primary object reference.
      Specified by:
      orderByPrimaryObjectReferenceValue in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • groupByPor

      public TaskQuery groupByPor()
      Description copied from interface: TaskQuery
      Group the Tasks that will be returned by this query according to the value of their primary ObjectReference. Only one Task will be returned for all Tasks with the same value.
      Specified by:
      groupByPor in interface TaskQuery
      Returns:
      the query
    • groupBySor

      public TaskQuery groupBySor(String type)
      Description copied from interface: TaskQuery
      Group the Tasks that will be returned by this query according to the value of their secondary ObjectReference with the specified type. Only one Task will be returned for all Tasks with the same value.
      Specified by:
      groupBySor in interface TaskQuery
      Parameters:
      type - the type of the relevant secondary ObjectReference
      Returns:
      the query
    • readEquals

      public TaskQuery readEquals(Boolean isRead)
      Description copied from interface: TaskQuery
      Add the isRead flag to the query.
      Specified by:
      readEquals in interface TaskQuery
      Parameters:
      isRead - as Boolean. If null, it won't be integrated into the statement. It will only be integrated into the statement if set to true or false
      Returns:
      the query
    • transferredEquals

      public TaskQuery transferredEquals(Boolean isTransferred)
      Description copied from interface: TaskQuery
      Add the isTransferred flag to the query.
      Specified by:
      transferredEquals in interface TaskQuery
      Parameters:
      isTransferred - as Boolean. If null, it won't be integrated into the statement. It will only be integrated into the statement if set to true or false
      Returns:
      the query
    • attachmentClassificationIdIn

      public TaskQuery attachmentClassificationIdIn(String... attachmentClassificationIds)
      Description copied from interface: TaskQuery
      Add the attachment classification Ids for exact matching to your query.
      Specified by:
      attachmentClassificationIdIn in interface TaskQuery
      Parameters:
      attachmentClassificationIds - the attachmentClassificationId values of the searched for tasks
      Returns:
      the query
    • attachmentClassificationIdNotIn

      public TaskQuery attachmentClassificationIdNotIn(String... attachmentClassificationIds)
      Description copied from interface: TaskQuery
      Exclude the attachment classification Ids for exact matching from your query.
      Specified by:
      attachmentClassificationIdNotIn in interface TaskQuery
      Parameters:
      attachmentClassificationIds - the attachmentClassificationId values of the searched for tasks
      Returns:
      the query
    • orderByAttachmentClassificationId

      public TaskQuery orderByAttachmentClassificationId(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the attachment classification id. (Should only be used if there is one attachment per task in other case the result would be wrong.)
      Specified by:
      orderByAttachmentClassificationId in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • attachmentClassificationKeyIn

      public TaskQuery attachmentClassificationKeyIn(String... attachmentClassificationKeys)
      Description copied from interface: TaskQuery
      Add the attachment classification keys for exact matching to your query.
      Specified by:
      attachmentClassificationKeyIn in interface TaskQuery
      Parameters:
      attachmentClassificationKeys - the attachmentClassificationKeys values of the searched for tasks
      Returns:
      the query
    • attachmentClassificationKeyNotIn

      public TaskQuery attachmentClassificationKeyNotIn(String... attachmentClassificationKeys)
      Description copied from interface: TaskQuery
      Exclude the attachment classification keys for exact matching from your query.
      Specified by:
      attachmentClassificationKeyNotIn in interface TaskQuery
      Parameters:
      attachmentClassificationKeys - the attachmentClassificationKeys values of the searched for tasks
      Returns:
      the query
    • attachmentClassificationKeyLike

      public TaskQuery attachmentClassificationKeyLike(String... attachmentClassificationKeys)
      Description copied from interface: TaskQuery
      Add the attachment classification Keys for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      attachmentClassificationKeyLike in interface TaskQuery
      Parameters:
      attachmentClassificationKeys - the attachmentClassificationKey values of the searched for tasks
      Returns:
      the query
    • attachmentClassificationKeyNotLike

      public TaskQuery attachmentClassificationKeyNotLike(String... attachmentClassificationKeys)
      Description copied from interface: TaskQuery
      Exclude the attachment classification Keys for pattern matching from your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      attachmentClassificationKeyNotLike in interface TaskQuery
      Parameters:
      attachmentClassificationKeys - the attachmentClassificationKey values of the searched for tasks
      Returns:
      the query
    • orderByAttachmentClassificationKey

      public TaskQuery orderByAttachmentClassificationKey(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the attachment classification key. (Should only be used if there is one attachment per task in other case the result would be wrong.)
      Specified by:
      orderByAttachmentClassificationKey in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • attachmentClassificationNameIn

      public TaskQuery attachmentClassificationNameIn(String... attachmentClassificationNames)
      Description copied from interface: TaskQuery
      Add the attachment classification names for exact matching to your query.
      Specified by:
      attachmentClassificationNameIn in interface TaskQuery
      Parameters:
      attachmentClassificationNames - the attachmentClassificationName values of the searched for tasks
      Returns:
      the query
    • attachmentClassificationNameNotIn

      public TaskQuery attachmentClassificationNameNotIn(String... attachmentClassificationNames)
      Description copied from interface: TaskQuery
      Exclude the attachment classification names for exact matching from your query.
      Specified by:
      attachmentClassificationNameNotIn in interface TaskQuery
      Parameters:
      attachmentClassificationNames - the attachmentClassificationName values of the searched for tasks
      Returns:
      the query
    • attachmentClassificationNameLike

      public TaskQuery attachmentClassificationNameLike(String... attachmentClassificationNames)
      Description copied from interface: TaskQuery
      Add the values of attachment classification names for pattern matching to your query. They will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      attachmentClassificationNameLike in interface TaskQuery
      Parameters:
      attachmentClassificationNames - the attachmentClassificationName values of the searched-for tasks
      Returns:
      the query
    • attachmentClassificationNameNotLike

      public TaskQuery attachmentClassificationNameNotLike(String... attachmentClassificationNames)
      Description copied from interface: TaskQuery
      Exclude the values of attachment classification names for pattern matching from your query. They will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      attachmentClassificationNameNotLike in interface TaskQuery
      Parameters:
      attachmentClassificationNames - the attachmentClassificationName values of the searched-for tasks
      Returns:
      the query
    • orderByAttachmentClassificationName

      public TaskQuery orderByAttachmentClassificationName(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the attachment classification name. (Should only be used if there is one attachment per task in other case the result would be wrong.)
      Specified by:
      orderByAttachmentClassificationName in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • attachmentChannelIn

      public TaskQuery attachmentChannelIn(String... attachmentChannels)
      Description copied from interface: TaskQuery
      Add the values of attachment channel for exact matching to your query.
      Specified by:
      attachmentChannelIn in interface TaskQuery
      Parameters:
      attachmentChannels - the attachmentChannel values of the searched for tasks
      Returns:
      the query
    • attachmentChannelNotIn

      public TaskQuery attachmentChannelNotIn(String... attachmentChannels)
      Description copied from interface: TaskQuery
      Exclude the values of attachment channel for exact matching from your query.
      Specified by:
      attachmentChannelNotIn in interface TaskQuery
      Parameters:
      attachmentChannels - the attachmentChannel values of the searched for tasks
      Returns:
      the query
    • attachmentChannelLike

      public TaskQuery attachmentChannelLike(String... attachmentChannels)
      Description copied from interface: TaskQuery
      Add the values of attachment channel for pattern matching to your query. They will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      attachmentChannelLike in interface TaskQuery
      Parameters:
      attachmentChannels - the attachmentChannel values of the searched-for tasks
      Returns:
      the query
    • attachmentChannelNotLike

      public TaskQuery attachmentChannelNotLike(String... attachmentChannels)
      Description copied from interface: TaskQuery
      Exclude the values of attachment channel for pattern matching from your query. They will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      attachmentChannelNotLike in interface TaskQuery
      Parameters:
      attachmentChannels - the attachmentChannel values of the searched-for tasks
      Returns:
      the query
    • orderByAttachmentChannel

      public TaskQuery orderByAttachmentChannel(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the attachment channel. (Should only be used if there is one attachment per task in other case the result would be wrong.)
      Specified by:
      orderByAttachmentChannel in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • attachmentReferenceValueIn

      public TaskQuery attachmentReferenceValueIn(String... referenceValues)
      Description copied from interface: TaskQuery
      Add the values of reference values for exact matching to your query.
      Specified by:
      attachmentReferenceValueIn in interface TaskQuery
      Parameters:
      referenceValues - the referenceValue values of the searched for tasks
      Returns:
      the query
    • attachmentReferenceValueNotIn

      public TaskQuery attachmentReferenceValueNotIn(String... referenceValues)
      Description copied from interface: TaskQuery
      Exclude the values of reference values for exact matching from your query.
      Specified by:
      attachmentReferenceValueNotIn in interface TaskQuery
      Parameters:
      referenceValues - the referenceValue values of the searched for tasks
      Returns:
      the query
    • attachmentReferenceValueLike

      public TaskQuery attachmentReferenceValueLike(String... referenceValues)
      Description copied from interface: TaskQuery
      Add the values of reference values for pattern matching to your query. They will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      attachmentReferenceValueLike in interface TaskQuery
      Parameters:
      referenceValues - the referenceValue values of the searched-for tasks
      Returns:
      the query
    • attachmentReferenceValueNotLike

      public TaskQuery attachmentReferenceValueNotLike(String... referenceValues)
      Description copied from interface: TaskQuery
      Exclude the values of reference values for pattern matching to your query. They will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      attachmentReferenceValueNotLike in interface TaskQuery
      Parameters:
      referenceValues - the referenceValue values of the searched-for tasks
      Returns:
      the query
    • orderByAttachmentReference

      public TaskQuery orderByAttachmentReference(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the attachment reference value. (Should only be used if there is one attachment per task in other case the result would be wrong.)
      Specified by:
      orderByAttachmentReference in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • attachmentReceivedWithin

      public TaskQuery attachmentReceivedWithin(io.kadai.common.api.TimeInterval... receivedIn)
      Description copied from interface: TaskQuery
      Add your received-dates to your query.
      Specified by:
      attachmentReceivedWithin in interface TaskQuery
      Parameters:
      receivedIn - the TimeInterval within which the searched-for tasks attachment were received the last time.
      Returns:
      the query
    • attachmentNotReceivedWithin

      public TaskQuery attachmentNotReceivedWithin(io.kadai.common.api.TimeInterval... receivedNotIn)
      Description copied from interface: TaskQuery
      Exclude the received-dates from your query.
      Specified by:
      attachmentNotReceivedWithin in interface TaskQuery
      Parameters:
      receivedNotIn - the TimeInterval within which the searched-for tasks attachment weren't received the last time.
      Returns:
      the query
    • orderByAttachmentReceived

      public TaskQuery orderByAttachmentReceived(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the attachment received. (Should only be used if there is one attachment per task in other case the result would be wrong.)
      Specified by:
      orderByAttachmentReceived in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • withoutAttachment

      public TaskQuery withoutAttachment()
      Description copied from interface: TaskQuery
      This method adds the condition that only Tasks that don't have any Attachments will be included in the TaskQuery.
      Specified by:
      withoutAttachment in interface TaskQuery
      Returns:
      the TaskQuery
    • getOwnerLongNameIn

      public String[] getOwnerLongNameIn()
    • getOwnerLongNameNotIn

      public String[] getOwnerLongNameNotIn()
    • getOwnerLongNameLike

      public String[] getOwnerLongNameLike()
    • getOwnerLongNameNotLike

      public String[] getOwnerLongNameNotLike()
    • secondaryObjectReferenceIn

      public TaskQuery secondaryObjectReferenceIn(ObjectReference... objectReferences)
      Description copied from interface: TaskQuery
      Add the ObjectReference to exact match to your query. Each individual value has to match. Fields with the value 'null' will be ignored. The id of each ObjectReference will be ignored

      If you specify multiple arguments they are combined with the OR keyword.

      Specified by:
      secondaryObjectReferenceIn in interface TaskQuery
      Parameters:
      objectReferences - the combined values which are searched together.
      Returns:
      the query
    • sorCompanyIn

      public TaskQuery sorCompanyIn(String... companies)
      Description copied from interface: TaskQuery
      Add the values of the company of at least one of the secondaryObjectReferences for exact matching to your query.
      Specified by:
      sorCompanyIn in interface TaskQuery
      Parameters:
      companies - the company values of the searched for Tasks
      Returns:
      the TaskQuery
    • sorCompanyLike

      public TaskQuery sorCompanyLike(String... companies)
      Description copied from interface: TaskQuery
      Add the values of company of at least one of the secondaryobjectReferences for pattern matching to your query. They will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      sorCompanyLike in interface TaskQuery
      Parameters:
      companies - the company values of the searched-for Tasks
      Returns:
      the TaskQuery
    • sorSystemIn

      public TaskQuery sorSystemIn(String... systems)
      Description copied from interface: TaskQuery
      Add the values of the system of at least one of the secondaryObjectReferences for exact matching to your query.
      Specified by:
      sorSystemIn in interface TaskQuery
      Parameters:
      systems - the system values of the searched for Tasks
      Returns:
      the TaskQuery
    • sorSystemLike

      public TaskQuery sorSystemLike(String... systems)
      Description copied from interface: TaskQuery
      Add the values of system of at least one of the secondaryobjectReferences for pattern matching to your query. They will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      sorSystemLike in interface TaskQuery
      Parameters:
      systems - the system values of the searched-for Tasks
      Returns:
      the TaskQuery
    • sorSystemInstanceIn

      public TaskQuery sorSystemInstanceIn(String... systemInstances)
      Description copied from interface: TaskQuery
      Add the values of the systemInstance of at least one of the secondaryObjectReferences for exact matching to your query.
      Specified by:
      sorSystemInstanceIn in interface TaskQuery
      Parameters:
      systemInstances - the systemInstance values of the searched for Tasks
      Returns:
      the TaskQuery
    • sorSystemInstanceLike

      public TaskQuery sorSystemInstanceLike(String... systemInstances)
      Description copied from interface: TaskQuery
      Add the values of systemInstance of at least one of the secondaryobjectReferences for pattern matching to your query. They will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      sorSystemInstanceLike in interface TaskQuery
      Parameters:
      systemInstances - the systemInstance values of the searched-for Tasks
      Returns:
      the TaskQuery
    • sorTypeIn

      public TaskQuery sorTypeIn(String... types)
      Description copied from interface: TaskQuery
      Add the values of the type of at least one of the secondaryObjectReferences for exact matching to your query.
      Specified by:
      sorTypeIn in interface TaskQuery
      Parameters:
      types - the type values of the searched for Tasks
      Returns:
      the TaskQuery
    • sorTypeLike

      public TaskQuery sorTypeLike(String... types)
      Description copied from interface: TaskQuery
      Add the values of type of at least one of the secondaryobjectReferences for pattern matching to your query. They will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      sorTypeLike in interface TaskQuery
      Parameters:
      types - the type values of the searched-for Tasks
      Returns:
      the TaskQuery
    • sorValueIn

      public TaskQuery sorValueIn(String... values)
      Description copied from interface: TaskQuery
      Add the values of the value of at least one of the secondaryObjectReferences for exact matching to your query.
      Specified by:
      sorValueIn in interface TaskQuery
      Parameters:
      values - the value values of the searched for Tasks
      Returns:
      the TaskQuery
    • sorValueLike

      public TaskQuery sorValueLike(String... values)
      Description copied from interface: TaskQuery
      Add the values of value of at least one of the secondaryobjectReferences for pattern matching to your query. They will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      sorValueLike in interface TaskQuery
      Parameters:
      values - the value values of the searched-for Tasks
      Returns:
      the TaskQuery
    • customAttributeIn

      public TaskQuery customAttributeIn(TaskCustomField customField, String... strings) throws io.kadai.common.api.exceptions.InvalidArgumentException
      Description copied from interface: TaskQuery
      Add the values of custom attributes for exact matching to your query.
      Specified by:
      customAttributeIn in interface TaskQuery
      Parameters:
      customField - identifies which custom attribute is affected.
      strings - the customField values of the searched for tasks
      Returns:
      the query
      Throws:
      io.kadai.common.api.exceptions.InvalidArgumentException - if searchArguments are not given
    • customAttributeNotIn

      public TaskQuery customAttributeNotIn(TaskCustomField customField, String... strings) throws io.kadai.common.api.exceptions.InvalidArgumentException
      Description copied from interface: TaskQuery
      Exclude these values of custom attributes from your query.
      Specified by:
      customAttributeNotIn in interface TaskQuery
      Parameters:
      customField - identifies which custom attribute is affected.
      strings - the customField values of the searched for tasks
      Returns:
      the query
      Throws:
      io.kadai.common.api.exceptions.InvalidArgumentException - if searchArguments are not given
    • customAttributeLike

      public TaskQuery customAttributeLike(TaskCustomField customField, String... strings) throws io.kadai.common.api.exceptions.InvalidArgumentException
      Description copied from interface: TaskQuery
      Add the values of custom attributes for pattern matching to your query. They will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      customAttributeLike in interface TaskQuery
      Parameters:
      customField - identifies which custom attribute is affected.
      strings - the customField values of the searched for tasks
      Returns:
      the query
      Throws:
      io.kadai.common.api.exceptions.InvalidArgumentException - if searchArguments is not given
    • customAttributeNotLike

      public TaskQuery customAttributeNotLike(TaskCustomField customField, String... strings) throws io.kadai.common.api.exceptions.InvalidArgumentException
      Description copied from interface: TaskQuery
      Exclude the values of custom attributes for pattern matching from your query. They will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. If you specify multiple arguments they are combined with the OR keyword.
      Specified by:
      customAttributeNotLike in interface TaskQuery
      Parameters:
      customField - identifies which custom attribute is affected.
      strings - the customField values of the searched for tasks
      Returns:
      the query
      Throws:
      io.kadai.common.api.exceptions.InvalidArgumentException - if searchArguments is not given
    • orderByCustomAttribute

      public TaskQuery orderByCustomAttribute(TaskCustomField customField, io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the value of a custom field.
      Specified by:
      orderByCustomAttribute in interface TaskQuery
      Parameters:
      customField - identifies which custom attribute is affected.
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • customIntAttributeNotIn

      public TaskQuery customIntAttributeNotIn(TaskCustomIntField customIntField, Integer... values) throws io.kadai.common.api.exceptions.InvalidArgumentException
      Description copied from interface: TaskQuery
      Exclude these values of the specified TaskCustomIntField from your query.
      Specified by:
      customIntAttributeNotIn in interface TaskQuery
      Parameters:
      customIntField - identifies which TaskCustomIntField is affected
      values - the corresponding customIntField values of the searched for Tasks
      Returns:
      the query
      Throws:
      io.kadai.common.api.exceptions.InvalidArgumentException - if searchArguments are not given
    • customIntAttributeIn

      public TaskQuery customIntAttributeIn(TaskCustomIntField customIntField, Integer... values) throws io.kadai.common.api.exceptions.InvalidArgumentException
      Description copied from interface: TaskQuery
      Add the values of the specified TaskCustomIntField for exact matching to your query.
      Specified by:
      customIntAttributeIn in interface TaskQuery
      Parameters:
      customIntField - identifies which TaskCustomIntField is affected
      values - the corresponding values of the searched for Tasks
      Returns:
      the query
      Throws:
      io.kadai.common.api.exceptions.InvalidArgumentException - if searchArguments are not given
    • orderByCustomIntAttribute

      public TaskQuery orderByCustomIntAttribute(TaskCustomIntField customIntField, io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the value of the specified TaskCustomIntField.
      Specified by:
      orderByCustomIntAttribute in interface TaskQuery
      Parameters:
      customIntField - identifies which TaskCustomIntField is affected
      sortDirection - determines whether the result is sorted in ascending or descending order; if sortDirection is NULL, the result is sorted in ascending order
      Returns:
      the query
    • customIntAttributeWithin

      public TaskQuery customIntAttributeWithin(TaskCustomIntField customIntField, io.kadai.common.api.IntInterval... values)
      Description copied from interface: TaskQuery
      Add the values of specified TaskCustomIntField for a range matching to your query. If the lower bound is NULL, then all values smaller than the upper bound will be accepted. If the upper bound is NULL, then all values greater than the lower bound will be accepted.
      Specified by:
      customIntAttributeWithin in interface TaskQuery
      Parameters:
      customIntField - identifies which TaskCustomIntField is affected
      values - identify the IntIntervals that are used for filtering
      Returns:
      the query
    • customIntAttributeNotWithin

      public TaskQuery customIntAttributeNotWithin(TaskCustomIntField customIntField, io.kadai.common.api.IntInterval... values)
      Description copied from interface: TaskQuery
      Exclude the values of specified TaskCustomIntField inside the given range from your query. If the lower bound is NULL, then all values smaller than the upper bound will be excluded. If the upper bound is NULL, then all values greater than the lower bound will be excluded.
      Specified by:
      customIntAttributeNotWithin in interface TaskQuery
      Parameters:
      customIntField - identifies which TaskCustomIntField is affected
      values - identify the IntIntervals that are used for filtering
      Returns:
      the query
    • callbackStateIn

      public TaskQuery callbackStateIn(CallbackState... states)
      Description copied from interface: TaskQuery
      Add your callbackState to your query.
      Specified by:
      callbackStateIn in interface TaskQuery
      Parameters:
      states - the callback states as CallbackState
      Returns:
      the query
    • callbackStateNotIn

      public TaskQuery callbackStateNotIn(CallbackState... states)
      Description copied from interface: TaskQuery
      Exclude the callbackState from your query.
      Specified by:
      callbackStateNotIn in interface TaskQuery
      Parameters:
      states - the callback states as CallbackState
      Returns:
      the query
    • wildcardSearchValueLike

      public TaskQuery wildcardSearchValueLike(String wildcardSearchValue)
      Description copied from interface: TaskQuery
      Add your wildcard search value for pattern matching to your query. It will be compared in SQL with the LIKE operator. You may use a wildcard like % to specify the pattern. Must be used in combination with the wildcardSearchFieldsIn parameter
      Specified by:
      wildcardSearchValueLike in interface TaskQuery
      Parameters:
      wildcardSearchValue - the wildcard search value
      Returns:
      the query
    • wildcardSearchFieldsIn

      public TaskQuery wildcardSearchFieldsIn(WildcardSearchField... wildcardSearchFields)
      Description copied from interface: TaskQuery
      Add the Task fields for which the wildcard search should be performed as an exact match to your query. Must be used in combination with the wildcardSearchValueLike parameter
      Specified by:
      wildcardSearchFieldsIn in interface TaskQuery
      Parameters:
      wildcardSearchFields - the Task fields of your wildcard search
      Returns:
      the query
    • createObjectReferenceQuery

      public ObjectReferenceQuery createObjectReferenceQuery()
      Description copied from interface: TaskQuery
      This method provides a query builder for quering the database.
      Specified by:
      createObjectReferenceQuery in interface TaskQuery
      Returns:
      a ObjectReferenceQuery
    • orderByDomain

      public TaskQuery orderByDomain(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the domain.
      Specified by:
      orderByDomain in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • orderByWorkbasketKey

      public TaskQuery orderByWorkbasketKey(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the workbasket key.
      Specified by:
      orderByWorkbasketKey in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • orderByWorkbasketName

      public TaskQuery orderByWorkbasketName(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the workbasket name of the tasks.
      Specified by:
      orderByWorkbasketName in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • orderByOwnerLongName

      public TaskQuery orderByOwnerLongName(io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Description copied from interface: TaskQuery
      This method sorts the query result according to the owner's long name. (Should only be used if each Task has an owner. Otherwise, the result is wrong.)
      Specified by:
      orderByOwnerLongName in interface TaskQuery
      Parameters:
      sortDirection - Determines whether the result is sorted in ascending or descending order. If sortDirection is null, the result is sorted in ascending order
      Returns:
      the query
    • list

      public List<TaskSummary> list()
      Specified by:
      list in interface io.kadai.common.api.BaseQuery<TaskSummary,TaskQueryColumnName>
    • list

      public List<TaskSummary> list(int offset, int limit)
      Specified by:
      list in interface io.kadai.common.api.BaseQuery<TaskSummary,TaskQueryColumnName>
    • listValues

      public List<String> listValues(TaskQueryColumnName columnName, io.kadai.common.api.BaseQuery.SortDirection sortDirection)
      Specified by:
      listValues in interface io.kadai.common.api.BaseQuery<TaskSummary,TaskQueryColumnName>
    • single

      public TaskSummary single()
      Specified by:
      single in interface io.kadai.common.api.BaseQuery<TaskSummary,TaskQueryColumnName>
    • count

      public long count()
      Specified by:
      count in interface io.kadai.common.api.BaseQuery<TaskSummary,TaskQueryColumnName>
    • selectAndClaimEquals

      public TaskQuery selectAndClaimEquals(boolean selectAndClaim)
    • lockResultsEquals

      public TaskQuery lockResultsEquals(Integer lockResults)
      Description copied from interface: TaskQuery
      This method locks the returned rows until the end of the transaction using the FOR UPDATE lock. It cannot be used together with selectAndClaim.
      Specified by:
      lockResultsEquals in interface TaskQuery
      Parameters:
      lockResults - determines the number of returned and locked results; if zero, no results are locked, but the number of returned results is not limited
      Returns:
      the query
    • toString

      public String toString()
      Overrides:
      toString in class Object