Formato según la condición (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 Órdenes de fabricación (tisfc0501m000) session, all production orders with Order Status "Closed" must be displayed on a green back ground.
  • In the Órdenes de venta (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 Personalización de aplicación check box in your user data template properties on the LN server ( Plantilla de datos usuarios (ttams1110m000) session) is selected.
  • Via the Vistas, Referencias o Acciones 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.

Temas relacionados

  • "Conditional Formatting" in the Web UI documentation

 

Sesión
The package code of the session for which the format is defined.
Session
The module code of the session.
Session
The session's code.
Tipo sesión
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.

 

Compañía
The company the format applies to.
Nivel de creación
Select one of the following:
UserThe conditional format applies only to the user that is specified in the Usuario field.
SystemThe conditional format applies to all users.

 

Nota
  • 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.
Usuario
The user the format applies to.

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

Conditions
Descripción
The description of the conditional format.
Habilitado
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.

Nombre de campo
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.
Valor/nombre de campo
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 Valor/nombre de campo 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
Campo de color
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).
Color de 1r plano
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.
Color de fondo
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.
Fila en color
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.
Icono de advertencia
If this check box is selected, a warning symbol is displayed at the beginning of each row that meets the condition.

 

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