iConsole Search Definition Reference Guide › Advanced Features › Dashboards › Dashboard Search SQL › Data Grid Styles

Data Grid Styles

Additional style control is available for panes displayed as a data grid. Style names can be defined for individual cells or complete columns so that they may be highlighted using e.g. background color. Styles are defined by appending the style name to the column name or cell value using '::' as a separator. For example:

SELECT 'Credit Information' AS "Policy Name", '4::SeverityLow' AS "Risk", '5' AS "High::SeverityHigh"

Will use the 'SeverityLow ' style for the cell containing the Credit Information 'Risk' and the 'SeverityHigh' style for the entire 'High' column. At present only four styles are supported: SeverityNotSet, SeverityLow, SeverityMed and SeverityHigh. Since the styles are currently compiled into the Flash object adding new styles is not a simple customization task.