public enum OperatorId extends java.lang.Enum<OperatorId> implements ValueEnum
Criterion when specifying AdvancedCriteria. This list of operators indicates the set of operators built into Smart GWT DataSources, which can be used for both client and server-side filtering. Some operators offer case-insensitive versions, prefixed with a lower-case i, such as iContains. Note that such operators are intended for text-based searches and are not available to numeric or date fields (integer/float/date/datetime and derivatives), where there is no use for case.
You can extend the list of operators with DataSource.addSearchOperator().
| Enum Constant and Description |
|---|
AND all subcriteria (criterion.criteria) are true |
BETWEEN shortcut for "greaterThan" + "lessThan" + "and". |
BETWEEN_INCLUSIVE shortcut for "greaterOrEqual" + "lessOrEqual" + "and". |
CONTAINS Contains as sub-string (match case) |
CONTAINS_FIELD Contains as sub-string (match case) another field value (specify fieldName as criterion.value) |
CONTAINS_PATTERN GLOB matching using wildcards. |
ENDS_WITH Ends with (match case) |
ENDS_WITH_FIELD Ends with (match case) another field value (specify fieldName as criterion.value) |
ENDS_WITH_PATTERN GLOB matching using wildcards. |
EQUALS exactly equal to |
EQUALS_FIELD matches another field (match case, specify fieldName as criterion.value) |
GREATER_OR_EQUAL Greater than or equal to |
GREATER_OR_EQUAL_FIELD Greater than or equal to another field (specify fieldName as criterion.value) |
GREATER_THAN Greater than |
GREATER_THAN_FIELD Greater than another field (specify fieldName as criterion.value) |
IBETWEEN shortcut for "greaterThan" + "and" + "lessThan" (case insensitive) |
IBETWEEN_INCLUSIVE shortcut for "greaterOrEqual" + "and" + "lessOrEqual" (case insensitive) |
ICONTAINS Contains as sub-string (case insensitive) |
ICONTAINS_FIELD Contains as sub-string (case insensitive) another field value (specify fieldName as criterion.value) |
ICONTAINS_PATTERN GLOB matching using wildcards. |
IENDS_WITH Ends with (case insensitive) |
IENDS_WITH_FIELD Ends with (case insensitive) another field value (specify fieldName as criterion.value) |
IENDS_WITH_PATTERN GLOB matching using wildcards.Value is considered to meet the criterion if it ends with the pattern. |
IEQUALS exactly equal to, if case is disregarded |
IEQUALS_FIELD matches another field (case insensitive, specify fieldName as criterion.value) |
IMATCHES_PATTERN Basic GLOB matching using wildcards (case insensitive) (see DataSource.translatePatternOperators for more information on available patterns) |
IN_SET value is in a set of values. |
INOT_CONTAINS Does not contain as sub-string (case insensitive) |
INOT_CONTAINS_FIELD Does not contain as sub-string (case insensitive) another field value (specify fieldName as criterion.value) |
INOT_ENDS_WITH Does not end with (case insensitive) |
INOT_ENDS_WITH_FIELD Does not end with (case insensitive) another field value (specify fieldName as criterion.value) |
INOT_EQUAL not equal to, if case is disregarded |
INOT_EQUAL_FIELD does not match another field (case insensitive, specify fieldName as criterion.value) |
INOT_STARTS_WITH Does not start with (case insensitive) |
INOT_STARTS_WITH_FIELD Does not start with (case insensitive) another field value (specify fieldName as criterion.value) |
IREGEXP Regular expression match (case insensitive) - regexp operator limitations apply. |
IS_BLANK value is either null or the empty string. |
IS_NULL value is null |
ISTARTS_WITH Starts with (case insensitive) |
ISTARTS_WITH_FIELD Starts with (case insensitive) another field value (specify fieldName as criterion.value) |
ISTARTS_WITH_PATTERN GLOB matching using wildcards. |
LESS_OR_EQUAL Less than or equal to |
LESS_OR_EQUAL_FIELD Less than or equal to another field (specify fieldName as criterion.value) |
LESS_THAN Less than. |
LESS_THAN_FIELD Less than another field (specify fieldName as criterion.value) |
MATCHES_PATTERN Basic GLOB matching using wildcards (see DataSource.translatePatternOperators for more information on available patterns) |
NOT all subcriteria (criterion.criteria) are false |
NOT_BLANK value is neither null nor the empty string ("") |
NOT_CONTAINS Does not contain as sub-string (match case) |
NOT_CONTAINS_FIELD Does not contain as sub-string (match case) another field value (specify fieldName as criterion.value) |
NOT_ENDS_WITH Does not end with (match case) |
NOT_ENDS_WITH_FIELD Does not end with (match case) another field value (specify fieldName as criterion.value) |
NOT_EQUAL not equal to |
NOT_EQUAL_FIELD does not match another field (match case, specify fieldName as criterion.value) |
NOT_IN_SET value is not in a set of values. |
NOT_NULL value is non-null. |
NOT_STARTS_WITH Does not start with (match case) |
NOT_STARTS_WITH_FIELD Does not start with (match case) another field value (specify fieldName as criterion.value) |
OR at least one subcriteria (criterion.criteria) is true |
REGEXP Regular expression match - built-in SQL only, JPA and Hibernate do not support regexp operator. |
STARTS_WITH Starts with (match case) |
STARTS_WITH_FIELD Starts with (match case) another field value (specify fieldName as criterion.value) |
STARTS_WITH_PATTERN GLOB matching using wildcards. |
| Modifier and Type | Method and Description |
|---|---|
java.lang.String | getValue() |
static OperatorId | valueOf(java.lang.String name) Returns the enum constant of this type with the specified name. |
static OperatorId[] | values() Returns an array containing the constants of this enum type, in the order they are declared. |
public static final OperatorId EQUALS
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "equals".
public static final OperatorId NOT_EQUAL
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "notEqual".
public static final OperatorId IEQUALS
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iEquals".
public static final OperatorId INOT_EQUAL
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iNotEqual".
public static final OperatorId GREATER_THAN
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "greaterThan".
public static final OperatorId LESS_THAN
null is treated as equivalent to an arbitrarily small value, so null field values will always be returned by lessThan / lessOrEqual filter operations by default. If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "lessThan".
public static final OperatorId GREATER_OR_EQUAL
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "greaterOrEqual".
public static final OperatorId LESS_OR_EQUAL
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "lessOrEqual".
public static final OperatorId CONTAINS
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "contains".
public static final OperatorId STARTS_WITH
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "startsWith".
public static final OperatorId ENDS_WITH
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "endsWith".
public static final OperatorId ICONTAINS
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iContains".
public static final OperatorId ISTARTS_WITH
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iStartsWith".
public static final OperatorId IENDS_WITH
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iEndsWith".
public static final OperatorId NOT_CONTAINS
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "notContains".
public static final OperatorId NOT_STARTS_WITH
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "notStartsWith".
public static final OperatorId NOT_ENDS_WITH
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "notEndsWith".
public static final OperatorId INOT_CONTAINS
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iNotContains".
public static final OperatorId INOT_STARTS_WITH
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iNotStartsWith".
public static final OperatorId INOT_ENDS_WITH
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iNotEndsWith".
public static final OperatorId IBETWEEN
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iBetween".
public static final OperatorId IBETWEEN_INCLUSIVE
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iBetweenInclusive".
public static final OperatorId MATCHES_PATTERN
DataSource.translatePatternOperators for more information on available patterns) If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "matchesPattern".
public static final OperatorId IMATCHES_PATTERN
DataSource.translatePatternOperators for more information on available patterns) If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iMatchesPattern".
public static final OperatorId CONTAINS_PATTERN
DataSource.translatePatternOperators for more information on available patterns) If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "containsPattern".
public static final OperatorId STARTS_WITH_PATTERN
DataSource.translatePatternOperators for more information on available patterns) If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "startsWithPattern".
public static final OperatorId ENDS_WITH_PATTERN
DataSource.translatePatternOperators for more information on available patterns) If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "endsWithPattern".
public static final OperatorId ICONTAINS_PATTERN
DataSource.translatePatternOperators for more information on available patterns) If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iContainsPattern".
public static final OperatorId ISTARTS_WITH_PATTERN
DataSource.translatePatternOperators for more information on available patterns) If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iStartsWithPattern".
public static final OperatorId IENDS_WITH_PATTERN
DataSource.translatePatternOperators for more information on available patterns) If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iEndsWithPattern".
public static final OperatorId REGEXP
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "regexp".
public static final OperatorId IREGEXP
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iregexp".
public static final OperatorId IS_BLANK
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "isBlank".
public static final OperatorId NOT_BLANK
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "notBlank".
public static final OperatorId IS_NULL
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "isNull".
public static final OperatorId NOT_NULL
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "notNull".
public static final OperatorId IN_SET
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "inSet".
public static final OperatorId NOT_IN_SET
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "notInSet".
public static final OperatorId EQUALS_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "equalsField".
public static final OperatorId NOT_EQUAL_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "notEqualField".
public static final OperatorId IEQUALS_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iEqualsField".
public static final OperatorId INOT_EQUAL_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iNotEqualField".
public static final OperatorId GREATER_THAN_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "greaterThanField".
public static final OperatorId LESS_THAN_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "lessThanField".
public static final OperatorId GREATER_OR_EQUAL_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "greaterOrEqualField".
public static final OperatorId LESS_OR_EQUAL_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "lessOrEqualField".
public static final OperatorId CONTAINS_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "containsField".
public static final OperatorId STARTS_WITH_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "startsWithField".
public static final OperatorId ENDS_WITH_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "endsWithField".
public static final OperatorId ICONTAINS_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iContainsField".
public static final OperatorId ISTARTS_WITH_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iStartsWithField".
public static final OperatorId IENDS_WITH_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iEndsWithField".
public static final OperatorId NOT_CONTAINS_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "notContainsField".
public static final OperatorId NOT_STARTS_WITH_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "notStartsWithField".
public static final OperatorId NOT_ENDS_WITH_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "notEndsWithField".
public static final OperatorId INOT_CONTAINS_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iNotContainsField".
public static final OperatorId INOT_STARTS_WITH_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iNotStartsWithField".
public static final OperatorId INOT_ENDS_WITH_FIELD
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "iNotEndsWithField".
public static final OperatorId AND
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "and".
public static final OperatorId NOT
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "not".
public static final OperatorId OR
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "or".
public static final OperatorId BETWEEN
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "between".
public static final OperatorId BETWEEN_INCLUSIVE
If this enumerated value is used in a Component XML file or server-side DataSource descriptor (.ds.xml file), use the value "betweenInclusive".
public static OperatorId[] values()
for (OperatorId c : OperatorId.values()) System.out.println(c);
public static OperatorId valueOf(java.lang.String name)
name - the name of the enum constant to be returned.java.lang.IllegalArgumentException - if this enum type has no constant with the specified namejava.lang.NullPointerException - if the argument is null