Function Groups

The following table groups functions by use.

Table 10. Function Groups

Function Group

Functions

Aggregate

  • AvgList

  • MaxList

  • MinList

  • SumList

Change Tracking

  • AddedBy

  • AddedOn

  • Changed

  • ChangedBy

  • ChangedOn

  • Now

Comparison

  • Equals

  • GreaterThan

  • GreaterThanOrEqual

  • InRange

  • IsBlank

  • IsRangeListSubset

  • LessThan

  • LessThanOrEqual

  • RangeListContains

Conditional

  • And

  • If

  • Not

  • Or

  • XOr

Data Type

  • BoolToStr

  • FloatToStr

  • IntToStr

  • IsDataType

  • IsNumeric

  • StrToBool

  • StrToFloat

  • StrToInt

List

  • ArrayCount

  • ArrayIndex

  • ArrayItem

  • Intersection

  • ListContains

  • ListDistinct

  • ListNodePropValues

  • ListNodesWith

  • SortList

Mathematical

  • Add

  • AddFloat

  • Divide

  • DivideFloat

  • Modulus

  • Multiply

  • MultiplyFloat

  • Subtract

  • SubtractFloat

Node

  • Abbrev

  • ID

  • InternalPrefix

  • NodeExists

  • NodeInHier

  • NodeIsLeaf

Property

  • AncestorProp

  • AscNodeProp

  • DefaultProp

  • Descr

  • DualAncestorProp

  • HierNodePropValue

  • InheritedPropOrigin

  • IsDefinedPropVal

  • NodePropValue

  • OrigPropValue

  • ParentPropValue

  • PropControllingHier

  • PropDefaultValue

  • PropMaxValue

  • PropMinValue

  • PropValue

  • ReplacePropValue

Relationship

  • Children

  • HasChildWith

  • HasParentNode

  • HasSiblingWith

  • InvertedLevel

  • IsBottomNode

  • IsNodeAbove

  • IsNodeBelow

  • ListAncestors

  • ListChildren

  • ListDescendants

  • ListRelatedNodesWith

  • ListSiblings

  • NextSibling

  • NumChildWith

  • NumDescendantsWith

  • PreviousSibling

  • ReplacementAbbrev

String Manipulation

  • Concat

  • ConcatWithDelimiter

  • Decode

  • FlipList

  • Format

  • FormattedDate

  • HasCharacters

  • IsAlpha

  • IsAlphaNumeric

  • Length

  • LowerCase

  • LTrim

  • PadChar

  • PadList

  • Pos

  • ReplaceStr

  • RTrim

  • StripPadChar

  • Stuff

  • SubString

  • Trim

  • UpperCase

User

  • NodeAccessGroups

  • PropertyCategories

  • UserName