Conditional Formatting (ttadv9502m100)

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.
  • In the Sales Orders (tdsls4100m000) session the Planned Receipt Date field must be displayed with background color Red if the date is older than seven days. Condition (Planned Receipt Date < -7)
Note: 

If you run this session standalone, not all functionality is supported. This is because not all details are known for the session for which you specify conditional formatting. For example, it is unknown whether fields can be filtered on.

Therefore, we recommend that you first start the session for which you want to specify conditional formatting. Then, in that session, run the Edit Conditions command to start this Conditional Formatting (ttadv9502m100) session.

Related topics

"Conditional Formatting" in the LN UI documentation

Field Information

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 these:

All The conditional format is applied in all situations, regardless of the mode in which the session runs.
Overview The conditional format is applied only if the sessions runs as an overview session.
Details The conditional format is applied only if the sessions runs as a details session.
Zoom The conditional format is applied only if the sessions runs as a zoom session.
Satellite The conditional format is applied only if the sessions runs as a satellite in a multi-main table (MMT) session.
Company

This option is only enabled for super users. You can enable a condition for one specific company or for all companies.

Creation Level

Select one of these formats:

User The conditional format applies only to the user that is specified in the User/Role field.
System The 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.
  • Super users can create System formats. Normal users can only create formats that apply to their own user account.
User/Role

The user the format applies to.

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

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

The default field to use for the start of the condition.

Formatted Field

The field to which the field formatting must be applied.

Present as Filter

If this option is selected, the conditional format is present as a filter.

Show Filter on Toolbar

If this check box is selected, the filter that originates from the conditional format is displayed as a button on the toolbar. If this check box is cleared, the filter that originates from the conditional format is not displayed as a button on the toolbar anymore.

This field is enabled if a filter originates from the conditional format.