Skip to main content

%DeepSee.Component.pivotCondition

Class %DeepSee.Component.pivotCondition Extends %ZEN.Component.object [ System = 3 ]

Defines an conditional formatting rule within a %DeepSee.Component.pivotTable component.

Parameters​

NAMESPACE​

Parameter NAMESPACE = "http://www.intersystems.com/deepsee";

Properties​

range​

Property range As %ZEN.Datatype.string;

Range of cells for which this rule applies.

operator​

Property operator As %ZEN.Datatype.string(VALUELIST = ",=,<>,>,<,>=,<=,BETWEEN,IN,IS NULL");

Condition operator.

value​

Property value As %ZEN.Datatype.csv;

Value (or values) to test. For IN and BETWEEN this is a comma-delimited list.

style​

Property style As %ZEN.Datatype.style;

CSS style to apply to cells that match this condition.

text​

Property text As %ZEN.Datatype.string;

If defined, replace value with this text.

icon​

Property icon As %ZEN.Datatype.uri;

If defined, replace value with this icon.

iconCount​

Property iconCount As %ZEN.Datatype.integer [ InitialExpression = 1 ];

If defined and icon is defined, replace value with this number of icons.

Methods​

%EvaluateCondition​

Method %EvaluateCondition(pRow As %Integer, pCol As %Integer, pValue As %String) As %Boolean

Test if the given cell value matches this condition.