Conditional Formatting (ttadv9502m000)

Use this session to define conditions to apply special formatting effects to the data displayed in LN sessions. You can define multiple conditions per session.

You can define different types of formatting effects, for example a specific color for particular fields or rows, and a warning symbol for particular rows.

You can define various types of conditions, both simple and more complicated. For example:

  • In the Production Orders (tisfc0501m000) session, all production orders with Order Status "Closed" must be displayed on a green back ground.
  • In the Sales Orders (tdsls4100m000) session, a warning symbol must be displayed and the order Amount must be displayed on a blue background, for all sales orders with an order amount greater than 10000.

Points of attention

  • This session only runs in Web UI.
  • Conditional formatting is only supported in Web UI. Worktop users will not see the formats defined for a session.
  • You can only define formats if the Application Personalization check box in your user data template properties on the LN server ( User Data Template (ttams1110m000) session) is selected.
  • Via the appropriate menu, super users can export formats to an XML file and import formats from an XML file. In this way a super user can distribute formats to multiple LN environments.
  • You can start this session in multiple ways:
    • From the View menu in a session you started in Web UI.
    • Directly, for example from the LN Tools menu or through the Run Program command in the Web UI Tools menu.

Related topics

  • "Conditional Formatting" in the Web UI documentation

 

Session
The package code of the session for which the format is defined.
Session
The module code of the session.
Session
The session's code.
Session Type
A session can run in various modes. This field indicates the session mode the conditional format applies to.

Select one of the following:

AllThe conditional format is applied in all situations, regardless of the mode in which the session runs.
OverviewThe conditional format is applied only if the sessions runs as an overview session.
DetailsThe conditional format is applied only if the sessions runs as a details session.
ZoomThe conditional format is applied only if the sessions runs as a zoom session.
SatelliteThe conditional format is applied only if the sessions runs as a satellite in a multi-main table (MMT) session.

 

Company
The companies the format applies to

Select one of the following:

AllThe conditional format is applied in all companies.
CompanyThe conditional format is only applied if the session runs in a specified company.

 

Company
The company the format applies to.
Creation Level
Select one of the following:
UserThe conditional format applies only to the user that is specified in the User field.
SystemThe conditional format applies to all users.

 

Note
  • If you start this session from the View menu in another session, you can only create User formats that apply to your own user account.
  • To create a System format, you must start this session directly, for example from the LN Tools menu or through the Run Program command in the Web UI Tools menu.
  • Only super users can create System formats. Normal users can only create formats that apply to their own user account.
User
The user the format applies to.

For System formats the field is filled with a "^".

Conditions
Description
The description of the conditional format.
Enabled
If this check box is selected, the format is applied automatically when the session, for which the format is defined, is started.

If this check box is cleared, the format is not started automatically. Users can enable the format through the session's View menu.

Field Name
The field on which the condition is based. You can zoom to select one of the session's fields.
Comparison Operator
A comparison operator to compare the field with the field or value specified in the next field.
Field Name/Value
The field or value the first field is compared to.

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 or a UTC field to a fixed date. You must always compare to a relative date. You can enter, for example:

    • >=-0 or >=+0 (later than now)

      The + or - is mandatory. If you specify a 0 without a + or -, the 0 is considered as an absolute value. In that case the filter checks whether the field is empty.

    • +1 (tomorrow)
    • -7 (1 week ago)
    • -365 (1 year ago)
  • You can check whether a field is empty. For example:
    • <date field> = 0
    • <string field> =

See the following examples:

Field NameComparison OperatorField Name/Value
Order Amount>10000
Search Key>="C"
Search Key=
Order Status=Closed
Order Date<-365
Planned Delivery Date>Requested Delivery Date
Planned Delivery Date=0

 

Arithmetic Operator
Select an arithmetic operator if you want to combine the field or value entered in the previous Field Name/Value field with another field or value.
Field Name/Value
Select a field or enter a value to combine with the field and operator entered in the previous 2 fields.

See the following example:

Field Name

Comparison Operator

Field Name/ValueArithmetic OperatorField Name/Value
Cost Price>Material Costs+Operation Costs
Planned Delivery Date>Requested Delivery Date+432000 (43200 seconds is 5 days)

 

Coloring
Color Field
If this check box is selected, you can specify color settings for a specific field.
Color Field
The field for which you want to define the color(s).
Foreground Color
Select this check box if you want to apply a color to the characters displayed in the selected field.

To select a color, click Color.

Foreground Color
A number that represents the selected color.
Background Color
Select this check box if you want to apply a background color to the selected field.

To select a color, click Color.

Background Color
A number that represents the selected color.
Color Row
Select this check box if you want to apply a color to the rows that meet the condition.

To select a color, click Color.

Color Row
A number that represents the selected color.
Warning Icon
If this check box is selected, a warning symbol is displayed at the beginning of each row that meets the condition.

 

Import
Starts a dialog that enables you to import formats from an XML file.