Terms for data types
This list contains the data types, operators,
keywords, and other terms that are supported in a security rule formula.
The following data types are supported:
- Boolean
- Integer
- Decimal
- Date
- Currency
- Simple string including all display types
- Enumerated (single-valued and multivalued)
Terms that can be used with all data types
The following terms are used with all data types.
- AND
- Narrows the search for objects. The objects must meet all of the criteria.
- OR
- Broadens the search for objects. The objects must meet one of the criteria, not all of them.
- NOT
- Narrows the search by excluding all objects that match the specified criteria.
- ( ) (parentheses)
- Groups criteria together to show the order in which the rule is applied.
Terms that are used with numeric data types
The following operators are used with numeric data types, such as decimal, integer, and currency data types. Security rules do not support field criteria on computed text fields or large text fields.
- = (equal)
- Compares the values in two fields and returns "true" if both contain the same value.
- < (less than)
- Compares the values in two fields and returns "true" if the second field is less than the first field. The two fields must be of the same data type. For example, both are decimal data types.
- > (greater than)
- Compares the values in two fields and returns "true" if the second field is greater than the first field. The two fields must be of the same data type. For example, both are decimal data types.
- <= (less than or equal)
- Compares the values in two fields and returns "true" if the second field is less than or equal to the first field. The two fields must be of the same data type.
- >= (greater than or equal)
- Compares the values in two fields and returns "true" if the second field is greater than or equal to the first field. The two fields must be of the same data type.
- < > (not equal)
- Compares the values in two fields and returns "true" if both contain different values.
Terms that are used with string data types
The following operators are used with data types that require strings, such as enumerated strings and simple strings. Security rules do not support long strings.
- CONTAINS
- Determines whether a multiple-select field contains a specific value or set of values.
- ENDS WITH
- Determines if the field value ends with the specified text.
- LIKE
- Determines if a field value matches the specified pattern string.
- STARTS WITH
- Determines if the field value starts with the specified text.
- IN
- Determines if the field value is in the specified field.
Terms that are used with date data types
- TODAY
- Returns today's date.
- TOMORROW
- Returns tomorrow's date.
- NOW
- Returns the current date and time.
- YESTERDAY
- Returns yesterday's date.
- DATE
- Specifies the date and time as a string in the ISO format:
YYYY-MM-DD
andhh:mm:ss.sTZD
.
Terms that are used with other data types
- END_USER
- Returns the logged-in user.
- END_USER_PROFILE
- Returns the profile for the logged-in user.
- IN GROUP
- Returns the user group for the logged-in user.
- IN PROFILE
- Returns the specified field value that is in the specified profile.
- INTENDED PARENT
- Tests the parent under which a new object is to be created. It can be used only when you define a Create rule.