Uses of Class
ch.ivyteam.ivy.workflow.query.CaseQuery.FilterLink
Packages that use CaseQuery.FilterLink
-
Uses of CaseQuery.FilterLink in ch.ivyteam.ivy.workflow.query
Subclasses of CaseQuery.FilterLink in ch.ivyteam.ivy.workflow.queryMethods in ch.ivyteam.ivy.workflow.query that return CaseQuery.FilterLinkModifier and TypeMethodDescriptionAdds and AND statement with the given filtersubQuery.CaseQuery.FilterLink.andOverall(CaseQuery subQuery) CaseQuery.IFilterLink.andOverall(CaseQuery subQuery) Adds and AND statement with the given filtersubQueryto the wholewherecondition configured before.CaseQuery.FilterQuery.canWorkOn(ISecurityMember member) CaseQuery.FilterQuery.canWorkOn(IUserToken userToken) CaseQuery.IFilterableColumns.canWorkOn(ISecurityMember member) Filters all cases where the security member (user or role) can work on at least one task.CaseQuery.IFilterableColumns.canWorkOn(IUserToken userToken) Filters all cases where the user token can work on at least one task.CaseQuery.IFilterableColumns.currentUserHasStarted()Filters all cases the user of the current session has started.CaseQuery.FilterQuery.currentUserIsInvolved()CaseQuery.IFilterableColumns.currentUserIsInvolved()Filters all cases the current session user is involved in.CaseQuery.IFilterableColumns.currentUserIsOwner()Filters all cases the current user is owner of.CaseQuery.FilterQuery.currentUserOrHisRolesAreInvolved()CaseQuery.IFilterableColumns.currentUserOrHisRolesAreInvolved()Filters all cases the current user or any of his roles are involved in.CaseQuery.FilterQuery.hasStarted(String memberName, String applicationName) CaseQuery.IFilterableColumns.hasStarted(ISecurityMember member) Filters all cases the given security member has started.CaseQuery.IFilterableColumns.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.IBoolFilterQuery.is(boolean value) CaseQuery.IFilterableColumns.isBusinessCase()Selects only cases that arebusiness cases.
For performance reasons you should preferCaseQuery.businessCases()to restrict your query to business cases.
Example:
Get all business casesCaseQuery.ICaseBusinessStateFilterQuery.isEqual(CaseBusinessState value) Adds a filter condition that selects rows with the givenvalue.Adds a filter condition that selects rows with the givenvalue.Adds a filter condition that selects rows with the givenvalue.CaseQuery.IIntegerColumnFilterQuery.isEqual(int value) Adds a filter condition that selects rows with the givenvalue.CaseQuery.IIntegerColumnFilterQuery.isEqual(long value) Adds a filter condition that selects rows with the givenvalue.Adds a filter condition that selects rows with the givenvalue.Adds a filter condition that selects rows with the givenvalue.Adds a filter condition that selects rows with the givenvalue.CaseQuery.IWorkflowPriorityFilterQuery.isEqual(WorkflowPriority value) Adds a filter condition that selects rows with the givenvalue.CaseQuery.IStringColumnFilterQuery.isEqualIgnoreCase(String value) Adds a filter condition that selects rows with the givenvalueignoring case.default CaseQuery.FilterLinkCaseQuery.IBoolFilterQuery.isFalse()CaseQuery.IDateColumnFilterQuery.isGreaterOrEqualThan(Date value) Adds a filter condition that selects rows that have values that are greater or equal than the givenvalue.CaseQuery.IIntegerColumnFilterQuery.isGreaterOrEqualThan(int value) Adds a filter condition that selects rows that have values that are greater or equal than the givenvalue.CaseQuery.IIntegerColumnFilterQuery.isGreaterOrEqualThan(long value) Adds a filter condition that selects rows that have values that are greater or equal than the givenvalue.CaseQuery.INumberColumnFilterQuery.isGreaterOrEqualThan(Number value) Adds a filter condition that selects rows that have values that are greater or equal than the givenvalue.CaseQuery.IStringColumnFilterQuery.isGreaterOrEqualThan(String value) Adds a filter condition that selects rows that have values that are greater than the givenvalue.CaseQuery.IDateColumnFilterQuery.isGreaterThan(Date value) Adds a filter condition that selects rows that have values that are greater than the givenvalue.CaseQuery.IIntegerColumnFilterQuery.isGreaterThan(int value) Adds a filter condition that selects rows that have values that are greater than the givenvalue.CaseQuery.IIntegerColumnFilterQuery.isGreaterThan(long value) Adds a filter condition that selects rows that have values that are greater than the givenvalue.CaseQuery.INumberColumnFilterQuery.isGreaterThan(Number value) Adds a filter condition that selects rows that have values that are greater than the givenvalue.CaseQuery.IStringColumnFilterQuery.isGreaterThan(String value) Adds a filter condition that selects rows that have values that are greater than the givenvalue.CaseQuery.ICaseBusinessStateFilterQuery.isIn(CaseBusinessState... values) Adds a filter condition that selects rows that have values that are in the given list ofvalues.CaseQuery.ICaseBusinessStateFilterQuery.isIn(List<CaseBusinessState> values) Adds a filter condition that selects rows that have values that are in the given list ofvalues.Adds a filter condition that selects rows that have values that are in the given list ofvalues.Adds a filter condition that selects rows that have values that are in the given list ofvalues.CaseQuery.IIntegerColumnFilterQuery.isIn(long... values) Adds a filter condition that selects rows that have values that are in the given list ofvalues.Adds a filter condition that selects rows that have values that are in the given list ofvalues.CaseQuery.IWorkflowPriorityFilterQuery.isIn(WorkflowPriority... values) Adds a filter condition that selects rows that have values that are in the given list ofvalues.CaseQuery.IWorkflowPriorityFilterQuery.isIn(List<WorkflowPriority> values) Adds a filter condition that selects rows that have values that are in the given list ofvalues.CaseQuery.FilterQuery.isInvolved(ISecurityMember member) CaseQuery.FilterQuery.isInvolved(String memberName, String applicationName) CaseQuery.IFilterableColumns.isInvolved(ISecurityMember member) Filters all cases the security member is involved in.
If the given security member is a user, this method is equivalent toCaseQuery.IFilterableColumns.userIsInvolved(IUser). If the given security member is a role, this method is equivalent toCaseQuery.IFilterableColumns.roleIsInvolved(IRole).CaseQuery.IFilterableColumns.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 methodisInvolved(ISecurityMember), this method evaluates the correspondingISecurityMemberon query execution.Adds a filter condition that selects rows that have values that are like the givenvalue.CaseQuery.IPatternColumnFilterQuery.isLikeIgnoreCase(String value) Adds a filter condition that selects rows that have values that are like the givenvalueignoring case.CaseQuery.IDateColumnFilterQuery.isLowerOrEqualThan(Date value) Adds a filter condition that selects rows that have values that are lower or equal than the givenvalue.CaseQuery.IIntegerColumnFilterQuery.isLowerOrEqualThan(int value) Adds a filter condition that selects rows that have values that are lower or equal than the givenvalue.CaseQuery.IIntegerColumnFilterQuery.isLowerOrEqualThan(long value) Adds a filter condition that selects rows that have values that are lower or equal than the givenvalue.CaseQuery.INumberColumnFilterQuery.isLowerOrEqualThan(Number value) Adds a filter condition that selects rows that have values that are lower or equal than the givenvalue.CaseQuery.IStringColumnFilterQuery.isLowerOrEqualThan(String value) Adds a filter condition that selects rows that have values that are lower or equal than the givenvalue.CaseQuery.IDateColumnFilterQuery.isLowerThan(Date value) Adds a filter condition that selects rows that have values that are lower than the givenvalue.CaseQuery.IIntegerColumnFilterQuery.isLowerThan(int value) Adds a filter condition that selects rows that have values that are lower than the givenvalue.CaseQuery.IIntegerColumnFilterQuery.isLowerThan(long value) Adds a filter condition that selects rows that have values that are lower than the givenvalue.CaseQuery.INumberColumnFilterQuery.isLowerThan(Number value) Adds a filter condition that selects rows that have values that are lower than the givenvalue.CaseQuery.IStringColumnFilterQuery.isLowerThan(String value) Adds a filter condition that selects rows that have values that are lower than the givenvalue.CaseQuery.IFilterableColumns.isNotBusinessCase()Selects only cases that are notbusiness cases(e.g.CaseQuery.ICaseBusinessStateFilterQuery.isNotEqual(CaseBusinessState value) Adds a filter condition that selects the rows that do not have the givenvalue.CaseQuery.ICaseStateFilterQuery.isNotEqual(CaseState value) Adds a filter condition that selects the rows that do not have the givenvalue.CaseQuery.IDateColumnFilterQuery.isNotEqual(Date value) Adds a filter condition that selects rows that do not have the givenvalue.CaseQuery.IIntegerColumnFilterQuery.isNotEqual(int value) Adds a filter condition that selects rows that do not have the givenvalue.CaseQuery.IIntegerColumnFilterQuery.isNotEqual(long value) Adds a filter condition that selects rows that do not have the givenvalue.CaseQuery.INumberColumnFilterQuery.isNotEqual(Number value) Adds a filter condition that selects rows that do not have the givenvalue.CaseQuery.IStringColumnFilterQuery.isNotEqual(String value) Adds a filter condition that selects rows that do not have the givenvalue.CaseQuery.IWorkflowPriorityFilterQuery.isNotEqual(WorkflowPriority value) Adds a filter condition that selects the rows that do not have the givenvalue.CaseQuery.IStringColumnFilterQuery.isNotEqualIgnoreCase(String value) Adds a filter condition that selects rows that do not have the givenvalueignoring case.Adds a filter condition that selects rows that have values that are not like the givenvalue.CaseQuery.IPatternColumnFilterQuery.isNotLikeIgnoreCase(String value) Adds a filter condition that selects rows that have values that are not like the givenvalueignoring case.CaseQuery.IColumnFilterQuery.isNotNull()Adds a filter condition that selects rows that do not have NULL values.CaseQuery.IColumnFilterQuery.isNull()Adds a filter condition that selects rows with NULL values.CaseQuery.IFilterableColumns.isOwner(ISecurityMember member) Filters all cases the security member is owner of.Filters all cases the member of the application is owner of.default CaseQuery.FilterLinkCaseQuery.IBoolFilterQuery.isTrue()Adds and OR statement with the given filtersubQuery.
Only thewherecondition of the givensubQueryis considered.CaseQuery.FilterQuery.roleCanWorkOn(IRole role) CaseQuery.IFilterableColumns.roleCanWorkOn(IRole role) Filters all cases where the role can work on at least one task.CaseQuery.FilterQuery.roleIsInvolved(IRole role) CaseQuery.FilterQuery.roleIsInvolved(String roleName, String applicationName) CaseQuery.IFilterableColumns.roleIsInvolved(IRole role) Filters all cases the role is involved in.CaseQuery.IFilterableColumns.roleIsInvolved(String roleName, String applicationName) Filters all cases where the role with given name in the given application is involved in.Adds an expression to the where clause that selects those cases that have at least one matching task for the giventaskQuery.CaseQuery.FilterQuery.triggeredByTasks(TaskQuery taskQuery) CaseQuery.IFilterableColumns.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 giventaskQuery.CaseQuery.FilterQuery.userCanWorkOn(IUser user) CaseQuery.IFilterableColumns.userCanWorkOn(IUser user) Filters all cases where the user can work on at least one task.CaseQuery.FilterQuery.userIsInvolved(IUser user) CaseQuery.FilterQuery.userIsInvolved(String userName, String applicationName) CaseQuery.IFilterableColumns.userIsInvolved(IUser user) Filters all cases the user is involved in.CaseQuery.IFilterableColumns.userIsInvolved(String userName, String applicationName) Filters all cases where the user with given name in the given application is involved in.CaseQuery.FilterQuery.userOrHisRolesAreInvolved(IUser user) CaseQuery.FilterQuery.userOrHisRolesAreInvolved(String userName, String applicationName) CaseQuery.IFilterableColumns.userOrHisRolesAreInvolved(IUser user) Filters all cases the user or any of his roles are involved in.CaseQuery.IFilterableColumns.userOrHisRolesAreInvolved(String userName, String applicationName) Filters all cases the user or any of his roles are involved in.