Format Condition (ttadv9504m000)
Use this session to define the conditions for which to apply a specific style.
If the “Or” operator is selected, records matching all combined conditions will have the style applied. The brackets are automatically set by the session; the “And” operator has priority.
For example, in the Sales Orders (tdsls4100m000) session, these conditions can be defined:
Condition | Icon | |||||
---|---|---|---|---|---|---|
IF | ( | Sales Office | = | SLS | ||
AND | Order Amount | > | 10000 | ) | Alert | |
OR | ( | Sales Office | = | SLS | ||
AND | Sales Order Status | >= | Confirmed | ) | Confirm |
The style of the last matching condition overrules attributes on a previous style. In the example, if a Sales Order with Sales Office “SLS” has status Confirmed and an amount larger than 10000, then the Confirm icon is displayed. If the first condition also defines a Background Color for a specific field, and the second condition does not, then that color and the confirm icon are displayed.
Field Information
- Condition on Field
-
If ‘AND’ is selected, this condition will be combined with the previous ones. If ‘OR’ is selected, this is the start of a new condition.
- Opening parenthesis
-
Together with the closing parenthesis, this indicates the boundaries of the grouped conditions.
- Field Name
-
The field on which the condition is based. For the first condition of a group, the field selected in the header is always used.
- Comparison Operator
-
A comparison operator to compare the field with the field or value specified in the next field.
- Field Name/Value (1)
-
The field or value to which the first field is compared.
You can compare the field to a fixed value or to another field in the session. You can zoom to select the second field.
Notes
- If the field is an enumerate, you can zoom to select an enumerated constant.
- To compare a string field to a fixed value, the value must be surrounded by quotes.
- You cannot compare a date field to a fixed date. You must
always compare to a relative date. You can specify, for example, these values:
-
>=-0
or>=+0
(later than now)The
+
or-
is mandatory. If you specify a0
without a+
or-
, the0
is considered as an absolute value. In that case the filter checks whether the field is blank. -
+1
(tomorrow) -
-7
(1 week ago) -
-365
(1 year ago)
-
- You can compare a UTC
date.time
field with a fixed value. That value must be numeric. For example: 1440972000 for 8/31/2013 00:00:00. -
You can compare a UTC
date.time
field with the current date and time. To do this, use theutc()
function.For example, you can specify
[UTC date.time field] < utc()
. - You can check whether a field is blank. For example:
- <date field> = 0
- <string field> =
Note: The Easy Filter Row, Managed Filters and Conditional Formats are different concepts, conditions are not always interchangeable. For example a UTC date with date = 0 is not supported in the Easy Filter Row. A Relative Date works for both Filters and Formats. To Filter with a Formatted Icon or when using a Filter Button originating from a Format, the conditions must work for both.Examples
This table shows some examples for string, numeric, and enumerate fields:
Field Name Comparison Operator Field Name/Value (1) Arithmetic operator Field Name/Value 2 Order Amount > 10000 Search Key >= "C" Search Key = Order Status = Closed Book Price > Active Price Book Price > Active Price + 100 This table shows some examples for date (not UTC!) fields:
Field Name Comparison Operator Field Name/Value (1) Arithmetic operator Field Name/Value 2 Comment Start Date < -365 End Date = 0 End date = blank End Date = +0 End date is today End Date = -0 End date is today End Date = Start Date End Date > Start Date + 365 This table shows some examples for UTC
date.time
fields:Field Name Comparison Operator Field Name/Value (1) Arithmetic operator Field Name/Value 2 Comment Planned Delivery Date > Requested Delivery Date The planned delivery date and time is after the requested delivery date and time. Requested Delivery Date < utc() The requested delivery date and time is before the current date and time. Requested Delivery Date < utc() - 86400 86400 seconds is exactly 1 day. The requested delivery date and time is more than 1 day before the current date and time
- Arithmetic Operator
-
Select an arithmetic operator if you want to combine the field or value specified in the previous Field Name/Value (1) field with another field or value.
- Field Name/Value (2)
-
Specify the field or value that you want to combine with the field or value specified in the previous Field Name/Value (1) field.
- Closing parenthesis
-
Together with the opening parenthesis, this indicates the boundaries of the grouped conditions.
- Foreground Color
-
Select a color to use as foreground color for the Formatted Field if the condition applies.
- Background Color
-
Select a color to use as background color for the Formatted Field if the condition applies.
- Background Style
-
Specify Fill or Round .
For enum fields, only the Fill background style is allowed. This prevents confusion with enum domain formatting, defined in the Enum Domain Formatting (ttgfd4525m000) session, which always uses a round style.
- Row Color
-
Select a color to use as background for the entire row if the condition applies.
- Row Icon
-
Select an icon to show in front of the row if the condition applies.
- Preview Device
-
This field shows a preview of the selected style.
- Row Preview
-
This field shows a preview of the row color.