Show TOC

Background documentationiGrid Context-Sensitive Color Highlighting Locate this document in the navigation structure

Features

You can set color properties for your SAP Manufacturing Integration and Intelligence (SAP MII) grid columns or rows. For information about grid color properties, see iGrid Color Context.

Color highlighting is based on the following grid types:

  • Grid

    The color of each row is based on the values of the properties that control highlighting.

  • Scoreboard or VerticalScoreboard

    The system colors each cell independently.

  • VerticalGrid

    The system colors each column independently.

Dynamic Background Property

The DynamicBackground property only applies to the following grid types. For more information, see iGrid Color Context.

  • Grid

    Multiple conditions are matched using AND.

  • VerticalGrid

    If color highlighting is enabled, the highlighting rules apply to each row of a Grid or to each column of a VerticalGrid. If no match is found, the default TextColor or BackgroundColor value is used depending on the value of the DynamicBackground property.

    Multiple conditions are matched using AND.

  • Scoreboard and VerticalScoreboard

    For a Scoreboard or VerticalScoreboard, columns specified in the MatchColumns list use a dynamically selected color, whereas values from columns not specified in the list use the default TextColor or BackgroundColor property values.

    Note Note

    If no color highlighting is enabled, all values are displayed based on the TextColor and BackgroundColor properties.

    Multiple conditions are matched using OR.

    End of the note.
Other Grid Types

The following grid types are also available:

  • The following grid types behave like the Grid, except one or more lights is displayed at the end of the row.

    • Lights

      Displays a single light. Multiple conditions are matched using AND.

    • MultiLights

      Displays a bank of lights, with zero or one illuminated. Multiple conditions are matched using AND.

    • EmbeddedLights

      Displays a single light with the MatchValue text displayed in the center of the light.

      The EmbeddedLights grid type uses the BackgroundColor value to display the MatchValue text in the center of the light. Both the query results and the MatchValue must be enclosed in the less than and greater than symbols. For example, if the query returns a value of <G> or <R>, the corresponding MatchValue settings must be <G> and <R>.

      Note Note

      For these grid types, the cell values are displayed based on the MatchColor property.

      Multiple conditions are matched using OR.

      End of the note.

  • The ColumnLights grid type is like the Scoreboard, except lights are displayed in lieu of text values for the cells. If no matching color is found, the light is based on the TextColor property. Multiple conditions are matched using OR.

    The value matching modes are String and Number. String uses explicit value matching and Number uses ranges of values to determine which color to select. The matching algorithm starts with the first color, looks at the value or range combinations for it, and if it matches, selects that color. If no matches are found, the TextColor property value is used.

    In String matching mode, you can use a wildcard value, entered as the asterisk, as the value to match. You can use this wildcard when you want a combination of an explicit value in one column and any value in another column to yield a match.

    In Number mode, the algorithm determines if the cell values are less than or equal to the match value, and if so, a match is found. Min and Max can be used in place of a numerical value. Min is equal to the minimum allowable value for the particular Java data type. For example, you can use Double.Min or Integer.Min. Max is equal to the maximum allowable value for the particular Java data type. For example, you can use Long.Min or Double.Max.