i5Grid Color Context

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

Prerequisites

For lights based grid types, you must import icons to the WEB folder to display icons in the columns.

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.

You can either search for exact match or search for higher, lower, or in between ranges. On choosing In Between, you must enter the range in the From and To columns.

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.

Note Note

For Lights, MultilLights, ColumnLights, and EmbeddedLights, you can display icons by selecting an icon in the Icon column. In other words, when the conditions are matched, the selected icons are displayed in the column instead of lights. When both icons and colors are defined for the column names in a row, the icon display takes precedence over colors.

End of the note.

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
Icon	`MatchIcon`	String list	Lists URLS for the chosen icon.
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.