Operators, Functions and Constants Panels - Intergraph Smart Instrumentation - Help

-

minus

Subtraction

%

percent

Percent

*

asterisk

Multiplication

/

forward slash

Division

+

plus

Addition

<

less than

Value less than the number indicated. For example: Price: < $100, is any value from $1 to $99 in the Price column.

<=

less than or equal to

Value less or equal to number indicated. For example: Price: <= $100, is any value from $1 to $100 in the Price column.

<>

not equal to

Greater or less than, or not equal to. For example: Price: <> $100, is any number that is not $100.

=

equals

Value equals the number indicated.

>

greater than

Value greater than the number indicated. For example: Price: > $100, is any value from $101 to the highest value in the Price column.

>=

greater than or equal to

Value greater or equal to number indicated. For example: Price: <= $100, is any value from $100 to the highest value in the Price column

And

Boolean function

Checks a value of user-defined condition, and if all conditions are met returns True, and False otherwise.

Not

Negates a condition

Checks values where everything except the value defined must be met. Returns True when condition is met, and False otherwise. Used in combination with other Functions. For example: Not Contains ([Instrument Name],"FT") results in: 101-FE-100 -True, 101-FT-100 -False.

Or

Boolean function

Checks a value of user-defined condition, and if any conditions are met returns True, and False otherwise.

Abs

Returns the absolute value of a number, a number without its sign

Abs ( ToNumber( [Attribute Name]))

Abs(ToNumber([Set-Point Minimum Range]))
Set-Point Minimum Range: -20.2

Result Preview
Abs (-20.2) = 20.2

Average

Computes the average of a sequence of numbers.

Average ([List (Of Number)])

Average( 9,8,7 ).

Result Preview: 8

Ceiling

Returns the smallest integer greater than or equal to the specified number

Ceiling( ToNumber( [Attribute Name] ))

Ceiling( ToNumber( [Cable Length ]))
Cable Length (23.3)
Result Preview: 24

Contains

Determines whether a sequence contains a specified element

Contains ([List], [Arg]

Contains( [Instrument Name],"FT" )

Exp

Returns the base e of a number raised to the specified power

Exp ([Number])

Exp (2).
Result Preview: 7.389056099

Floor

Returns the largest integer less than or equal to the specified number

Floor( ToNumber( [Attribute Name] ))

Floor( ToNumber( [Cable Length ]))
Cable Length (23.3)
Result Preview: 23

IF

Checks whether a condition is met, and returns one value if True, and other value if False

IF ([Test], [ifTrue], [ifFalse])

If(6>5,True, False)
Result Preview: True

Length

Returns the number of elements in a sequence

Length ([List])

Length("Hello")
Result Preview 5.

Log

Returns the natural (base e) logarithm of a specified number

Log ([Number])

Log(8,2).
Result Preview: 3

Log 10

Returns the base 10 logarithm of a specified number

Log10 ([Number])

Log10 (120) . Result Preview: 2.079181

Max

Returns the maximum value in a sequence

Max ([List(Of Number)])

Max(10,6,4 ) . Result Preview: 10

Min

Returns the minimum value in a sequence

Min ([List(Of Number)])

Min(10,6,4 )
Result Preview: 4

Pow

Returns a specific number raised to the specified power

Pow ([Number], [Number])

Pow(2,3)
Result Preview: 8

Remove

Returns a new string in which all the characters in the current instance, beginning at a specific position and continuing through the last position, have been deleted

Remove ([Arg], [Number])

Remove( [Instrument Name],10). Result Preview: 101-ALARM-

Round

Rounds a decimal number to the nearest integer number

Round ( ToNumber( [Attribute Name] ))

Round ( ToNumber( [Set-Point Minimum Range]))

Sign

Returns a value indicating the sign of a number

Sign ([Number])

Sign(-13).
Preview Result: -1.

Sign(13).
Preview Result: 1

Sqrt

Returns to the square root of a specified number

Sqrt ([Number])

Sqrt(100).
Preview Result: 10

Substring

Retrieves a substring from this instance. The substring starts at a specified character position and has a specified length

Substring ([Arg], [Number], [Number])

Example: "New Refinery" under attribute: Highest Plant Group.
Substring( [Highest Plant Group],1,3 ). Preview Result: New

An EDE View cannot be filtered using the Start and Length filters if the query has Suppress Repeating Values selected. This applies only to Microsoft SQL server database users.

Sum

Sum(Number1, Number2…)

Adds the numbers in Attribute columns which contain numerical fields

Sum(10,6,4).
Preview Result: 20

ToNumber

Converts string to number

ToNumber([Attribute1])

ToString

Converts number to string

ToString([Number1])

Trim

Removes leading and trailing space characters from a string

Trim([Attribute])

Example: To remove spaces between the quotes and the first letter M, in M-101 FAULT STATUS , under attribute: Instrument Service

Trim([Instrument Service], " M-101 FAULT STATUS")

Result Preview: "M-101 FAULT STATUS"

Replace

Replaces characters of a specified string with other specified string characters

Replace([Attribute],"string","string" )

Example: "F-101 Middle section", under attribute: Instrument Service

Replace([Instrument Service], "Middle", "Lower")  Result Preview: Lower

ToDate

Converts parameters to date and time format according to the computer's operating system time and calendar

ToDate(YY,MM,DD,hh,mm,ss) or
ToDate(YY,MM,DD)

If(ToDate(15,01,13)< [Changed], ‘OK’, ‘TooLate’)

ToUpper

Converts all letters in a string to uppercase

ToUpper([Attribute])

Example: “F-102 top" under attribute: Instrument Service. ToUpper([Instrument Service])

Result Preview: F-102 TOP

ToLower

Converts all letters in a string to lowercase

ToLower([Attribute])

Example: “ M -101 FAULT STATUS" under attribute: Instrument Service ToLower([Instrument Service])

Result Preview: m -101 fault status