Conditional formatting for Optiva View grids
In the web client, you can customize the background colors and the font colors that are shown in the view grids. You can also use a custom style sheet to format the grids.
The colors are based upon the values in the grid cells. For this example, the colors are based upon the values in the Item Code, CAS#, and Common Name columns.
The columns that you intend to customize are prefixed by certain keywords. This table shows the list of keywords.
| Column Prefix | Description |
|---|---|
F_BG
|
This prefix changes the background color. For
example,
F_BG_ITEM_CODE changes the background color of
the
ITEM_CODE field.
|
F_FG
|
This prefix changes the font color. For
example,
F_FG_ITEM_CODE changes the font color of the
ITEM_CODE field.
|
F_RC_BG
|
F_RC_BG changes the
background color of the row.
|
F_CSS
|
Use this prefix to specify the CSS style
sheet that is used for the conditional formatting tags. This style sheet
overrides the standard style sheet that is provided in
Optiva.
For example,
|
Applying conditional formatting is performed by adding the custom calculated columns to the existing query. The custom calculated columns are not visible in the grid.