Package ch.ivyteam.ivy.workflow.query

Interface TaskQuery.IFilterableColumns

All Known Subinterfaces:
TaskQuery.IFilterQuery
All Known Implementing Classes:
TaskQuery.FilterQuery
Enclosing class:
TaskQuery
public static interface TaskQuery.IFilterableColumns
Provides filter functionality for ITask

Example: 

TaskQuery.create().where().customVarCharField1().isEqual("Hello World").and().customDecimalField2().isGreaterThan(15.3);
Corresponds to SQL: 
SELECT * FROM IWA_IWA_Task WHERE CustomVarCharField1 = 'Hello World' AND CustomDecimalField1 > 15.3

API:
This is a public API.

  • Method Details

    • cases

      TaskQuery.FilterLink cases(CaseQuery caseQuery)

      Adds an expression to the where clause that selects those tasks that belong to cases which matches the given caseQuery.

      This method considers only the where clause of the given caseQuery. All other parts are ignored.

      Example:
      Get all tasks that belong to cases with the custom varchar field1 set to "HRM" 

       import ITask;
 import ch.ivyteam.ivy.workflow.TaskState;
 import ch.ivyteam.ivy.workflow.query.TaskQuery;
 import ch.ivyteam.ivy.workflow.query.CaseQuery;

 TaskQuery query = TaskQuery.create().where().cases(CaseQuery.create().where().customVarCharField1().isEqual("HRM"));
 List<ITask> tasksWithBelongToHrmCases = ivy.wf.getTaskQueryExecutor().getResults(query);
      Parameters:
      caseQuery - case query with where clause to filter the cases
      Returns:
      the query for further composition
      Throws:
      IllegalArgumentException - If the given caseQuery is null
      API:
      This public API is available in Java.

    • haveTriggeredCases

      TaskQuery.FilterLink haveTriggeredCases(CaseQuery caseQuery)

      Adds an expression to the where clause that selects those tasks that have triggered the creation of cases which matches the given caseQuery.

      Tasks can trigger the creation of cases by using the Trigger process element.

      This method considers only the where clause of the given caseQuery. All other parts are ignored

      Example:
      Get all tasks that have created cases with the custom varchar field1 set to "HRM" 

       import ITask;
 import ch.ivyteam.ivy.workflow.TaskState;
 import ch.ivyteam.ivy.workflow.query.TaskQuery;
 import ch.ivyteam.ivy.workflow.query.CaseQuery;

 TaskQuery query = TaskQuery.create().where().haveTriggeredCases(CaseQuery.create().where().customVarCharField1().isEqual("HRM"));
 List<ITask> tasksThatTriggeredHrmCases = ivy.wf.getTaskQueryExecutor().getResults(query);
      Parameters:
      caseQuery - case query with where clause to filter the cases
      Returns:
      the query for further composition
      Throws:
      IllegalArgumentException - If the given caseQuery is null
      API:
      This public API is available in Java.

    • isInvolved

      TaskQuery.FilterLink isInvolved(ISecurityMember member)
      Filters all tasks the security member is involved in.
      Parameters:
      member -
      Returns:
      the query for further composition
      Throws:
      IllegalArgumentException - If the given member is null
      See Also:
      API:
      This public API is available in Java.

    • isInvolved

      TaskQuery.FilterLink isInvolved(String memberName, String applicationName)
      Filters all tasks where the security member with given member name (user or role) in the given application is involved in.

      Compared to the method isInvolved(ISecurityMember), this method evaluates the corresponding ISecurityMember on query execution.

      Example:
      Get all tasks where the current user or the user 'UserHans' is involved in: 

       import ch.ivyteam.ivy.workflow.ITask;
 import ch.ivyteam.ivy.workflow.query.TaskQuery;

 TaskQuery query = TaskQuery.create()
   .where().isInvolved("#UserHans", "MyApp") // note: to convert a user name to a member name a '#' is added as prefix
      .or().isInvolved(ivy.session.getSessionUser().getMemberName(), "MyApp");

 List<ITask> tasks = ivy.wf.getTaskQueryExecutor().getResults(query);
      Parameters:
      memberName - e.g. "#UserHans" or "TopManagementRole"
      applicationName - e.g. "MyApplication"
      Returns:
      the query for further composition
      See Also:
      API:
      This public API is available in Java.

    • userIsInvolved

      TaskQuery.FilterLink userIsInvolved(String userName, String applicationName)
      Filters all tasks where the user with given name in the given application is involved in.

      Compared to the method userIsInvolved(IUser), this method evaluates the corresponding IUser on query execution.

      This method is equivalent to isInvolved("#" + userName, applicationName)

      Parameters:
      userName - e.g. "UserHans"
      applicationName -
      Returns:
      the query for further composition
      See Also:
      API:
      This public API is available in Java.

    • roleIsInvolved

      TaskQuery.FilterLink roleIsInvolved(String roleName, String applicationName)
      Filters all tasks where the role with given name in the given application is involved in.

      Compared to the method roleIsInvolved(IRole), this method evaluates the corresponding IRole on query execution.

      This method is equivalent to isInvolved(String, String)

      Parameters:
      roleName - e.g. "TopManagementRole"
      applicationName -
      Returns:
      the query for further composition@see CaseQuery.IFilterQuery#isInvolved(ISecurityMember)
      See Also:
      API:
      This public API is available in Java.

    • currentUserIsInvolved

      TaskQuery.FilterLink currentUserIsInvolved()
      Filters all tasks the user of the current session user is involved in.

      Example: 

       import ch.ivyteam.ivy.workflow.query.TaskQuery;
 import ch.ivyteam.ivy.workflow.ITask;

 TaskQuery query = TaskQuery.create().where().currentUserIsInvolved();
 List<ITask> tasksSessionIsInvolved = ivy.wf.getTaskQueryExecutor().getResults(query);
      Returns:
      the query for further composition
      Throws:
      IllegalStateException - If there is no current session available
      See Also:
      API:
      This public API is available in Java.

    • roleIsInvolved

      TaskQuery.FilterLink roleIsInvolved(IRole role)

      Filters all tasks the role is involved in. A role is involved in a task if

      • the task is assigned to the role. Either before or after the expiry.
      A role is not involved in a task if
      • the role becomes responsible for a task after expiry but the task has not yet expired.
      • the task is assigned to the role but is delayed
      • the task is assigned to a sub or parent role of the role

      Example: 

       import ch.ivyteam.ivy.workflow.query.TaskQuery;
 import ch.ivyteam.ivy.workflow.ITask;
 import ch.ivyteam.ivy.security.IRole;

 IRole role = ivy.session.getSecurityContext().findRole("Admin");
 TaskQuery query = TaskQuery.create().where().roleIsInvolved(role);
 List<ITask> userInvolvedTasks = ivy.wf.getTaskQueryExecutor().getResults(query);
      Parameters:
      role -
      Returns:
      the query for further composition
      Throws:
      IllegalArgumentException - If the given role is null
      See Also:
      API:
      This public API is available in Java.

    • userIsInvolved

      TaskQuery.FilterLink userIsInvolved(IUser user)

      Filters all tasks the user is involved in. A user is involved in a task if

      • the user could work on the task
      • the user is working at the task right now
      • the user has completed the task
      A user is not involved in a task if
      • the user has worked on the task without completing it and now it is no longer accessible for him. Either because the task was completed by someone else, was reassigned, ...
      • the user can work on the task but it is delayed

      Example: 

       import ch.ivyteam.ivy.workflow.query.TaskQuery;
 import ch.ivyteam.ivy.workflow.ITask;
 import ch.ivyteam.ivy.security.IUser;

 IUser user = ivy.session.getSessionUser();
 TaskQuery query = TaskQuery.create().where().userIsInvolved(user);
 List<ITask> userInvolvedTasks = ivy.wf.getTaskQueryExecutor().getResults(query);
      Parameters:
      user -
      Returns:
      the query for further composition
      Throws:
      IllegalArgumentException - If the given user is null
      See Also:
      API:
      This public API is available in Java.

    • canWorkOn

      TaskQuery.FilterLink canWorkOn(ISecurityMember member)
      Filters all tasks the given security member (user or role) can now work on.

      Example: 

       import ch.ivyteam.ivy.workflow.query.TaskQuery;
 import ch.ivyteam.ivy.workflow.ITask;
 import ch.ivyteam.ivy.security.IUser;

 IUser user = ivy.session.getSessionUser();
 TaskQuery query = TaskQuery.create().where().canWorkOn(user);
 List<ITask> tasksUserCanWorkOn = ivy.wf.getTaskQueryExecutor().getResults(query);
      Parameters:
      member -
      Returns:
      the query for further composition
      Throws:
      IllegalArgumentException - If the given member is null
      See Also:
      API:
      This public API is available in Java.

    • canWorkOn

      TaskQuery.FilterLink canWorkOn(String memberName, String applicationName)
      Filters all tasks where the security member with given member name (user or role) in the given application can now work on.
      Compared to the method canWorkOn(ISecurityMember), this method evaluates the corresponding ISecurityMember on query execution.

      Example:
      Get all tasks where the current user or the user 'UserHans' can work on: 

       import ch.ivyteam.ivy.workflow.ITask;
 import ch.ivyteam.ivy.workflow.query.TaskQuery;

 TaskQuery query = TaskQuery.create()
   .where().canWorkOn("#UserHans", "MyApp") // note: to convert a user name to a member name a '#' is added as prefix
      .or().canWorkOn(ivy.session.getSessionUser().getMemberName(), "MyApp");

 List<ITask> tasks = ivy.wf.getTaskQueryExecutor().getResults(query);
      Parameters:
      memberName - e.g. "#UserHans" or "TopManagementRole"
      applicationName - e.g. "MyApplication"
      Returns:
      the query for further composition
      See Also:
      API:
      This public API is available in Java.

    • currentUserCanWorkOn

      TaskQuery.FilterLink currentUserCanWorkOn()
      Filters all tasks the current session user can now work on.

      Example: 

       import ch.ivyteam.ivy.workflow.query.TaskQuery;
 import ch.ivyteam.ivy.workflow.ITask;

 TaskQuery query = TaskQuery.create().where().currentUserCanWorkOn();
 List<ITask> tasksSessionCanWorkOn = ivy.wf.getTaskQueryExecutor().getResults(query);
      Returns:
      the query for further composition
      Throws:
      IllegalStateException - If there is no current session available
      See Also:
      API:
      This public API is available in Java.

    • hasWorkedOn

      TaskQuery.FilterLink hasWorkedOn(ISecurityMember member)
      Filters all tasks the given security member (user or role) has worked on.

      Example: 

       import ch.ivyteam.ivy.workflow.query.TaskQuery;
 import ch.ivyteam.ivy.workflow.ITask;
 import ch.ivyteam.ivy.security.IUser;

 IUser user = ivy.session.getSessionUser();
 TaskQuery query = TaskQuery.create().where().hasWorkedOn(user);
 List<ITask> tasksUserHasWorkedOn = ivy.wf.getTaskQueryExecutor().getResults(query);
      Parameters:
      member -
      Returns:
      the query for further composition
      Throws:
      IllegalArgumentException - If the given member is null
      See Also:
      API:
      This public API is available in Java.

    • hasWorkedOn

      TaskQuery.FilterLink hasWorkedOn(String memberName, String applicationName)
      Filters all tasks where the security member with given member name (user or role) in the given application has worked on.
      Compared to the method hasWorkedOn(ISecurityMember), this method evaluates the corresponding ISecurityMember on query execution.

      Example:
      Get all tasks where the current user or the user 'UserHans' has worked on: 

       import ch.ivyteam.ivy.workflow.ITask;
 import ch.ivyteam.ivy.workflow.query.TaskQuery;

 TaskQuery query = TaskQuery.create()
   .where().hasWorkedOn("#UserHans", "MyApp") // note: to convert a user name to a member name a '#' is added as prefix
      .or().hasWorkedOn(ivy.session.getSessionUser().getMemberName(), "MyApp");

 List<ITask> tasks = ivy.wf.getTaskQueryExecutor().getResults(query);
      Parameters:
      memberName - e.g. "#UserHans" or "TopManagementRole"
      applicationName - e.g. "MyApplication"
      Returns:
      the query for further composition
      See Also:
      API:
      This public API is available in Java.

    • currentUserHasWorkedOn

      TaskQuery.FilterLink currentUserHasWorkedOn()
      Filters all tasks the current session user has worked on.

      Example: 

       import ch.ivyteam.ivy.workflow.query.TaskQuery;
 import ch.ivyteam.ivy.workflow.ITask;

 TaskQuery query = TaskQuery.create().where().currentUserHasWorkedOn();
 List<ITask> tasksSessionHasWorkedOn = ivy.wf.getTaskQueryExecutor().getResults(query);
      Returns:
      the query for further composition
      Throws:
      IllegalStateException - If there is no current session available
      See Also:
      API:
      This public API is available in Java.

    • businessCalendarId

      @Deprecated(since="7.4", forRemoval=true) TaskQuery.IIntegerColumnFilterQuery businessCalendarId()
      Deprecated, for removal: This API element is subject to removal in a future version.
      use businessCalendar() instead

      This method is deprecated and does nothing! It will not add any filter to the query.

      It exists only for backward compatibility reasons. In earlier version the method prepared a where statement for the column BusinessCalendarId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • activatorAvailable

      TaskQuery.IBoolFilterQuery activatorAvailable()
      Whether the activator is set and in case of a user is enabled.
      Returns:
      true if activator is set and is not disabled.
      See Also:
      API:
      This public API is available in Java.

    • customField

      TaskQuery.ICustomFieldFilterQuery customField()
      Prepares a where statement for a custom field.
      Must be followed by a call to a field value type.

      Example: 

       import ch.ivyteam.ivy.workflow.ITask;
 import ch.ivyteam.ivy.workflow.query.TaskQuery;

 TaskQuery query = TaskQuery.create().where().customField().stringField("myCustomField").isEqualTo("valueToFind")";
 List<ITask> tasksWithMatchingField = ivy.wf.getTaskQueryExecutor().getResults(query);
      Returns:
      the query for further composition
      API:
      This public API is available in Java.

    • additionalProperty

      @Deprecated TaskQuery.IStringColumnFilterQuery additionalProperty(String key)
      Deprecated.
      use customField().textField(key) instead
      Prepares a where statement for an additional property value.
      Must be followed by a call to a condition method.
      Parameters:
      key - the additional property key
      Returns:
      the query for further composition
      API:
      This public API is available in Java.

    • customVarCharField1

      @Deprecated TaskQuery.IStringColumnFilterQuery customVarCharField1()
      Deprecated.
      use customField().stringField("CustomVarCharField1") instead

      Prepares a where statement for the custom field "CustomVarCharField1".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • customVarCharField2

      @Deprecated TaskQuery.IStringColumnFilterQuery customVarCharField2()
      Deprecated.
      use customField().stringField("CustomVarCharField2") instead

      Prepares a where statement for the custom field "CustomVarCharField2".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • customVarCharField3

      @Deprecated TaskQuery.IStringColumnFilterQuery customVarCharField3()
      Deprecated.
      use customField().stringField("CustomVarCharField3") instead

      Prepares a where statement for the custom field "CustomVarCharField3".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • customVarCharField4

      @Deprecated TaskQuery.IStringColumnFilterQuery customVarCharField4()
      Deprecated.
      use customField().stringField("CustomVarCharField4") instead

      Prepares a where statement for the custom field "CustomVarCharField4".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • customVarCharField5

      @Deprecated TaskQuery.IStringColumnFilterQuery customVarCharField5()
      Deprecated.
      use customField().stringField("CustomVarCharField5") instead

      Prepares a where statement for the custom field "CustomVarCharField5".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • customDecimalField1

      @Deprecated TaskQuery.INumberColumnFilterQuery customDecimalField1()
      Deprecated.
      use customField().numberField("CustomDecimalField1") instead

      Prepares a where statement for the custom field "CustomDecimalField1".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • customDecimalField2

      @Deprecated TaskQuery.INumberColumnFilterQuery customDecimalField2()
      Deprecated.
      use customField().numberField("CustomDecimalField2") instead

      Prepares a where statement for the custom field "CustomDecimalField2".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • customDecimalField3

      @Deprecated TaskQuery.INumberColumnFilterQuery customDecimalField3()
      Deprecated.
      use customField().numberField("CustomDecimalField3") instead

      Prepares a where statement for the custom field "CustomDecimalField3".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • customDecimalField4

      @Deprecated TaskQuery.INumberColumnFilterQuery customDecimalField4()
      Deprecated.
      use customField().numberField("CustomDecimalField4") instead

      Prepares a where statement for the custom field "CustomDecimalField4".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • customDecimalField5

      @Deprecated TaskQuery.INumberColumnFilterQuery customDecimalField5()
      Deprecated.
      use customField().numberField("CustomDecimalField5") instead

      Prepares a where statement for the custom field "CustomDecimalField5".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • customTimestampField1

      @Deprecated TaskQuery.IDateColumnFilterQuery customTimestampField1()
      Deprecated.
      use customField().timestampField("CustomTimestampField1") instead

      Prepares a where statement for the custom field "CustomTimestampField1".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • customTimestampField2

      @Deprecated TaskQuery.IDateColumnFilterQuery customTimestampField2()
      Deprecated.
      use customField().timestampField("CustomTimestampField2") instead

      Prepares a where statement for the custom field "CustomTimestampField2".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • customTimestampField3

      @Deprecated TaskQuery.IDateColumnFilterQuery customTimestampField3()
      Deprecated.
      use customField().timestampField("CustomTimestampField3") instead

      Prepares a where statement for the custom field "CustomTimestampField3".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • customTimestampField4

      @Deprecated TaskQuery.IDateColumnFilterQuery customTimestampField4()
      Deprecated.
      use customField().timestampField("CustomTimestampField4") instead

      Prepares a where statement for the custom field "CustomTimestampField4".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • customTimestampField5

      @Deprecated TaskQuery.IDateColumnFilterQuery customTimestampField5()
      Deprecated.
      use customField().timestampField("CustomTimestampField5") instead

      Prepares a where statement for the custom field "CustomTimestampField5".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • businessMilestoneTimestamp

      @Deprecated TaskQuery.IDateColumnFilterQuery businessMilestoneTimestamp()
      Deprecated.
      use customField().timestampField("BusinessMilestoneTimestamp") instead

      Prepares a where statement for the custom field "BusinessMilestoneTimestamp".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • businessCreatorUser

      @Deprecated TaskQuery.IStringColumnFilterQuery businessCreatorUser()
      Deprecated.
      use customField().stringField("BusinessCreatorUser") instead

      Prepares a where statement for the custom field "BusinessCreatorUser".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • businessMainContactId

      @Deprecated TaskQuery.IIntegerColumnFilterQuery businessMainContactId()
      Deprecated.
      use customField().numberField("BusinessMainContactId") instead

      Prepares a where statement for the custom field "BusinessMainContactId".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • businessMainContactName

      @Deprecated TaskQuery.IStringColumnFilterQuery businessMainContactName()
      Deprecated.
      use customField().stringField("BusinessMainContactName") instead

      Prepares a where statement for the custom field "BusinessMainContactName".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • businessObjectCode

      @Deprecated TaskQuery.IStringColumnFilterQuery businessObjectCode()
      Deprecated.
      use customField().stringField("BusinessObjectCode") instead

      Prepares a where statement for the custom field "BusinessObjectCode".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • businessObjectName

      @Deprecated TaskQuery.IStringColumnFilterQuery businessObjectName()
      Deprecated.
      use customField().stringField("BusinessObjectName") instead

      Prepares a where statement for the custom field "BusinessObjectName".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • businessStartTimestamp

      @Deprecated TaskQuery.IDateColumnFilterQuery businessStartTimestamp()
      Deprecated.
      use customField().timestampField("BusinessStartTimestamp") instead

      Prepares a where statement for the custom field "BusinessStartTimestamp".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • kindCode

      @Deprecated TaskQuery.IStringColumnFilterQuery kindCode()
      Deprecated.
      use customField().stringField("KindCode") instead

      Prepares a where statement for the custom field "KindCode".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • kindName

      @Deprecated TaskQuery.IStringColumnFilterQuery kindName()
      Deprecated.
      use customField().stringField("KindName") instead

      Prepares a where statement for the custom field "KindName".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • processCode

      @Deprecated TaskQuery.IStringColumnFilterQuery processCode()
      Deprecated.
      use customField().stringField("ProcessCode") instead

      Prepares a where statement for the custom field "ProcessCode".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • processName

      @Deprecated TaskQuery.IStringColumnFilterQuery processName()
      Deprecated.
      use customField().stringField("ProcessName") instead

      Prepares a where statement for the custom field "ProcessName".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • processCategoryCode

      @Deprecated TaskQuery.IStringColumnFilterQuery processCategoryCode()
      Deprecated.
      use customField().stringField("ProcessCategoryCode") instead

      Prepares a where statement for the custom field "ProcessCategoryCode".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • processCategoryName

      @Deprecated TaskQuery.IStringColumnFilterQuery processCategoryName()
      Deprecated.
      use customField().stringField("ProcessCategoryName") instead

      Prepares a where statement for the custom field "ProcessCategoryName".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • typeCode

      @Deprecated TaskQuery.IStringColumnFilterQuery typeCode()
      Deprecated.
      use customField().stringField("TypeCode") instead

      Prepares a where statement for the custom field "TypeCode".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • typeName

      @Deprecated TaskQuery.IStringColumnFilterQuery typeName()
      Deprecated.
      use customField().stringField("TypeName") instead

      Prepares a where statement for the custom field "TypeName".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • subTypeCode

      @Deprecated TaskQuery.IStringColumnFilterQuery subTypeCode()
      Deprecated.
      use customField().stringField("SubTypeCode") instead

      Prepares a where statement for the custom field "SubTypeCode".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • subTypeName

      @Deprecated TaskQuery.IStringColumnFilterQuery subTypeName()
      Deprecated.
      use customField().stringField("SubTypeName") instead

      Prepares a where statement for the custom field "SubTypeName".
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • workerUserId

      @Deprecated(since="9.1", forRemoval=true) TaskQuery.IIntegerColumnFilterQuery workerUserId()
      Deprecated, for removal: This API element is subject to removal in a future version.
      use workerId() instead

      Prepares a where statement for the legacy field WorkerUserId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • activatorRoleId

      @Deprecated(since="9.1", forRemoval=true) TaskQuery.IIntegerColumnFilterQuery activatorRoleId()
      Deprecated, for removal: This API element is subject to removal in a future version.
      use activatorId() instead

      Prepares a where statement for the legacy field ActivatorRoleId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • activatorUserId

      @Deprecated(since="9.1", forRemoval=true) TaskQuery.IIntegerColumnFilterQuery activatorUserId()
      Deprecated, for removal: This API element is subject to removal in a future version.
      use activatorId() instead

      Prepares a where statement for the legacy field ActivatorUserId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • originalActivatorRoleId

      @Deprecated(since="9.1", forRemoval=true) TaskQuery.IIntegerColumnFilterQuery originalActivatorRoleId()
      Deprecated, for removal: This API element is subject to removal in a future version.
      use originalActivatorId() instead

      Prepares a where statement for the legacy field OriginalActivatorRoleId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • originalActivatorUserId

      @Deprecated(since="9.1", forRemoval=true) TaskQuery.IIntegerColumnFilterQuery originalActivatorUserId()
      Deprecated, for removal: This API element is subject to removal in a future version.
      use originalActivatorId() instead

      Prepares a where statement for the legacy field OriginalActivatorUserId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • expiryActivatorRoleId

      @Deprecated(since="9.1", forRemoval=true) TaskQuery.IIntegerColumnFilterQuery expiryActivatorRoleId()
      Deprecated, for removal: This API element is subject to removal in a future version.
      use expiryActivatorId() instead

      Prepares a where statement for the legacy field ExpiryActivatorRoleId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • expiryActivatorUserId

      @Deprecated(since="9.1", forRemoval=true) TaskQuery.IIntegerColumnFilterQuery expiryActivatorUserId()
      Deprecated, for removal: This API element is subject to removal in a future version.
      use expiryActivatorId() instead

      Prepares a where statement for the legacy field ExpiryActivatorUserId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • displayNameTemplate

      @Deprecated(since="9.4", forRemoval=true) TaskQuery.IStringColumnFilterQuery displayNameTemplate()
      Deprecated, for removal: This API element is subject to removal in a future version.
      the removed DisplayNameTemplate column was never used in production.

      Does not add any filter because column DisplayNameTemplate was removed without any replacement.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • displayDescriptionTemplate

      @Deprecated(since="9.4", forRemoval=true) TaskQuery.IClobColumnFilterQuery displayDescriptionTemplate()
      Deprecated, for removal: This API element is subject to removal in a future version.
      the removed DisplayDescriptionTemplate column was never used in production.

      Does not add any filter because column DisplayDescriptionTemplate was removed without any replacement.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • not

      TaskQuery.FilterQuery not(TaskQuery otherQuery)

      Adds a condition, which negates a set of where conditions given by the otherQuery with a NOT expression.
      Only the where clause of the given otherQuery is considered. All other parts are ignored.

      SQL part: NOT([otherSqlExpression])

      Example: 

      TaskQuery subQuery = TaskQuery.create().where()
      .customVarCharField1().equals("a").or()
      .customVarCharField2().equals("b")
TaskQuery query = TaskQuery.create().where()
      .not(subQuery)
      Corresponds to SQL: 
      SELECT * FROM IWA_IWA_Task
  WHERE NOT(
    customVarCharField1 = 'a'
    OR customVarCharField2 = 'b')

      Parameters:
      otherQuery - Query from which the negated where part will be added to the current query.
      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • taskId

      TaskQuery.IIntegerColumnFilterQuery taskId()

      Prepares a where statement for the column TaskId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • uuid

      TaskQuery.IUUIDColumnFilterQuery uuid()

      Prepares a where statement for the column UUID.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • caseId

      TaskQuery.IIntegerColumnFilterQuery caseId()

      Prepares a where statement for the column CaseId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • businessCaseId

      TaskQuery.IIntegerColumnFilterQuery businessCaseId()

      Prepares a where statement for the column BusinessCaseId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • processModelId

      TaskQuery.IIntegerColumnFilterQuery processModelId()

      Prepares a where statement for the column ProcessModelId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • securitySystemId

      TaskQuery.IIntegerColumnFilterQuery securitySystemId()

      Prepares a where statement for the column SecuritySystemId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • applicationId

      TaskQuery.IIntegerColumnFilterQuery applicationId()

      Prepares a where statement for the column ApplicationId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • startTaskSwitchEventId

      TaskQuery.IIntegerColumnFilterQuery startTaskSwitchEventId()

      Prepares a where statement for the column StartTaskSwitchEventId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • endTaskSwitchEventId

      TaskQuery.IIntegerColumnFilterQuery endTaskSwitchEventId()

      Prepares a where statement for the column EndTaskSwitchEventId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • taskStartId

      TaskQuery.IIntegerColumnFilterQuery taskStartId()

      Prepares a where statement for the column TaskStartId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • taskEndId

      TaskQuery.IIntegerColumnFilterQuery taskEndId()

      Prepares a where statement for the column TaskEndId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • workerId

      TaskQuery.IStringColumnFilterQuery workerId()

      Prepares a where statement for the column WorkerId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • workerUserName

      TaskQuery.IStringColumnFilterQuery workerUserName()

      Prepares a where statement for the column WorkerUserName.
      Must be followed by a call to a condition method.

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


      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • workerUserDisplayName

      TaskQuery.IStringColumnFilterQuery workerUserDisplayName()

      Prepares a where statement for the column WorkerUserDisplayName.
      Must be followed by a call to a condition method.

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


      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • workerSessionId

      TaskQuery.IIntegerColumnFilterQuery workerSessionId()

      Prepares a where statement for the column WorkerSessionId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • activatorId

      TaskQuery.IStringColumnFilterQuery activatorId()

      Prepares a where statement for the column ActivatorId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • originalActivatorId

      TaskQuery.IStringColumnFilterQuery originalActivatorId()

      Prepares a where statement for the column OriginalActivatorId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • originalActivatorName

      TaskQuery.IStringColumnFilterQuery originalActivatorName()

      Prepares a where statement for the column OriginalActivatorName.
      Must be followed by a call to a condition method.

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


      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • originalActivatorDisplayName

      TaskQuery.IStringColumnFilterQuery originalActivatorDisplayName()

      Prepares a where statement for the column OriginalActivatorDisplayName.
      Must be followed by a call to a condition method.

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


      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • expiryActivatorId

      TaskQuery.IStringColumnFilterQuery expiryActivatorId()

      Prepares a where statement for the column ExpiryActivatorId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • expiryActivatorName

      TaskQuery.IStringColumnFilterQuery expiryActivatorName()

      Prepares a where statement for the column ExpiryActivatorName.
      Must be followed by a call to a condition method.

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


      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • expiryActivatorDisplayName

      TaskQuery.IStringColumnFilterQuery expiryActivatorDisplayName()

      Prepares a where statement for the column ExpiryActivatorDisplayName.
      Must be followed by a call to a condition method.

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


      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • expiryPriority

      TaskQuery.IWorkflowPriorityFilterQuery expiryPriority()

      Prepares a where statement for the column ExpiryPriority.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • expiryTimestamp

      TaskQuery.IDateColumnFilterQuery expiryTimestamp()

      Prepares a where statement for the column ExpiryTimestamp.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • expiryTaskStartElementPid

      TaskQuery.IStringColumnFilterQuery expiryTaskStartElementPid()

      Prepares a where statement for the column ExpiryTaskStartElementPid.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • isExpired

      TaskQuery.IBooleanColumnFilterQuery isExpired()

      Prepares a where statement for the column IsExpired.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • expiredCreatorTaskId

      TaskQuery.IIntegerColumnFilterQuery expiredCreatorTaskId()

      Prepares a where statement for the column ExpiredCreatorTaskId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • timeoutedCreatorIntrmdtEventId

      TaskQuery.IIntegerColumnFilterQuery timeoutedCreatorIntrmdtEventId()

      Prepares a where statement for the column TimeoutedCreatorIntrmdtEventId.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • delayTimestamp

      TaskQuery.IDateColumnFilterQuery delayTimestamp()

      Prepares a where statement for the column DelayTimestamp.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • state

      TaskQuery.ITaskStateFilterQuery state()

      Prepares a where statement for the column State.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • businessState

      TaskQuery.ITaskBusinessStateFilterQuery businessState()

      Prepares a where statement for the column BusinessState.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • requestPath

      TaskQuery.IStringColumnFilterQuery requestPath()

      Prepares a where statement for the column RequestPath.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • name

      TaskQuery.IStringColumnFilterQuery name()

      Prepares a where statement for the column Name.
      Must be followed by a call to a condition method.

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


      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • description

      TaskQuery.IClobColumnFilterQuery description()

      Prepares a where statement for the column Description.
      Must be followed by a call to a condition method.

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


      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • priority

      TaskQuery.IWorkflowPriorityFilterQuery priority()

      Prepares a where statement for the column Priority.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • originalPriority

      TaskQuery.IWorkflowPriorityFilterQuery originalPriority()

      Prepares a where statement for the column OriginalPriority.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • startTimestamp

      TaskQuery.IDateColumnFilterQuery startTimestamp()

      Prepares a where statement for the column StartTimestamp.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • endTimestamp

      TaskQuery.IDateColumnFilterQuery endTimestamp()

      Prepares a where statement for the column EndTimestamp.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • modifiedTimestamp

      TaskQuery.IDateColumnFilterQuery modifiedTimestamp()

      Prepares a where statement for the column ModifiedTimestamp.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • businessCalendar

      TaskQuery.IStringColumnFilterQuery businessCalendar()

      Prepares a where statement for the column BusinessCalendar.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • workingTime

      TaskQuery.INumberColumnFilterQuery workingTime()

      Prepares a where statement for the column WorkingTime.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • businessRuntime

      TaskQuery.INumberColumnFilterQuery businessRuntime()

      Prepares a where statement for the column BusinessRuntime.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • failedTimeoutTimestamp

      TaskQuery.IDateColumnFilterQuery failedTimeoutTimestamp()

      Prepares a where statement for the column FailedTimeoutTimestamp.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • numberOfFailures

      TaskQuery.IIntegerColumnFilterQuery numberOfFailures()

      Prepares a where statement for the column NumberOfFailures.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • numberOfResumes

      TaskQuery.IIntegerColumnFilterQuery numberOfResumes()

      Prepares a where statement for the column NumberOfResumes.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • category

      TaskQuery.IStringColumnFilterQuery category()

      Prepares a where statement for the column Category.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • isUpdatedOnStart

      TaskQuery.IBooleanColumnFilterQuery isUpdatedOnStart()

      Prepares a where statement for the column IsUpdatedOnStart.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • isOffline

      TaskQuery.IBooleanColumnFilterQuery isOffline()

      Prepares a where statement for the column IsOffline.
      Must be followed by a call to a condition method.

      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • activatorName

      TaskQuery.IStringColumnFilterQuery activatorName()

      Prepares a where statement for the column ActivatorName.
      Must be followed by a call to a condition method.

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


      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • activatorDisplayName

      TaskQuery.IStringColumnFilterQuery activatorDisplayName()

      Prepares a where statement for the column ActivatorDisplayName.
      Must be followed by a call to a condition method.

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


      Returns:
      query for further composition
      API:
      This public API is available in Java.

    • languageId

      TaskQuery.IIntegerColumnFilterQuery languageId()

      Prepares a where statement for the column LanguageId.
      Must be followed by a call to a condition method.

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


      Returns:
      query for further composition
      API:
      This public API is available in Java.