| Operator | Action |
|---|
| ( ) | Use parentheses to control the order in which the expression is carried out. Operations found within parentheses are executed together as a unit. For example, in the operation 'Gross Income' ñ ('Unemployment Insurance' + 'Pension Plan Contributions' + 'Income Tax') , the items within the parentheses are added before they are subtracted from Gross Income. |
| AND && | Logical AND of the result of two conditions. The result is true only if both conditions are true. For example, 'Status'="New" AND 'Assigned to'="Andy" finds all new requests assigned to Andy. You can use two ampersands (&& ) instead of the word AND. |
| OR || | Logical OR of the result of two conditions. The result is true if either condition is true. For example, 'Status'="New" OR 'Assigned to'="Andy" finds all new requests (regardless of who they are assigned to) and all requests assigned to Andy (no matter what their status). You can use two vertical lines (|| ) instead of the word OR. |
| NOT ! | Negates the condition that follows. If the condition is false, the result is true. For example, NOT 'Status'="New" finds all requests that are not new. You can use an exclamation point (!) instead of the word NOT. |
| LIKE | Performs a pattern search. For example, 'Submitter' LIKE "Bob%ton" finds all requests with a submitter name that begins with the letters Bob and ends with the letters ton--such as Bob Compton and Bobby Fenton. The LIKE operator is useful only with character and diary fields. Use square brackets and the LIKE operator for Sybase databases. Square brackets when used along with the LIKE operator do not work with Oracle databases. See Using relational databases with BMC Remedy AR System and the Operators. |
| + | - Adds two numerical values (integer, real values, or decimal).
- Adds an integer interval to a date/time value.
- Adds two character strings.
For example, 'Create date' > $DATE$ + (8*60*60) finds all requests that were created after 8:00 a.m. today. (*8*60*60* is the number of seconds in 8 hours.) |
| - | - Subtracts two numerical values (integer, real values, or decimal).
- Subtracts two date/time values (resulting in an integer). Subtracts an integer interval from a date/time value.
For example, 'Create date' > $TIMESTAMP$ - (7*24*60*60) finds all requests that were created within the past week. (*7*24*60*60* is the number of seconds in one week.) This is useful to include in a custom report of all requests created in that week. |
| * | Multiplies two numeric values. For example, 'Quantity' * 'Price' > 50 finds all requests where the contents of the Quantity field multiplied by the contents of the Price field is over 50. |
| / | Divides two numeric values. For example, 'Total Expenses' / 'Total Income' = 2 finds all requests where the total amount spent for expenses is twice the total amount of income. |
| % | Modulo of two integer values (the remainder of a division of the values). Because a percent sign is also a valid wildcard symbol, the context determines how it is interpreted. When used as part of a search statement, it is interpreted as a wildcard symbol; when used in the expression where an operator is expected, it is interpreted as modulo.Note: Use the modulo operator only with fields whose data type is integer. If you use this operator with fields that have other data types, such as Date/Time, an error occurs. |
| < | Matches contents that are less than the value. For example, 'Create date' < ($TIMESTAMP$ - 24*60*60) finds all requests created more than 24 hours ago. (24*60*60 or 86400, is the number of seconds in 24 hours.) |
| > | Matches contents that are greater than the value. For example, 'Create date' > "09/24/07 00:00:00" finds all requests with Create dates that are newer than midnight September 24, 2007. |
| != | Matches contents that are not equal to the value. For example, 'Status' != "Closed" finds all requests that are not closed. |
| <= | Matches contents that are less than or equal to the value. For example, 'Salary' <= 30000 finds all requests where the contents of the Salary field are less than or equal to 30000. |
| >= | Matches contents that are greater than or equal to the value. For example, 'Create date' >= "09/30/07" finds all requests with Create dates equal to or more recent than September 30, 2007. |
| = | Matches contents that are exactly equal to the value. For example, 'Status' = 0 finds all requests with a status value equal to the first selection value. |
