Color Column
Assign a color condition to each Traffic Light. There are three ways to set color conditions:
- Enable Set Conditions (only available from Bizview 2012 version).
- Write SQL query directly in Color Column.
- Create a column in the view/table that returns the correct color code for each value returned by the view/table. The view can return the following states: Gray, Red, RedFlash, Orange, OrangeFlash, Green, and GreenFlash.
Set Conditions (only available from the Bizview 2013 version)
Enable Set Conditions and insert the conditions to be used for the Traffic Light.
What to do:
- Enable Set Conditions by marking the check box.
- Specify value ranges, like the example below.
- Select a color format.
The rules defined in Set Conditions will always be evaluated towards the values returned by the defined Color Column. Therefore, a column must always be selected/entered in the Color Column list if Set Conditions are used.
SQL Query in Color Column
Write a CASE WHEN (Transact-SQL) query directly in the Color Column box.
Note: NO FUNC.
Below is a list of the comparison operators:
| Comparison Operators | Description |
|---|---|
= | Equal to |
> | Greater than |
< | Less than |
>= | Greater than or equal to |
<= | Less than or equal to |
<> | Not equal to |
between | Between |
not between | Not Between |