Show TOC

Function documentationi5Grid Color Context Locate this document in the navigation structure

 

You can use the properties listed in the table below to set the conditions and color context for each row of your SAP Manufacturing Integration and Intelligence (SAP MII) i5Grids

Features

Based on the entered query template, the system displays the associated column names.

The value matching modes are String and Number. String uses explicit value matching and substring. Number uses exact match. The matching algorithm starts with the first color, looks at the value for it, and if it matches, selects that color. If no matches are found, the text is based on the TextColor property and the lights are displayed in black. In Number mode, the algorithm determines if the cell value is equal to the match value.

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.

The thresholds that you configure can be a single value, a range of values, or regular expressions, which determine the values to be highlighted.

The Dynamic Background checkbox controls whether the cell text color or background color is affected by the color rules. If you select this checkbox, the cell background color changes based on data values. If you do not select this checkbox, the cell text color changes dynamically.

The following table lists other i5Grid color context properties:

Property Name

Parameter Name

Data Type

Description

Match Mode

MatchMode

String

Specifies the basis for matching data values. Matched values can be highlighted with color. You can choose from the following match mode options:

  • String: Provides matching on all or part of the string. Not case-sensitive.

  • Regex: Allows standard regular expressions to match a value. This mode uses the built-in REGEX libraries in the JDK. For more information, see http://java.sun.com.

  • Double: Allows matching against any decimal number in the range 4.94065645841246544e-324d to 1.79769313486231570e+308d.

  • Integer: Allows matching against any integer in the range -2,147,483,648 to +2,147,483,647.

  • Long: Allows matching any long integer in the range -9,223,372,036,854,775,808 to +9,223,372,036,854,775,807.

Column Names

MatchColumns

String list

Lists column names from the query that can be highlighted with color

Color

MatchColors

Color list

Shows available color combinations

match values

MatchValues

String list

Lists values to be matched with column values to determine which highlight colors to use. Rows are highlighted, except in Scoreboard and ColumnLights grids, which highlight columns.

Activities

You can set these properties for your grid template on the Color Context screen of the SAP MII Workbench and can change the parameter values for individuals through scripting. For more information, see Web Page Scripting for i5Grids.