Managing colors

Managing colors

Rows resulting from query can be colored according to a custom criteria
(ie. done activities in green, error in red, working in cyan, waiting in yellow...)
to color rows of a query, you should put the color code as first column, like in example below:
select
case STATUS
when 'DONE' then 'G;'
when 'WAIT' then 'Y;'
when 'RUNNING' then 'C;'
when 'ERROR' then 'P;'
else 'N;'end as "W;",
AC.*
from LOG_ACTIVITIES AC
/

Colors code can also be used in file spcmd.def to give a specific color to menu items (for more informations see [spcmd.def])

To see all the colors available and relative codes, navigate to ROOT>COLORS

Back to [Home]