Supported Operators for Approval Conditions
You can use various operators when defining approval conditions.
The operators aren't case-sensitive. However, you must enter the date in the DD/MMM/YYYY or DD-MMM-YYYY format only.
For negative approval conditions, add Not as a prefix to any of the supported operators. For example, if your approval condition states that the asset book name isn't VO US CORP, OPS CORP, or BI CORP, then enter the value as: Not In (VO US CORP, OPS CORP, BI CORP).
This table lists the supported operators:
| Condition | Value Type | Format | Example |
|---|---|---|---|
| Attribute is a specific value. | Text, number, or date |
Value Note: Note: No specific format applies
here.
|
If the asset book is OPS CORP, then enter the value as: OPS CORP |
| Attribute value is one of multiple specific values. | Text or number |
In (value 1, value 2, ...) If the asset book name is OPS CORP, VO US CORP, or BI CORP then enter the value as: In (OPS CORP, VO US CORP, BI CORP) |
If the asset book name is OPS CORP, VO US CORP, or BI CORP then enter the value as: In (OPS CORP, VO US CORP, BI CORP) |
| Attribute value should be within a range of values. | Number or date |
Between value 1 and value 2 or value 1 to value 2 |
If the transaction date is between 01 August 2018 to 01 August 2019, then enter the value as: Between 01/aug/2018 and 31/aug/2019 or 01/aug/2018 to 31/aug/2018 |
| Attribute value starts with a specific value. | Text | Starts with value | If the asset book name starts with Vision, then enter the value as: Starts with Vision |
| Attribute value ends with a specific value. | Text | Ends with value | If the asset book name ends with Operations, then enter the value as: Ends with Operations |
| Attribute value contains a specific value. | Text | Contains value | If the major category segment contains Standard, then enter the value as: Contains Standard |
| Attribute value matches a specific value. | Text | Matches value |
If the descriptive flexfield is used for writing a rule, then enter the value as: Matches serial\\T(.*) number In this example, the Matches operator begins with serial and ends with a number. Between the two words, there can be one space and any character. Other options that can be used with the Matches operator are:
|
| Attribute value is on or before a specific date. | Date | On or before date | If the adjustment date is on or before 01/10/2018, then enter the value as: On or before 01/Oct/2018 |
| Attribute value is on or after a specific date. | Date | On or after date |
If the adjustment date is on or after 01/10/2018, then enter the value as: On or after 01/oct/2018 |
| Attribute value is before a specific date. | Date | Before date | If the adjustment date is before 01/10/2018, then enter the value as: Before 01/oct/2018 |
| Attribute value is a specific value, and the condition must be evaluated as case insensitive. | Text | Equals ignore case value | If the feeder application is equal to the FBDI spreadsheet, then enter the value as: Equals ignore case FBDI Spreadsheet |
| Attribute value is a descriptive flexfield. | Text | Starts with | If the transaction descriptive flexfield attribute 1 starts with TT01 |
| Attribute value is a descriptive flexfield. | Text | Not starts with | If the transaction descriptive flexfield attribute 1 Not starts with TT01 |