Package ch.ivyteam.ivy.workflow.query

Interface CaseQuery.IFilterableColumns

All Known Subinterfaces:

CaseQuery.IFilterQuery

All Known Implementing Classes:

CaseQuery.FilterQuery

Enclosing class:

CaseQuery

public static interface CaseQuery.IFilterableColumns

Provides filter functionality for ICase

Example:

CaseQuery.businessCases().where().customVarCharField1().isEqual("Hello World").and().customDecimalField2().isGreaterThan(15.3);

Corresponds to SQL:

SELECT * FROM IWA_IWA_Case WHERE CustomVarCharField1 = 'Hello World' AND CustomDecimalField1 > 15.3

API:

This is a public API.

Method Summary

Modifier and Type	Method	Description
CaseQuery.IStringColumnFilterQuery	activatorId()	Prepares a where statement for the column ActivatorId. Must be followed by a call to a condition method.
CaseQuery.IStringColumnFilterQuery	additionalProperty(String key)	Deprecated. use customField().textField(key) instead
CaseQuery.IIntegerColumnFilterQuery	applicationId()	Prepares a where statement for the column ApplicationId. Must be followed by a call to a condition method.
CaseQuery.IStringColumnFilterQuery	businessCalendar()	Prepares a where statement for the column BusinessCalendar. Must be followed by a call to a condition method.
CaseQuery.IIntegerColumnFilterQuery	businessCalendarId()	Deprecated, for removal: This API element is subject to removal in a future version. use businessCalendar() instead
CaseQuery.IIntegerColumnFilterQuery	businessCaseId()	Prepares a where statement for the column BusinessCaseId. Must be followed by a call to a condition method.
CaseQuery.IIntegerColumnFilterQuery	businessCorrespondentId()	Deprecated. use customField().numberField("BusinessCorrespondentId") instead
CaseQuery.IStringColumnFilterQuery	businessCreatorUser()	Deprecated. use customField().stringField("BusinessCreatorUser") instead
CaseQuery.IStringColumnFilterQuery	businessMainContactDocDbCode()	Deprecated. use customField().stringField("BusinessMainContactDocumentDbCode") instead
CaseQuery.IStringColumnFilterQuery	businessMainContactFolderId()	Deprecated. use customField().stringField("BusinessMainContactFolderId") instead
CaseQuery.IIntegerColumnFilterQuery	businessMainContactId()	Deprecated. use customField().numberField("BusinessMainContactId") instead
CaseQuery.IStringColumnFilterQuery	businessMainContactName()	Deprecated. use customField().stringField("BusinessMainContactName") instead
CaseQuery.IStringColumnFilterQuery	businessMainContactType()	Deprecated. use customField().stringField("BusinessMainContactType") instead
CaseQuery.IDateColumnFilterQuery	businessMilestoneTimestamp()	Deprecated. use customField().timestampField("BusinessMilestoneTimestamp") instead
CaseQuery.IStringColumnFilterQuery	businessObjectCode()	Deprecated. use customField().stringField("BusinessObjectCode") instead
CaseQuery.IStringColumnFilterQuery	businessObjectDocDbCode()	Deprecated. use customField().stringField("BusinessObjectDocumentDbCode") instead
CaseQuery.IStringColumnFilterQuery	businessObjectFolderId()	Deprecated. use customField().stringField("BusinessObjectFolderId") instead
CaseQuery.IStringColumnFilterQuery	businessObjectName()	Deprecated. use customField().stringField("BusinessObjectName") instead
CaseQuery.IStringColumnFilterQuery	businessPriority()	Deprecated. use customField().stringField("BusinessPriority") instead
CaseQuery.INumberColumnFilterQuery	businessRuntime()	Prepares a where statement for the column BusinessRuntime. Must be followed by a call to a condition method.
CaseQuery.IDateColumnFilterQuery	businessStartTimestamp()	Deprecated. use customField().timestampField("BusinessStartTimestamp") instead
CaseQuery.ICaseBusinessStateFilterQuery	businessState()	Prepares a where statement for the column BusinessState. Must be followed by a call to a condition method.
CaseQuery.FilterLink	canWorkOn(ISecurityMember member)	Filters all cases where the security member (user or role) can work on at least one task.
CaseQuery.FilterLink	canWorkOn(IUserToken userToken)	Filters all cases where the user token can work on at least one task.
CaseQuery.IIntegerColumnFilterQuery	caseId()	Prepares a where statement for the column CaseId. Must be followed by a call to a condition method.
CaseQuery.IStringColumnFilterQuery	category()	Prepares a where statement for the column Category. Must be followed by a call to a condition method.
CaseQuery.IStringColumnFilterQuery	creatorId()	Prepares a where statement for the column CreatorId. Must be followed by a call to a condition method.
CaseQuery.IIntegerColumnFilterQuery	creatorTaskId()	Prepares a where statement for the column CreatorTaskId. Must be followed by a call to a condition method.
CaseQuery.IStringColumnFilterQuery	creatorUserDisplayName()	Prepares a where statement for the column CreatorUserDisplayName. Must be followed by a call to a condition method.
CaseQuery.IIntegerColumnFilterQuery	creatorUserId()	Deprecated, for removal: This API element is subject to removal in a future version. use creatorId() instead
CaseQuery.IStringColumnFilterQuery	creatorUserName()	Prepares a where statement for the column CreatorUserName. Must be followed by a call to a condition method.
CaseQuery.FilterLink	currentUserHasStarted()	Filters all cases the user of the current session has started.
CaseQuery.FilterLink	currentUserIsInvolved()	Filters all cases the current session user is involved in.
CaseQuery.FilterLink	currentUserIsOwner()	Filters all cases the current user is owner of.
CaseQuery.FilterLink	currentUserOrHisRolesAreInvolved()	Filters all cases the current user or any of his roles are involved in.
CaseQuery.INumberColumnFilterQuery	customDecimalField1()	Deprecated. use customField().numberField("CustomDecimalField1") instead
CaseQuery.INumberColumnFilterQuery	customDecimalField2()	Deprecated. use customField().numberField("CustomDecimalField2") instead
CaseQuery.INumberColumnFilterQuery	customDecimalField3()	Deprecated. use customField().numberField("CustomDecimalField3") instead
CaseQuery.INumberColumnFilterQuery	customDecimalField4()	Deprecated. use customField().numberField("CustomDecimalField4") instead
CaseQuery.INumberColumnFilterQuery	customDecimalField5()	Deprecated. use customField().numberField("CustomDecimalField5") instead
CaseQuery.ICustomFieldFilterQuery	customField()	Prepares a where statement for a custom field. Must be followed by a call to a field value type.
CaseQuery.IDateColumnFilterQuery	customTimestampField1()	Deprecated. use customField().timestampField("CustomTimestampField1") instead
CaseQuery.IDateColumnFilterQuery	customTimestampField2()	Deprecated. use customField().timestampField("CustomTimestampField2") instead
CaseQuery.IDateColumnFilterQuery	customTimestampField3()	Deprecated. use customField().timestampField("CustomTimestampField3") instead
CaseQuery.IDateColumnFilterQuery	customTimestampField4()	Deprecated. use customField().timestampField("CustomTimestampField4") instead
CaseQuery.IDateColumnFilterQuery	customTimestampField5()	Deprecated. use customField().timestampField("CustomTimestampField5") instead
CaseQuery.IStringColumnFilterQuery	customVarCharField1()	Deprecated. use customField().stringField("CustomVarCharField1") instead
CaseQuery.IStringColumnFilterQuery	customVarCharField2()	Deprecated. use customField().stringField("CustomVarCharField2") instead
CaseQuery.IStringColumnFilterQuery	customVarCharField3()	Deprecated. use customField().stringField("CustomVarCharField3") instead
CaseQuery.IStringColumnFilterQuery	customVarCharField4()	Deprecated. use customField().stringField("CustomVarCharField4") instead
CaseQuery.IStringColumnFilterQuery	customVarCharField5()	Deprecated. use customField().stringField("CustomVarCharField5") instead
CaseQuery.IClobColumnFilterQuery	description()	Prepares a where statement for the column Description. Must be followed by a call to a condition method.
CaseQuery.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.
CaseQuery.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.
CaseQuery.IDateColumnFilterQuery	endTimestamp()	Prepares a where statement for the column EndTimestamp. Must be followed by a call to a condition method.
CaseQuery.FilterLink	hasStarted(ISecurityMember member)	Filters all cases the given security member has started.
CaseQuery.FilterLink	hasStarted(String memberName, String applicationName)	Filters all cases where the security member with given member name (user or role) in the given application has started.
CaseQuery.FilterLink	isBusinessCase()	Selects only cases that are business cases. For performance reasons you should prefer CaseQuery.businessCases() to restrict your query to business cases. Example: Get all business cases
CaseQuery.FilterLink	isInvolved(ISecurityMember member)	Filters all cases the security member is involved in. If the given security member is a user, this method is equivalent to userIsInvolved(IUser). If the given security member is a role, this method is equivalent to roleIsInvolved(IRole).
CaseQuery.FilterLink	isInvolved(String memberName, String applicationName)	Filters all cases 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.
CaseQuery.FilterLink	isNotBusinessCase()	Selects only cases that are not business cases (e.g. sub cases). For performance reasons you should prefer CaseQuery.subCases() to restrict your query to sub cases (technical cases). Example: Get all sub cases
CaseQuery.FilterLink	isOwner(ISecurityMember member)	Filters all cases the security member is owner of.
CaseQuery.FilterLink	isOwner(String memberName, String applicationName)	Filters all cases the member of the application is owner of.
CaseQuery.IIntegerColumnFilterQuery	languageId()	Prepares a where statement for the column LanguageId. Must be followed by a call to a condition method.
CaseQuery.IDateColumnFilterQuery	modifiedTimestamp()	Prepares a where statement for the column ModifiedTimestamp. Must be followed by a call to a condition method.
CaseQuery.IStringColumnFilterQuery	name()	Prepares a where statement for the column Name. Must be followed by a call to a condition method.
CaseQuery.FilterQuery	not(CaseQuery 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.
CaseQuery.IStringColumnFilterQuery	ownerDisplayName()	Prepares a where statement for the column OwnerDisplayName. Must be followed by a call to a condition method.
CaseQuery.IStringColumnFilterQuery	ownerId()	Prepares a where statement for the column OwnerId. Must be followed by a call to a condition method.
CaseQuery.IStringColumnFilterQuery	ownerName()	Prepares a where statement for the column OwnerName. Must be followed by a call to a condition method.
CaseQuery.IIntegerColumnFilterQuery	ownerRoleId()	Deprecated, for removal: This API element is subject to removal in a future version. use ownerId() instead
CaseQuery.IIntegerColumnFilterQuery	ownerUserId()	Deprecated, for removal: This API element is subject to removal in a future version. use ownerId() instead
CaseQuery.IWorkflowPriorityFilterQuery	priority()	Prepares a where statement for the column Priority. Must be followed by a call to a condition method.
CaseQuery.IStringColumnFilterQuery	processCategoryCode()	Deprecated. use customField().stringField("ProcessCategoryCode") instead
CaseQuery.IStringColumnFilterQuery	processCategoryName()	Deprecated. use customField().stringField("ProcessCategoryName") instead
CaseQuery.IStringColumnFilterQuery	processCode()	Deprecated. use customField().stringField("ProcessCode") instead
CaseQuery.IIntegerColumnFilterQuery	processModelId()	Prepares a where statement for the column ProcessModelId. Must be followed by a call to a condition method.
CaseQuery.IStringColumnFilterQuery	processName()	Deprecated. use customField().stringField("ProcessName") instead
CaseQuery.FilterLink	roleCanWorkOn(IRole role)	Filters all cases where the role can work on at least one task.
CaseQuery.FilterLink	roleIsInvolved(IRole role)	Filters all cases the role is involved in.
CaseQuery.FilterLink	roleIsInvolved(String roleName, String applicationName)	Filters all cases where the role with given name in the given application is involved in.
CaseQuery.IIntegerColumnFilterQuery	securitySystemId()	Prepares a where statement for the column SecuritySystemId. Must be followed by a call to a condition method.
CaseQuery.IStringColumnFilterQuery	stage()	Prepares a where statement for the column Stage. Must be followed by a call to a condition method.
CaseQuery.IDateColumnFilterQuery	startTimestamp()	Prepares a where statement for the column StartTimestamp. Must be followed by a call to a condition method.
CaseQuery.ICaseStateFilterQuery	state()	Prepares a where statement for the column State. Must be followed by a call to a condition method.
CaseQuery.IStringColumnFilterQuery	subTypeCode()	Deprecated. use customField().stringField("SubTypeCode") instead
CaseQuery.IStringColumnFilterQuery	subTypeName()	Deprecated. use customField().stringField("SubTypeName") instead
CaseQuery.FilterLink	tasks(TaskQuery taskQuery)	Adds an expression to the where clause that selects those cases that have at least one matching task for the given taskQuery.
CaseQuery.IIntegerColumnFilterQuery	taskStartId()	Prepares a where statement for the column TaskStartId. Must be followed by a call to a condition method.
CaseQuery.FilterLink	triggeredByTasks(TaskQuery taskQuery)	Adds an expression to the where clause that selects those cases that have been created with a Trigger process element by tasks which matches the given taskQuery.
CaseQuery.IStringColumnFilterQuery	typeCode()	Deprecated. use customField().stringField("TypeCode") instead
CaseQuery.IStringColumnFilterQuery	typeName()	Deprecated. use customField().stringField("TypeName") instead
CaseQuery.FilterLink	userCanWorkOn(IUser user)	Filters all cases where the user can work on at least one task.
CaseQuery.FilterLink	userIsInvolved(IUser user)	Filters all cases the user is involved in.
CaseQuery.FilterLink	userIsInvolved(String userName, String applicationName)	Filters all cases where the user with given name in the given application is involved in.
CaseQuery.FilterLink	userOrHisRolesAreInvolved(IUser user)	Filters all cases the user or any of his roles are involved in.
CaseQuery.FilterLink	userOrHisRolesAreInvolved(String userName, String applicationName)	Filters all cases the user or any of his roles are involved in.
CaseQuery.IUUIDColumnFilterQuery	uuid()	Prepares a where statement for the column UUID. Must be followed by a call to a condition method.
CaseQuery.INumberColumnFilterQuery	workingTime()	Prepares a where statement for the column WorkingTime. Must be followed by a call to a condition method.

Method Details

isBusinessCase

CaseQuery.FilterLink isBusinessCase()

Selects only cases that are business cases.

For performance reasons you should prefer CaseQuery.businessCases() to restrict your query to business cases.

Example:
Get all business cases

 import ch.ivyteam.ivy.workflow.ICase;
 import ch.ivyteam.ivy.workflow.query.CaseQuery;

 CaseQuery query = CaseQuery.create().where().isBusinessCase();
 List<ICase> businessCases = ivy.wf.getCaseQueryExecutor().getResults(query);
 

Returns:

the query for further composition

See Also:

• CaseQuery.businessCases()

API:

This public API is available in Java.

isNotBusinessCase

CaseQuery.FilterLink isNotBusinessCase()

Selects only cases that are not business cases (e.g. sub cases).

For performance reasons you should prefer CaseQuery.subCases() to restrict your query to sub cases (technical cases).

Example:
Get all sub cases

 import ch.ivyteam.ivy.workflow.ICase;
 import ch.ivyteam.ivy.workflow.query.CaseQuery;

 CaseQuery query = CaseQuery.create().where().isNotBusinessCase();
 List<ICase> subCases = ivy.wf.getCaseQueryExecutor().getResults(query);
 

Returns:

the query for further composition

See Also:

• CaseQuery.subCases()

API:

This public API is available in Java.

tasks

CaseQuery.FilterLink tasks(TaskQuery taskQuery)

Adds an expression to the where clause that selects those cases that have at least one matching task for the given taskQuery.

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

Example:
Get all cases that have tasks in state PARKED

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

 CaseQuery query = CaseQuery.businessCases().where().tasks(TaskQuery.create().where().state().isEqual(TaskState.PARKED));
 List<ICase> casesWithParkedTasks = ivy.wf.getCaseQueryExecutor().getResults(query);
 

Parameters:

taskQuery - task query with where clause to filter the tasks

Returns:

the where query builder, for further building

Throws:

IllegalArgumentException - If the given taskQuery is null

API:

This public API is available in Java.

triggeredByTasks

CaseQuery.FilterLink triggeredByTasks(TaskQuery taskQuery)

Adds an expression to the where clause that selects those cases that have been created with a Trigger process element by tasks which matches the given taskQuery.

Cases can be triggered by tasks by using the Trigger process element.

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

Example:
Get all cases that were created by tasks with kind code "Order"

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

 CaseQuery query = CaseQuery.businessCases().where().triggeredByTasks(TaskQuery.create().where().kindCode().isEqual("Order"));
 List<ICase> casesCreatedByTasksOfProcessOrder = ivy.wf.getCaseQueryExecutor().getResults(query);
 

Parameters:

taskQuery - task query with where clause to filter the tasks

Returns:

the where query builder, for further building

Throws:

IllegalArgumentException - If the given taskQuery is null

API:

This public API is available in Java.

isInvolved

CaseQuery.FilterLink isInvolved(ISecurityMember member)

Filters all cases the security member is involved in.

• If the given security member is a user, this method is equivalent to userIsInvolved(IUser).
• If the given security member is a role, this method is equivalent to roleIsInvolved(IRole).

Parameters:

member -

Returns:

the query for further composition

Throws:

IllegalArgumentException - If the given member is null

See Also:

• TaskQuery.IFilterableColumns.userIsInvolved(IUser)
• TaskQuery.IFilterableColumns.userIsInvolved(String, String)
• isInvolved(String, String)
• currentUserIsInvolved()
• userIsInvolved(IUser)
• userIsInvolved(String, String)
• roleIsInvolved(IRole)
• roleIsInvolved(String, String)

API:

This public API is available in Java.

isInvolved

CaseQuery.FilterLink isInvolved(String memberName,
 String applicationName)

Filters all cases 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 'Joe' is involved in:

 import ch.ivyteam.ivy.workflow.ICase;
 import ch.ivyteam.ivy.workflow.query.CaseQuery;

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

 List<ICase> cases = ivy.wf.getCaseQueryExecutor().getResults(query);
 

Parameters:

memberName - e.g. a role "TopManagementRole", e.g. a user must be prefixed with # "#Joe"

applicationName - e.g. "MyApplication"

Returns:

the query for further composition

See Also:

• TaskQuery.IFilterableColumns.userIsInvolved(IUser)
• TaskQuery.IFilterableColumns.userIsInvolved(String, String)
• isInvolved(ISecurityMember)
• currentUserIsInvolved()
• userIsInvolved(IUser)
• userIsInvolved(String, String)
• roleIsInvolved(IRole)
• roleIsInvolved(String, String)

API:

This public API is available in Java.

canWorkOn

CaseQuery.FilterLink canWorkOn(ISecurityMember member)

Filters all cases where the security member (user or role) can work on at least one task.

Parameters:

member - the security member (user or role)

Returns:

the query for further composition

Throws:

IllegalArgumentException - If the given member is null

Since:

6.7

See Also:

• canWorkOn(IUserToken)

API:

This public API is available in Java.

canWorkOn

CaseQuery.FilterLink canWorkOn(IUserToken userToken)

Filters all cases where the user token can work on at least one task.

Parameters:

userToken - the user token

Returns:

the query for further composition

Throws:

IllegalArgumentException - If the given member is null

Since:

6.7

See Also:

• canWorkOn(ISecurityMember)

API:

This public API is available in Java.

roleIsInvolved

CaseQuery.FilterLink roleIsInvolved(IRole role)

Filters all cases the role is involved in. A role is involved in a case if the role is involved in at least one task of the case.

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.CaseQuery;
 import ch.ivyteam.ivy.workflow.ITask;
 import IRole;

 IRole role = ivy.session.getSecurityContext().findRole("Admin");
 CaseQuery query = CaseQuery.businessCases().where().roleIsInvolved(role);
 List<ICase> userInvolvedCases = ivy.wf.getCaseQueryExecutor().getResults(query);

Parameters:

role -

Returns:

the query for further composition

Throws:

IllegalArgumentException - If the given role is null

See Also:

• TaskQuery.IFilterableColumns.userIsInvolved(IUser)
• TaskQuery.IFilterableColumns.userIsInvolved(String, String)
• isInvolved(ISecurityMember)
• isInvolved(String, String)
• currentUserIsInvolved()
• userIsInvolved(IUser)
• userIsInvolved(String, String)
• roleIsInvolved(String, String)

API:

This public API is available in Java.

roleIsInvolved

CaseQuery.FilterLink roleIsInvolved(String roleName,
 String applicationName)

Filters all cases 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 Also:

• TaskQuery.IFilterableColumns.userIsInvolved(IUser)
• TaskQuery.IFilterableColumns.userIsInvolved(String, String)
• isInvolved(ISecurityMember)
• isInvolved(String, String)
• currentUserIsInvolved()
• userIsInvolved(IUser)
• userIsInvolved(String, String)
• roleIsInvolved(IRole)

API:

This public API is available in Java.

userIsInvolved

CaseQuery.FilterLink userIsInvolved(IUser user)

Filters all cases the user is involved in. A user is involved in a case if

• the user is the creator of the case

• the user is involved in at least one task of the case
  The 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
  The 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.CaseQuery;
 import ch.ivyteam.ivy.workflow.ICase;
 import IUser;

 IUser user = ivy.session.getSessionUser();
 CaseQuery query = CaseQuery.businessCases().where().userIsInvolved(user);
 List<ICase> userInvolvedCases = ivy.wf.getCaseQueryExecutor().getResults(query);

Parameters:

user -

Returns:

the query for further composition

Throws:

IllegalArgumentException - If the given user is null

See Also:

• TaskQuery.IFilterableColumns.userIsInvolved(IUser)
• TaskQuery.IFilterableColumns.userIsInvolved(String, String)
• isInvolved(ISecurityMember)
• isInvolved(String, String)
• currentUserIsInvolved()
• userIsInvolved(String, String)
• roleIsInvolved(IRole)
• roleIsInvolved(String, String)

API:

This public API is available in Java.

userIsInvolved

CaseQuery.FilterLink userIsInvolved(String userName,
 String applicationName)

Filters all cases 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, appName)

Parameters:

userName - e.g. "Joe"

applicationName -

Returns:

the query for further composition

See Also:

• TaskQuery.IFilterableColumns.userIsInvolved(IUser)
• TaskQuery.IFilterableColumns.userIsInvolved(String, String)
• isInvolved(ISecurityMember)
• isInvolved(String, String)
• currentUserIsInvolved()
• userIsInvolved(IUser)
• roleIsInvolved(IRole)
• roleIsInvolved(String, String)

API:

This public API is available in Java.

userOrHisRolesAreInvolved

CaseQuery.FilterLink userOrHisRolesAreInvolved(IUser user)

Filters all cases the user or any of his roles are involved in. See userIsInvolved(IUser) for a description of when a user is involved in a case and roleIsInvolved(IRole) for when a role is involved in a case.

Example:

 import ch.ivyteam.ivy.workflow.query.CaseQuery;
 import ch.ivyteam.ivy.workflow.ICase;
 import IUser;

 IUser user = ivy.session.getSessionUser();
 CaseQuery query = CaseQuery.businessCases().where().userOrHisRolesAreInvolved(user);
 List<ICase> userInvolvedCases = ivy.wf.getCaseQueryExecutor().getResults(query);

Parameters:

user -

Returns:

the query for further composition

Throws:

IllegalArgumentException - If the given user is null

Since:

11.4

See Also:

• userOrHisRolesAreInvolved(String, String)
• currentUserOrHisRolesAreInvolved()
• isInvolved(ISecurityMember)
• isInvolved(String, String)
• currentUserIsInvolved()
• userIsInvolved(IUser)
• userIsInvolved(String, String)
• roleIsInvolved(IRole)
• roleIsInvolved(String, String)
• TaskQuery.IFilterableColumns.userOrHisRolesAreInvolved(IUser)
• TaskQuery.IFilterableColumns.userOrHisRolesAreInvolved(String, String)
• TaskQuery.IFilterableColumns.currentUserOrHisRolesAreInvolved()

API:

This public API is available in Java.

userOrHisRolesAreInvolved

CaseQuery.FilterLink userOrHisRolesAreInvolved(String userName,
 String applicationName)

Filters all cases the user or any of his roles are involved in. See userIsInvolved(IUser) for a description of when a user is involved in a case and roleIsInvolved(IRole) for when a role is involved in a case.

Example:

 import ch.ivyteam.ivy.workflow.query.CaseQuery;
 import ch.ivyteam.ivy.workflow.ICase;
 import IUser;

 CaseQuery query = CaseQuery.businessCases().where().userOrHisRolesAreInvolved("Joe", "CRM");
 List<ICase> userInvolvedCases = ivy.wf.getCaseQueryExecutor().getResults(query);

Parameters:

userName - e.g. "Joe"

applicationName -

Returns:

the query for further composition

Throws:

IllegalArgumentException - If the given user is null

Since:

11.4

See Also:

• userOrHisRolesAreInvolved(IUser)
• currentUserOrHisRolesAreInvolved()
• isInvolved(ISecurityMember)
• isInvolved(String, String)
• currentUserIsInvolved()
• userIsInvolved(IUser)
• userIsInvolved(String, String)
• roleIsInvolved(IRole)
• roleIsInvolved(String, String)
• TaskQuery.IFilterableColumns.userIsInvolved(String, String)
• TaskQuery.IFilterableColumns.userIsInvolved(IUser)
• TaskQuery.IFilterableColumns.currentUserIsInvolved()

API:

This public API is available in Java.

currentUserIsInvolved

CaseQuery.FilterLink currentUserIsInvolved()

Filters all cases the current session user is involved in. The current session user is involved in a case if

• the current session user is the creator of the case

• the current session user is involved in at least one task of the case
  The current session user is involved in a task if

  • the current session user could work on the task
  • the current session user is working at the task right now
  • the current session user has completed the task
  The current session user is not involved in a task if
  • the current session 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 current session user can work on the task but it is delayed

Example:

 import ch.ivyteam.ivy.workflow.query.CaseQuery;
 import ch.ivyteam.ivy.workflow.ICase;

 CaseQuery query = CaseQuery.businessCases().where().currentUserIsInvolved();
 List<ICase> sessionInvolvedCases = ivy.wf.getCaseQueryExecutor().getResults(query);

Returns:

the query for further composition

Throws:

IllegalStateException - If there is no current session available

See Also:

• TaskQuery.IFilterableColumns.userIsInvolved(IUser)
• TaskQuery.IFilterableColumns.userIsInvolved(String, String)
• isInvolved(ISecurityMember)
• isInvolved(String, String)
• userIsInvolved(IUser)
• userIsInvolved(String, String)
• roleIsInvolved(IRole)
• roleIsInvolved(String, String)

API:

This public API is available in Java.

currentUserOrHisRolesAreInvolved

CaseQuery.FilterLink currentUserOrHisRolesAreInvolved()

Filters all cases the current user or any of his roles are involved in. See currentUserIsInvolved() for a description of when the current user is involved in a case and roleIsInvolved(IRole) for when a role is involved in a case.

Example:

 import ch.ivyteam.ivy.workflow.query.CaseQuery;
 import ch.ivyteam.ivy.workflow.ICase;
 import IUser;

 IUser user = ivy.session.getSessionUser();
 CaseQuery query = CaseQuery.businessCases().where().currentUserOrHisRolesAreInvolved();
 List<ICase> userInvolvedCases = ivy.wf.getCaseQueryExecutor().getResults(query);

Returns:

the query for further composition

Throws:

IllegalArgumentException - If the given user is null

Since:

11.4

See Also:

• userOrHisRolesAreInvolved(IUser)
• userOrHisRolesAreInvolved(String, String)
• isInvolved(ISecurityMember)
• isInvolved(String, String)
• currentUserIsInvolved()
• userIsInvolved(IUser)
• userIsInvolved(String, String)
• roleIsInvolved(IRole)
• roleIsInvolved(String, String)
• TaskQuery.IFilterableColumns.currentUserOrHisRolesAreInvolved()
• TaskQuery.IFilterableColumns.userOrHisRolesAreInvolved(IUser)
• TaskQuery.IFilterableColumns.userOrHisRolesAreInvolved(String, String)

API:

This public API is available in Java.

userCanWorkOn

CaseQuery.FilterLink userCanWorkOn(IUser user)

Filters all cases where the user can work on at least one task.

Parameters:

user -

Returns:

the query for further composition

Throws:

IllegalArgumentException - If the given member is null

Since:

6.7

API:

This public API is available in Java.

roleCanWorkOn

CaseQuery.FilterLink roleCanWorkOn(IRole role)

Filters all cases where the role can work on at least one task.

Parameters:

role -

Returns:

the query for further composition

Throws:

IllegalArgumentException - If the given member is null

Since:

6.7

API:

This public API is available in Java.

hasStarted

CaseQuery.FilterLink hasStarted(ISecurityMember member)

Filters all cases the given security member has started. A role is considered to have started a case if the given role is allowed to start a new case at the same process start the case was started on.

Example:

 import ch.ivyteam.ivy.workflow.query.CaseQuery;
 import ch.ivyteam.ivy.workflow.ICase;
 import IUser;

 IUser user = ivy.wf.getSecurityContext().findUser("Somebody");
 CaseQuery query = CaseQuery.businessCases().where().hasStarted(user);
 List<ICase> casesStartedByUser = ivy.wf.getCaseQueryExecutor().getResults(query);

Parameters:

member -

Returns:

the query for further composition

Throws:

IllegalArgumentException - If the given member is null

See Also:

• currentUserHasStarted()
• hasStarted(String, String)

API:

This public API is available in Java.

hasStarted

CaseQuery.FilterLink hasStarted(String memberName,
 String applicationName)

Filters all cases where the security member with given member name (user or role) in the given application has started.

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

Get all tasks where the current user or the user 'Joe' has started:

 import ch.ivyteam.ivy.workflow.ICase;
 import ch.ivyteam.ivy.workflow.query.CaseQuery;

 CaseQuery query = CaseQuery.businessCases()
   .where().hasStarted("#Joe", "MyApp") // note: to convert a user name to a member name a '#' is added as prefix
      .or().hasStarted(ivy.session.getSessionUser().getMemberName(), "MyApp");

 List<ICase> cases = ivy.wf.getCaseQueryExecutor().getResults(query);
 

Parameters:

memberName - e.g. a role "TopManagementRole", e.g. a user must be prefixed with # "#Joe"

applicationName - e.g. "MyApplication"

Returns:

the query for further composition

See Also:

• currentUserHasStarted()
• hasStarted(ISecurityMember)

API:

This public API is available in Java.

currentUserHasStarted

CaseQuery.FilterLink currentUserHasStarted()

Filters all cases the user of the current session has started.

Example:

 import ch.ivyteam.ivy.workflow.query.CaseQuery;
 import ch.ivyteam.ivy.workflow.ICase;

 CaseQuery query = CaseQuery.businessCases().where().currentUserHasStarted();
 List<ICase> casesStartedByUser = ivy.wf.getCaseQueryExecutor().getResults(query);

Returns:

the query for further composition

Throws:

IllegalStateException - If there is no current session available

See Also:

• hasStarted(ISecurityMember)
• hasStarted(String, String)

API:

This public API is available in Java.

isOwner

CaseQuery.FilterLink isOwner(ISecurityMember member)

Filters all cases the security member is owner of.

Example:

 import ch.ivyteam.ivy.workflow.query.CaseQuery;
 import ch.ivyteam.ivy.workflow.ICase;

 CaseQuery query = CaseQuery.businessCases().where().isOwner(ivy.session.getSessionUser());
 List<ICase> casesCurrentUserIsOwnerOf = ivy.wf.getCaseQueryExecutor().getResults(query);

Parameters:

member - can not be null

Returns:

the query for further composition

See Also:

• ICase.owners()
• isOwner(String, String)
• currentUserIsOwner()

API:

This public API is available in Java.

currentUserIsOwner

CaseQuery.FilterLink currentUserIsOwner()

Filters all cases the current user is owner of.

Example:

 import ch.ivyteam.ivy.workflow.query.CaseQuery;
 import ch.ivyteam.ivy.workflow.ICase;

 CaseQuery query = CaseQuery.businessCases().where().currentUserIsOwner();
 List<ICase> casesCurrentUserIsOwnerOf = ivy.wf.getCaseQueryExecutor().getResults(query);

Returns:

the query for further composition

See Also:

• ICase.owners()
• isOwner(ISecurityMember)
• isOwner(String, String)

API:

This public API is available in Java.

isOwner

CaseQuery.FilterLink isOwner(String memberName,
 String applicationName)

Filters all cases the member of the application is owner of.

Example:

 import ch.ivyteam.ivy.workflow.query.CaseQuery;
 import ch.ivyteam.ivy.workflow.ICase;

 CaseQuery query = CaseQuery.businessCases().where().isOwner("#Joe", "myApplication"); // note: to convert a user name to a member name a '#' is added as prefix
 List<ICase> casesCurrentUserIsOwnerOf = ivy.wf.getCaseQueryExecutor().getResults(query);

Parameters:

memberName - e.g. a role "TopManagementRole", e.g. a user must be prefixed with # "#Joe"

applicationName - e.g. "MyApplication"

Returns:

the query for further composition

See Also:

• ICase.owners()
• isOwner(ISecurityMember)
• currentUserIsOwner()

API:

This public API is available in Java.

businessCalendarId

@Deprecated(since="7.4",
            forRemoval=true)
CaseQuery.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.

customField

CaseQuery.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.ICase;
 import ch.ivyteam.ivy.workflow.query.CaseQuery;

 CaseQuery query = CaseQuery.businessCases().where().customField().stringField("myCustomField").isEqualTo("valueToFind")";
 List<ICase> casesWithMatchingField = ivy.wf.getCaseQueryExecutor().getResults(query);

Returns:

the query for further composition

API:

This public API is available in Java.

additionalProperty

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

businessObjectFolderId

@Deprecated
CaseQuery.IStringColumnFilterQuery businessObjectFolderId()

Deprecated.

use customField().stringField("BusinessObjectFolderId") instead

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

Returns:

query for further composition

API:

This public API is available in Java.

businessObjectDocDbCode

@Deprecated
CaseQuery.IStringColumnFilterQuery businessObjectDocDbCode()

Deprecated.

use customField().stringField("BusinessObjectDocumentDbCode") instead

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

Returns:

query for further composition

API:

This public API is available in Java.

businessMainContactDocDbCode

@Deprecated
CaseQuery.IStringColumnFilterQuery businessMainContactDocDbCode()

Deprecated.

use customField().stringField("BusinessMainContactDocumentDbCode") instead

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

Returns:

query for further composition

API:

This public API is available in Java.

businessMainContactFolderId

@Deprecated
CaseQuery.IStringColumnFilterQuery businessMainContactFolderId()

Deprecated.

use customField().stringField("BusinessMainContactFolderId") instead

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

Returns:

query for further composition

API:

This public API is available in Java.

businessPriority

@Deprecated
CaseQuery.IStringColumnFilterQuery businessPriority()

Deprecated.

use customField().stringField("BusinessPriority") instead

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

Returns:

query for further composition

API:

This public API is available in Java.

businessMainContactType

@Deprecated
CaseQuery.IStringColumnFilterQuery businessMainContactType()

Deprecated.

use customField().stringField("BusinessMainContactType") instead

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

Returns:

query for further composition

API:

This public API is available in Java.

businessCorrespondentId

@Deprecated
CaseQuery.IIntegerColumnFilterQuery businessCorrespondentId()

Deprecated.

use customField().numberField("BusinessCorrespondentId") instead

Prepares a where statement for the custom field "BusinessCorrespondentId".
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
CaseQuery.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
CaseQuery.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
CaseQuery.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
CaseQuery.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
CaseQuery.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
CaseQuery.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
CaseQuery.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
CaseQuery.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.

creatorUserId

@Deprecated(since="9.1",
            forRemoval=true)
CaseQuery.IIntegerColumnFilterQuery creatorUserId()

Deprecated, for removal: This API element is subject to removal in a future version.

use creatorId() instead

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

Returns:

query for further composition

API:

This public API is available in Java.

ownerRoleId

@Deprecated(since="9.1",
            forRemoval=true)
CaseQuery.IIntegerColumnFilterQuery ownerRoleId()

Deprecated, for removal: This API element is subject to removal in a future version.

use ownerId() instead

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

Returns:

query for further composition

API:

This public API is available in Java.

ownerUserId

@Deprecated(since="9.1",
            forRemoval=true)
CaseQuery.IIntegerColumnFilterQuery ownerUserId()

Deprecated, for removal: This API element is subject to removal in a future version.

use ownerId() instead

Prepares a where statement for the legacy field OwnerUserId.
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)
CaseQuery.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)
CaseQuery.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

CaseQuery.FilterQuery not(CaseQuery 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:

CaseQuery subQuery = CaseQuery.businessCases().where()
      .customVarCharField1().equals("a").or()
      .customVarCharField2().equals("b")
CaseQuery query = CaseQuery.businessCases().where()
      .not(subQuery)

Corresponds to SQL:

SELECT * FROM IWA_IWA_Case
  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.

caseId

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

uuid

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

businessCaseId

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

securitySystemId

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

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

processModelId

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

taskStartId

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

activatorId

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

creatorId

CaseQuery.IStringColumnFilterQuery creatorId()

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

Returns:

query for further composition

API:

This public API is available in Java.

creatorUserName

CaseQuery.IStringColumnFilterQuery creatorUserName()

Prepares a where statement for the column CreatorUserName.
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 Creator.

Returns:

query for further composition

API:

This public API is available in Java.

creatorUserDisplayName

CaseQuery.IStringColumnFilterQuery creatorUserDisplayName()

Prepares a where statement for the column CreatorUserDisplayName.
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 Creator.

Returns:

query for further composition

API:

This public API is available in Java.

creatorTaskId

CaseQuery.IIntegerColumnFilterQuery creatorTaskId()

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

Returns:

query for further composition

API:

This public API is available in Java.

name

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

Returns:

query for further composition

API:

This public API is available in Java.

description

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

Returns:

query for further composition

API:

This public API is available in Java.

startTimestamp

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

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

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

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

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

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

state

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

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

priority

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

stage

CaseQuery.IStringColumnFilterQuery stage()

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

Returns:

query for further composition

API:

This public API is available in Java.

ownerId

CaseQuery.IStringColumnFilterQuery ownerId()

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

Returns:

query for further composition

API:

This public API is available in Java.

ownerName

CaseQuery.IStringColumnFilterQuery ownerName()

Prepares a where statement for the column OwnerName.
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 Owner.

Returns:

query for further composition

API:

This public API is available in Java.

ownerDisplayName

CaseQuery.IStringColumnFilterQuery ownerDisplayName()

Prepares a where statement for the column OwnerDisplayName.
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 Owner.

Returns:

query for further composition

API:

This public API is available in Java.

category

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

languageId

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

Returns:

query for further composition

API:

This public API is available in Java.