Element Details: Sql+Color+Spectrum+Column
 Back


Available in: Logi Info Source code name: SqlColorSpectrumColumn

SqlColorSpectrumColumn adds a new column containing color values that fall between the LowValueColor and HighValueColor. The color for each row is generated based on where the current DataColumn value falls between the MinRange and MaxRange.

Element Group:Add and Replace Columns



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
DataColumn
UserDefined
(Required) The name of a data field/column returned from the DataLayer.
HighValueColor
UserDefined
The color used for the highest values of the data set. The default is green.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
IncludeCondition
True
False
An expression that evaluates to a value of True or False. If the expression is blank, or evaluates to true the element is processed. If the expression evaluates to false, the element is skipped. Expressions should be in VBScript or JavaScript syntax. For .NET versions, the scripting language can be set in the _settings.lgx General element. For Java versions, the scripting language is always JavaScript. Typically, you would compare values using an operator, such as "@Session.value~ < 0". Use quotes when working with strings: "@Session.myValue~" == "SomeValue"
LowValueColor
UserDefined
The color used for the lowest values of the data set. The default is red.
MaxRange
UserDefined
The maximum value expected for the data set. The default is the actual maximum value.
MediumValueColor
UserDefined
The color used for values that are in the middle of the data set. For CellColorSliders, the default is yellow. Otherwise, the default is the color between the LowValueColor and HighValueColor.
MinRange
UserDefined
The minimum value expected for the data set. The default is the actual minimum value.



PARENT ELEMENTS

Click element to drill down for more information.



CHILD ELEMENTS

Click element to drill down for more information.



 Back to top