50 Administrator’s Guide
BMC Atrium Integration Engine 7.1.00
min(any,any,any,
...)
(where any is a
constant, field name,
or function)
function|min
("a", "b", "c")
Returns the minimum value from a
set of values (all must be the same
data type):
a
All data types are supported.
These can be field references or
constants. Any
non-null value (positive or
negative) is greater than null.
minute(timestamp)
(where timestamp is a
constant, field name,
or function)
function|minute
($createdate$)
(if $createdate$ is set to
Friday, August 3, 2007
12:15:00 a.m.)
Returns the minute of the time
stamp (0 to 59):
15
month(timestamp)
(where timestamp is a
constant, field name,
or function)
function|month
($createdate$)
(if $createdate$ is set to
Friday, August 3, 2007
12:15:00 a.m.)
Returns the month of the time
stamp (1 to 12):
1
null() function|null()
Returns a null value. This is mostly
used in queries to see if a value is
null. Integration Engine does not
set an AR System value or a BMC
Atrium CMDB attribute to null:
null value
replace(string,
string,string,...)
(where string is a
constant, field name,
or function)
function|replace
("abcdefghi",
"def",
"xxx")
Replaces all instances of a value in
a character string with a new
value:
abcxxxghi
You can use field references or
constants.
right(string,long)
(where string and
long are constants,
field names, or
functions)
function|right
("Allie",2)
Returns the right-most bytes of a
character string up to the indicated
number of bytes:
ie
round(real)
(where real is a
constant, field name,
or function)
function|round(5.1)
Returns the rounded value of a real
number (5.1 to 5.4 are rounded to
5; 5.5 to 5.9 are rounded to 6):
5
rpad(string,long,
string)
(where string and
long are constants,
field names, or
functions)
function|rpad("ABC",10,
"000000LEAD")
Returns the value that results from
padding a character string to the
right with another string, to a
specified length:
ABC000LEAD
Table 3-4: Function syntax examples
Function Example Results
