Customizing Colors

By default, planning unit status (for example, Under Review or First Pass) is displayed in black. You can customize each state to display in another color. Valid colors include all named colors that browsers recognize. See the Microsoft Web site for supported named colors.

The information for process status state colors is stored in the HSP_PM_STATES table in the COLOR column. You must run statements for your relational database to change the color value.

After you customize the colors, restart the Web application server.

Example: SQL Relational Database

Run this query to list all available process status states and their current color settings: select * from hsp_pm_states

This returns the state_id, the name of the process status state, and the color. By default, the color value is <NULL>, which converts to black.

Note the state_id of the process status state you want to change, and then run this query:

UPDATE HSP_PM_STATES SET COLOR = 'new color' WHERE STATE_ID = state_id

Run this SQL statement to change the First Pass process status state color to green:

UPDATE HSP_PM_STATES SET COLOR='GREEN' WHERE STATE_ID=1

Note:

For Oracle relational databases, issue a COMMIT; command to commit the transaction.