Difference between revisions of "Functions"

From webCoRE Wiki - Web-enabled Community's own Rule Engine
Jump to: navigation, search
Line 1: Line 1:
 
Functions are extensions to expressions that allow data processing and conversion. Here is a list of all defined functions
 
Functions are extensions to expressions that allow data processing and conversion. Here is a list of all defined functions
 +
 +
 +
=[[Variable_data_types#String|String]] functions=
 +
 +
==concat==
 +
:Syntax
 +
::<code>''string'' concat(''dynamic'' value1, ''dynamic'' value2[, .., ''dynamic'' valueN])</code>
 +
:Returns
 +
::Returns a string that is the concatenation of all the supplied values. This function accepts two or more input values.
 +
 +
==contains==
 +
:Syntax
 +
::<code>''boolean'' contains(''string'' haystack, ''string'' needle)</code>
 +
:Returns
 +
::Returns true if the <code>needle</code> is found anywhere in the <code>haystack</code>
 +
 +
==endsWith==
 +
:Syntax
 +
::<code>''boolean'' endsWith(''string'' haystack, ''string'' needle)</code>
 +
:Returns
 +
::Returns true if <code>haystack</code> ends with the <code>needle</code>
 +
 +
==format==
 +
:Syntax
 +
::<code>''string'' format(''string'' formatString[, ''dynamic'' value1[, .., ''dynamic'' valueN]])</code>
 +
:Returns
 +
::Returns a string that is built based on the <code>formatString</code> with arguments replaced by their corresponding values. Follows the java syntax for <code>printf()</code>. See a quick reference [https://www.cs.colostate.edu/~cs160/.Summer16/resources/Java_printf_method_quick_reference.pdf here], or a more detailed reference [https://sharkysoft.com/archive/printf/docs/javadocs/lava/clib/stdio/doc-files/specification.htm Reference here].
 +
::Each % in the format string represents an argument and corresponds to a value (in order of appearance) in the value list. Each argument can have formatting settings, according to the reference provided.
 +
:Example
 +
::<code>format('The temperature outside is %.2f degrees Fahrenheit', [Temp sensor:temperature])</code> outputs <code>The temperature outside is 71.26 degrees Fahrenheit</code>
 +
::The <code>%.2f</code> translates to "format as <code>f</code>loat and use <code>.2</code> decimal places.
 +
 +
==left==
 +
:Syntax
 +
::<code>''string'' left(''string'' value, ''integer'' length)</code>
 +
:Returns
 +
::Returns the first <code>length</code> characters in <code>value</code>
 +
:Examples
 +
::<code>left("hello world", 2)</code> outputs <code>he</code>
 +
 +
==lower==
 +
:Syntax
 +
::<code>''string'' lower(''string'' value)</code>
 +
:Returns
 +
::Returns the <code>value</code> but with all lower case letters.
 +
:Examples
 +
::<code>lower("Hello World")</code> outputs <code>hello world</code>
 +
 +
==mid==
 +
:Syntax
 +
::<code>''string'' mid(''string'' value, ''integer'' start[, ''integer'' count = remaining])</code>
 +
:Arguments
 +
::<code>start</code> - provides the 0-based index of the first character to copy. If <code>start</code> is negative, the counting starts from the end of <code>value</code>.
 +
::<code>count</code> - provides the number of characters to copy from <code>value</code>. If not provided, all of the remaining characters from <code>value</code> are returned, starting with character number <code>start</code>. If <code>count</code> is negative, prior characters are returned.
 +
:Returns
 +
::Returns a substring of <code>value</code>, <code>count</code> characters long, starting at character number <code>start</code>. Note that the first character in any string has index 0.
 +
:Examples
 +
::<code>mid("Hello World", 2, 3)</code> outputs <code>llo</code>
 +
::<code>mid("Hello World", 2)</code> outputs <code>llo World</code>
 +
::<code>mid("Hello World", -5, 2)</code> outputs <code>Wo</code>
 +
::<code>mid("Hello World", -1, -3)</code> outputs <code>orl</code>
 +
 +
==replace==
 +
:Syntax
 +
::<code>''string'' replace(''string'' haystack, ''string'' needle1, ''string'' replacement1[, .., ''string'' needleN, ''string'' replacementN])</code>
 +
:Returns
 +
::Replaces all the occurrences of <code>needle</code> inside <code>haystack</code> with its respective <code>replacement</code>. Multiple pairs of <code>needle</code>/<code>replacement</code> can be provided in one function call.
 +
:Regular expressions
 +
::Needles support regular expressions when their value starts and ends with a <code>/</code>. For example, <code>'/(\s)/'</code> will match all spaces.
 +
:Examples
 +
::<code>replace("Hello World", 'World', 'Earth')</code> outputs <code>Hello Earth</code>
 +
::<code>replace("Hello World", 'World', 'Earth', 'Hello', 'Hi')</code> outputs <code>Hi Earth</code>
 +
::<code>replace("Hello World", 'World', 'Earth', 'Earth', 'Planet')</code> outputs <code>Hello Planet</code>
 +
 +
==right==
 +
:Syntax
 +
::<code>''string'' right(''string'' value, ''integer'' length)</code>
 +
:Returns
 +
::Returns the last <code>length</code> characters in <code>value</code>
 +
:Examples
 +
::<code>right("hello world", 4)</code> outputs <code>orld</code>
 +
 +
==startsWith==
 +
:Syntax
 +
::<code>''boolean'' startsWith(''string'' haystack, ''string'' needle)</code>
 +
:Returns
 +
::Returns true if <code>haystack</code> starts with the <code>needle</code>
 +
 +
==string==
 +
:Syntax
 +
::<code>''string'' string(''dynamic'' value)</code>
 +
:Returns
 +
::Returns <code>value</code> as a string.
 +
 +
==substr==
 +
:Alias of <code>mid()</code>
 +
 +
==substring==
 +
:Alias of <code>mid()</code>
 +
 +
==title==
 +
:Syntax
 +
::<code>''string'' title(''string'' value)</code>
 +
:Returns
 +
::Returns the <code>value</code> but in its title case format (each word starts with a capitalized letter).
 +
:Examples
 +
::<code>lower("Hello there world")</code> outputs <code>Hello There World</code>
 +
 +
==upper==
 +
:Syntax
 +
::<code>''string'' upper(''string'' value)</code>
 +
:Returns
 +
::Returns the <code>value</code> but with all upper case letters.
 +
:Examples
 +
::<code>lower("Hello World")</code> outputs <code>HELLO WORLD</code>
 +
 +
==text==
 +
:Alias of <code>string()</code>
 +
 +
 +
 +
 +
 +
=Numeric functions=
 +
 +
==avg==
 +
:Syntax
 +
::<code>''decimal'' avg(''decimal'' value1, ''decimal'' value2[, .., ''decimal'' valueN])</code>
 +
:Returns
 +
::Returns the mean average of all the values provided.
 +
 +
==ceil==
 +
:Syntax
 +
::<code>''integer'' ceil(''decimal'' value)</code>
 +
:Returns
 +
::Returns the integer part of a decimal, equivalent to rounding the decimal down.
 +
 +
==ceiling==
 +
:Alias of <code>ceil</code>
 +
 +
==decimal==
 +
:Syntax
 +
::<code>''decimal'' decimal(''dynamic'' value)</code>
 +
:Returns
 +
::Converts <code>value</code> into a decimal. Returns <code>0</code> if <code>value</code> is not numeric.
 +
 +
==float==
 +
:Alias of <code>decimal</code>
 +
 +
==floor==
 +
:Syntax
 +
::<code>''integer'' ceil(''decimal'' value)</code>
 +
:Returns
 +
::Returns the immediately higher integer, equivalent to rounding the decimal up.
 +
 +
==max==
 +
:Syntax
 +
::<code>''dynamic'' max(''dynamic'' value1, ''dynamic'' value2[, .., ''dynamic'' valueN])</code>
 +
:Returns
 +
::Returns the maximum of all the values provided. Note: this function works with both numbers and strings.
 +
 +
==median==
 +
:Syntax
 +
::<code>''dynamic'' median(''dynamic'' value1, ''dynamic'' value2[, .., ''dynamic'' valueN])</code>
 +
:Returns
 +
::Returns the median average of all the values provided. Note: this function works with both numbers and strings.
 +
 +
==min==
 +
:Syntax
 +
::<code>''dynamic'' min(''dynamic'' value1, ''dynamic'' value2[, .., ''dynamic'' valueN])</code>
 +
:Returns
 +
::Returns the minimum of all the values provided. Note: this function works with both numbers and strings.
 +
 +
==number==
 +
:Alias of <code>decimal</code>
 +
 +
==power==
 +
:Syntax
 +
::<code>''decimal'' power(''decimal'' value, ''decimal'' exponent)</code>
 +
:Returns
 +
::Returns the <code>value</code> at the power of <code>exponent</code>
 +
 +
==round==
 +
:Syntax
 +
::<code>''decimal'' round(''decimal'' value[, ''integer'' precision = 0])</code>
 +
:Arguments
 +
::<code>precision</code> - the number of decimal places to be retained. If not provided, defaults to <code>0</code>
 +
:Returns
 +
::Returns the rounded <code>value</code> with <code>precision</code> decimal places.
 +
 +
==sqr==
 +
:Syntax
 +
::<code>''decimal'' sqr(''decimal'' value)</code>
 +
:Returns
 +
::Returns the squared <code>value</code>, equivalent to <code>value</code> multiplied by itself.
 +
 +
==sqrt==
 +
:Syntax
 +
::<code>''decimal'' sqrt(''decimal'' value)</code>
 +
:Returns
 +
::Returns the square root of <code>value</code>.
 +
 +
==stdev==
 +
:Syntax
 +
::<code>''decimal'' stdev(''decimal'' value1, ''decimal'' value2[, .., ''decimal'' valueN])</code>
 +
:Returns
 +
::Returns the standard deviation of all the values provided.
 +
 +
==sum==
 +
:Syntax
 +
::<code>''decimal'' sum(''decimal'' value1, ''decimal'' value2[, .., ''decimal'' valueN])</code>
 +
:Returns
 +
::Returns the sum of sum of all the values provided.
 +
 +
==variance==
 +
:Syntax
 +
::<code>''decimal'' variance(''decimal'' value1, ''decimal'' value2[, .., ''decimal'' valueN])</code>
 +
:Returns
 +
::Returns the variance of all the values provided.
 +
 +
 +
 +
  
 
=[[Variable_data_types#Boolean|Boolean]] functions=
 
=[[Variable_data_types#Boolean|Boolean]] functions=
Line 60: Line 283:
 
::Returns the negated truth state of <code>value</code>. This is the logical negation of <code>[[Functions#bool|bool]](''dynamic'' value)</code>.
 
::Returns the negated truth state of <code>value</code>. This is the logical negation of <code>[[Functions#bool|bool]](''dynamic'' value)</code>.
  
−
=[[Variable_data_types#Date|Date]] functions=
+
=[[Variable_data_types#Date_and_Time|Date and time]] functions=
−
 
 
−
==date==
 
−
:Syntax
 
−
::<code>date(''datetime'' value)</code>
 
−
:Returns
 
−
::Returns the date portion of <code>value</code> by stripping off time information.
 
−
 
 
−
=[[Variable_data_types#Date_and_Time|Datetime]] functions=
 
  
 
==addDays==
 
==addDays==
Line 100: Line 315:
 
::Returns a datetime that is <code>weeks</code> weeks after the <code>value</code>. For negative values of <code>weeks</code>, it returns a datetime that is <code>weeks</code> weeks before <code>value</code>.
 
::Returns a datetime that is <code>weeks</code> weeks after the <code>value</code>. For negative values of <code>weeks</code>, it returns a datetime that is <code>weeks</code> weeks before <code>value</code>.
  
−
= [[Variable_data_types#Number_.28Decimal.29|Decimal]] =
+
==date==
−
;avg(values)
+
:Syntax
−
:calculates the average of a series of numeric values
+
::<code>date(''datetime'' value)</code>
−
;ceil()
+
:Returns
−
://todo
+
::Returns the date portion of <code>value</code> by stripping off time information.
−
;ceiling(decimal or string)
+
 
−
:converts a decimal value to it's closest higher integer value
+
==datetime==
−
;celsius(temperature)
+
:Syntax
−
:converts temperature from Fahrenheit to Celsius
+
::<code>''datetime'' datetime(''dynamic'' value)</code>
−
;decimal(integer or string)
+
:Returns
−
:converts an integer value to it's decimal value
+
::Tries to convert any value into a datetime. Accepts strings in common date/time formats.
−
;dewPoint(temperature, relativeHumidity[, scale])
+
 
−
:returns the calculated dew point temperature
+
 
−
;fahrenheit([Sensor;temperature])
+
==formatDuration==
−
:converts temperature from Celsius to Fahrenheit
+
:Syntax
−
;float()
+
::<code>''string'' formatDuration(''datetime'' value[, ''boolean'' friendly = false[, ''string'' granularity = 's'[, ''boolean'' showAdverbs = false]]])</code>
−
://todo
+
:Arguments
−
;floor(decimal or string)
+
::<code>friendly</code> - <code>false</code> makes the output compact, in the form of <code>0d 00:00:00.000</code>, while <code>true</code> makes the output more human friendly, in the form of <code> 0 days, 0 hours, 0 minutes, and 0 seconds</code>. Defaults to <code>false</code>.
−
:converts a decimal value to it's closest lower integer value
+
::<code>granularity</code> - represents the smallest time unit to be output. One of <code>d</code> for days, <code>h</code> for hours, <code>m</code> for minutes, <code>s</code> for seconds, or <code>ms</code> for milliseconds. Any time unit below the selected granularity will not be output. Defaults to <code>s</code>
−
;max(values)
+
::<code>showAdverbs</code> - only affects the friendly output, when <code>true</code> the words <code>in</code> (for future durations - positive input) or <code>ago</code> (for past durations - negative input) are prepended or appended respectively to the output
−
:calculates the maximum of a series of numeric values
+
:Returns
−
;median(values)
+
::Returns a string that represents the duration in a human readable format
−
:returns the value in the middle of a sorted array
+
:Examples
−
;min(values)
+
::<code>formatDuration(12029)</code> will output <code>00:00:12</code>
−
:calculates the minimum of a series of numeric values
+
::<code>formatDuration(68493, true)</code> will output <code>1 minute and 8 seconds</code>
−
;number()
+
::<code>formatDuration(68493, false, 'ms')</code> will output <code>00:01:08</code>
−
://todo
+
::<code>formatDuration(68493, true, 'm', true)</code> will output <code>in 1 minute</code>
−
;power(integer or decimal or string, power)  
+
 
−
:converts a decimal value to it's power decimal value
+
==time==
−
;round(decimal or string, [precision])
+
:Syntax
−
:converts a decimal value to it's rounded value
+
::<code>''time'' time(''datetime'' value)</code>
−
;sqr(integer or decimal or string)  
+
:Returns
−
:converts a decimal value to it's square decimal value
+
::Returns the time portion of <code>value</code> by stripping off date information.
−
;sqrt(integer or decimal or string)  
+
 
−
:converts a decimal value to it's square root decimal value
+
 
−
;stdev(values)
+
 
−
:calculates the standard deviation of a series of numeric values
+
=Weather related functions=
−
;sum(values)
+
 
−
:calculates the sum of a series of numeric values
+
==celsius==
−
;variance(values)
+
:Syntax
−
:calculates the standard deviation of a series of numeric values
+
::<code>''decimal'' celsius(''decimal'' value)</code>
 +
:Returns
 +
::Converts a temperature value from Fahrenheit to Celsius.
 +
 
 +
==dewPoint==
 +
:Syntax
 +
::<code>''decimal'' dewPoint(''decimal'' temperature, ''decimal'' relativeHumidity[, ''string'' scale = 'F'])</code>
 +
:Parameters
 +
::<code>scale</code> - optional, one of <code>C</code> or <code>F</code>, corresponding to the temperature range used for <code>temperature</code>. The result will be provided in the same scale. If no scale is provided, the Fahrenheit scale will be used.
 +
:Returns
 +
::Returns the due temperature for a given temperature and relative humidity
 +
 
 +
==fahrenheit==
 +
:Syntax
 +
::<code>''decimal'' fahrenheit(''decimal'' value)</code>
 +
:Returns
 +
::Converts a temperature value from Celsius to Fahrenheit.
 +
 
 +
 
  
 
= [[Variable_data_types#Dynamic|Dynamic]] =
 
= [[Variable_data_types#Dynamic|Dynamic]] =
Line 168: Line 401:
 
:returns the number of milliseconds an attribute had the previous value
 
:returns the number of milliseconds an attribute had the previous value
  
−
=[[Variable_data_types#String|String]] functions=
 
−
 
−
==concat==
 
−
:Syntax
 
−
::<code>''string'' concat(''dynamic'' value1, ''dynamic'' value2[, .., ''dynamic'' valueN])</code>
 
−
:Returns
 
−
::Returns a string that is the concatenation of all the supplied values. This function accepts two or more input values.
 
−
 
−
==contains==
 
−
:Syntax
 
−
::<code>''boolean'' contains(''string'' haystack, ''string'' needle)</code>
 
−
:Returns
 
−
::Returns true if the <code>needle</code> is found anywhere in the <code>haystack</code>
 
−
 
−
==endsWith==
 
−
:Syntax
 
−
::<code>''boolean'' endsWith(''string'' haystack, ''string'' needle)</code>
 
−
:Returns
 
−
::Returns true if <code>haystack</code> ends with the <code>needle</code>
 
−
 
−
==format==
 
−
:Syntax
 
−
::<code>''string'' format(''string'' formatString[, ''dynamic'' value1[, .., ''dynamic'' valueN]])</code>
 
−
:Returns
 
−
::Returns a string that is built based on the <code>formatString</code> with arguments replaced by their corresponding values. Follows the java syntax for <code>printf()</code>. See a quick reference [https://www.cs.colostate.edu/~cs160/.Summer16/resources/Java_printf_method_quick_reference.pdf here], or a more detailed reference [https://sharkysoft.com/archive/printf/docs/javadocs/lava/clib/stdio/doc-files/specification.htm Reference here].
 
−
::Each % in the format string represents an argument and corresponds to a value (in order of appearance) in the value list. Each argument can have formatting settings, according to the reference provided.
 
−
:Example
 
−
:: <code>format('The temperature outside is %.2f degrees Fahrenheit', [Temp sensor:temperature])</code> outputs <code>The temperature outside is 71.26 degrees Fahrenheit</code>
 
−
:: The <code>%.2f</code> translates to "format as <code>f</code>loat and use <code>.2</code> decimal places.
 
−
 
−
;formatDuration(value[, friendly = false[, granularity = 's'[, showAdverbs = false]]])
 
−
:Usage:
 
−
::value is a number of milliseconds
 
−
::friendly = true/false (false >>> 0d 00:00:00.000, true >>> so many days, so many hours, etc)
 
−
::granularity = one of ms, s, m, h, d (smallest part displayed)
 
−
::showAdverbs = true/false, true adds the in .... or .... ago to friendly times
 
−
:returns a nicely formatted string of time
 
−
:eg: formatDuration(12029) - 00:00:12 | formatDuration(12029, true) - 12 seconds | formatDuration(12029, true, "m") - 0 minutes | formatDuration(12029, true, "ms", true) - in 12 seconds and 29 milliseconds
 
−
 
−
;left(string, count)
 
−
:returns a substring of a value
 
−
:Example1: <code>left("hello world", 3)</code> outputs <code>hel</code>
 
−
:Example2: <code>left("hello world", 7)</code> outputs <code>hello w</code>
 
−
 
−
;lower(string)
 
−
:returns a lower case value of a string
 
−
:Example: <code>lower("HELLO WORLD")</code> outputs <code>hello world</code>
 
−
 
−
;mid(string, start, count)
 
−
:returns a substring of a value
 
−
:returns characters (including spaces) specified by count after start position from string
 
−
:Example1: <code>mid("hello world", 3, 4)</code> returns <code>lo w</code>
 
−
:Example2: <code>mid("hello world", 6, 3)</code> returns <code>wor</code>
 
−
 
−
;replace(string, search, replace[, [..], search, replace])
 
−
:replaces a search text inside of a value
 
−
:Example1: <code>replace("hello world", "world", "earth")</code> returns <code>hello earth</code>
 
−
:Example2: <code>replace(replace("[hello world]", "\[", "("),"\]",")")</code> returns <code>(hello world)</code>
 
−
: Note: There are special characters in regular expressions that needs to be escaped or the script will return an error, in the above example [ and ] are special characters.
 
−
 
−
;right(string, count)
 
−
:returns a substring of a value
 
−
;sprintf(format, arguments)
 
−
:formats a series of values into a string
 
−
;string(anything)
 
−
:converts a value to it's string value
 
−
;substring(string, start, count)
 
−
:returns a substring of a value
 
−
 
−
==startsWith==
 
−
:Syntax
 
−
::<code>''boolean'' startsWith(''string'' haystack, ''string'' needle)</code>
 
−
:Returns
 
−
::Returns true if <code>haystack</code> starts with the <code>needle</code>
 
  
−
;text()
 
−
://todo
 
−
;title(string)
 
−
:returns a title case value of a string
 
−
;upper(string)
 
−
:returns an upper case value of a string
 
  
 
= [[Variable_data_types#Time|Time]] =
 
= [[Variable_data_types#Time|Time]] =

Revision as of 16:44, 6 May 2017

Functions are extensions to expressions that allow data processing and conversion. Here is a list of all defined functions


String functions

concat

Syntax
string concat(dynamic value1, dynamic value2[, .., dynamic valueN])
Returns
Returns a string that is the concatenation of all the supplied values. This function accepts two or more input values.

contains

Syntax
boolean contains(string haystack, string needle)
Returns
Returns true if the needle is found anywhere in the haystack

endsWith

Syntax
boolean endsWith(string haystack, string needle)
Returns
Returns true if haystack ends with the needle

format

Syntax
string format(string formatString[, dynamic value1[, .., dynamic valueN]])
Returns
Returns a string that is built based on the formatString with arguments replaced by their corresponding values. Follows the java syntax for printf(). See a quick reference here, or a more detailed reference Reference here.
Each % in the format string represents an argument and corresponds to a value (in order of appearance) in the value list. Each argument can have formatting settings, according to the reference provided.
Example
format('The temperature outside is %.2f degrees Fahrenheit', [Temp sensor:temperature]) outputs The temperature outside is 71.26 degrees Fahrenheit
The %.2f translates to "format as float and use .2 decimal places.

left

Syntax
string left(string value, integer length)
Returns
Returns the first length characters in value
Examples
left("hello world", 2) outputs he

lower

Syntax
string lower(string value)
Returns
Returns the value but with all lower case letters.
Examples
lower("Hello World") outputs hello world

mid

Syntax
string mid(string value, integer start[, integer count = remaining])
Arguments
start - provides the 0-based index of the first character to copy. If start is negative, the counting starts from the end of value.
count - provides the number of characters to copy from value. If not provided, all of the remaining characters from value are returned, starting with character number start. If count is negative, prior characters are returned.
Returns
Returns a substring of value, count characters long, starting at character number start. Note that the first character in any string has index 0.
Examples
mid("Hello World", 2, 3) outputs llo
mid("Hello World", 2) outputs llo World
mid("Hello World", -5, 2) outputs Wo
mid("Hello World", -1, -3) outputs orl

replace

Syntax
string replace(string haystack, string needle1, string replacement1[, .., string needleN, string replacementN])
Returns
Replaces all the occurrences of needle inside haystack with its respective replacement. Multiple pairs of needle/replacement can be provided in one function call.
Regular expressions
Needles support regular expressions when their value starts and ends with a /. For example, '/(\s)/' will match all spaces.
Examples
replace("Hello World", 'World', 'Earth') outputs Hello Earth
replace("Hello World", 'World', 'Earth', 'Hello', 'Hi') outputs Hi Earth
replace("Hello World", 'World', 'Earth', 'Earth', 'Planet') outputs Hello Planet

right

Syntax
string right(string value, integer length)
Returns
Returns the last length characters in value
Examples
right("hello world", 4) outputs orld

startsWith

Syntax
boolean startsWith(string haystack, string needle)
Returns
Returns true if haystack starts with the needle

string

Syntax
string string(dynamic value)
Returns
Returns value as a string.

substr

Alias of mid()

substring

Alias of mid()

title

Syntax
string title(string value)
Returns
Returns the value but in its title case format (each word starts with a capitalized letter).
Examples
lower("Hello there world") outputs Hello There World

upper

Syntax
string upper(string value)
Returns
Returns the value but with all upper case letters.
Examples
lower("Hello World") outputs HELLO WORLD

text

Alias of string()



Numeric functions

avg

Syntax
decimal avg(decimal value1, decimal value2[, .., decimal valueN])
Returns
Returns the mean average of all the values provided.

ceil

Syntax
integer ceil(decimal value)
Returns
Returns the integer part of a decimal, equivalent to rounding the decimal down.

ceiling

Alias of ceil

decimal

Syntax
decimal decimal(dynamic value)
Returns
Converts value into a decimal. Returns 0 if value is not numeric.

float

Alias of decimal

floor

Syntax
integer ceil(decimal value)
Returns
Returns the immediately higher integer, equivalent to rounding the decimal up.

max

Syntax
dynamic max(dynamic value1, dynamic value2[, .., dynamic valueN])
Returns
Returns the maximum of all the values provided. Note: this function works with both numbers and strings.

median

Syntax
dynamic median(dynamic value1, dynamic value2[, .., dynamic valueN])
Returns
Returns the median average of all the values provided. Note: this function works with both numbers and strings.

min

Syntax
dynamic min(dynamic value1, dynamic value2[, .., dynamic valueN])
Returns
Returns the minimum of all the values provided. Note: this function works with both numbers and strings.

number

Alias of decimal

power

Syntax
decimal power(decimal value, decimal exponent)
Returns
Returns the value at the power of exponent

round

Syntax
decimal round(decimal value[, integer precision = 0])
Arguments
precision - the number of decimal places to be retained. If not provided, defaults to 0
Returns
Returns the rounded value with precision decimal places.

sqr

Syntax
decimal sqr(decimal value)
Returns
Returns the squared value, equivalent to value multiplied by itself.

sqrt

Syntax
decimal sqrt(decimal value)
Returns
Returns the square root of value.

stdev

Syntax
decimal stdev(decimal value1, decimal value2[, .., decimal valueN])
Returns
Returns the standard deviation of all the values provided.

sum

Syntax
decimal sum(decimal value1, decimal value2[, .., decimal valueN])
Returns
Returns the sum of sum of all the values provided.

variance

Syntax
decimal variance(decimal value1, decimal value2[, .., decimal valueN])
Returns
Returns the variance of all the values provided.



Boolean functions

bool

Syntax
bool(dynamic value)
Returns
Returns the truth value of the input. Accepts anything as input and will return true if value is either a non-zero number, a non-empty string (with some exceptions, see below), a non-empty device list, a non-empty date/time/datetime

boolean

This is an alias of bool

eq

Syntax
eq(dynamic value1, dynamic value2)
Returns
Returns true if value1 is equivalent to value2

ge

Syntax
ge(dynamic value1, dynamic value2)
Returns
Returns true if value1 is greater than or equal to value2

gt

Syntax
gt(dynamic value1, dynamic value2)
Returns
Returns true if value1 is greater than value2

isBetween

Syntax
isBetween(dynamic value, dynamic startValue, dynamic startValue)
Returns
Returns true if value is greater then or equal to startValue and less than or equal to endValue

isEmpty

Syntax
isEmpty(dynamic value)
Returns
Returns true if value is not set, an empty string, or zero

le

Syntax
le(dynamic value1, dynamic value2)
Returns
Returns true if value1 is less than or equal to value2

lt

Syntax
lt(dynamic value1, dynamic value2)
Returns
Returns true if value1 is less than value2

not

Syntax
not(dynamic value)
Returns
Returns the negated truth state of value. This is the logical negation of bool(dynamic value).

Date and time functions

addDays

Syntax
addDays(datetime value, integer days)
Returns
Returns a datetime that is days days after the value. For negative values of days, it returns a datetime that is days days before value.

addHours

Syntax
addHours(datetime value, integer hours)
Returns
Returns a datetime that is hours hours after the value. For negative values of hours, it returns a datetime that is hours hours before value.

addMinutes

Syntax
addMinutes(datetime value, integer minutes)
Returns
Returns a datetime that is minutes minutes after the value. For negative values of minutes, it returns a datetime that is minutes minutes before value.

addSeconds

Syntax
addSeconds(datetime value, integer seconds)
Returns
Returns a datetime that is seconds seconds after the value. For negative values of seconds, it returns a datetime that is seconds seconds before value.

addWeeks

Syntax
addWeeks(datetime value, integer weeks)
Returns
Returns a datetime that is weeks weeks after the value. For negative values of weeks, it returns a datetime that is weeks weeks before value.

date

Syntax
date(datetime value)
Returns
Returns the date portion of value by stripping off time information.

datetime

Syntax
datetime datetime(dynamic value)
Returns
Tries to convert any value into a datetime. Accepts strings in common date/time formats.


formatDuration

Syntax
string formatDuration(datetime value[, boolean friendly = false[, string granularity = 's'[, boolean showAdverbs = false]]])
Arguments
friendly - false makes the output compact, in the form of 0d 00:00:00.000, while true makes the output more human friendly, in the form of 0 days, 0 hours, 0 minutes, and 0 seconds. Defaults to false.
granularity - represents the smallest time unit to be output. One of d for days, h for hours, m for minutes, s for seconds, or ms for milliseconds. Any time unit below the selected granularity will not be output. Defaults to s
showAdverbs - only affects the friendly output, when true the words in (for future durations - positive input) or ago (for past durations - negative input) are prepended or appended respectively to the output
Returns
Returns a string that represents the duration in a human readable format
Examples
formatDuration(12029) will output 00:00:12
formatDuration(68493, true) will output 1 minute and 8 seconds
formatDuration(68493, false, 'ms') will output 00:01:08
formatDuration(68493, true, 'm', true) will output in 1 minute

time

Syntax
time time(datetime value)
Returns
Returns the time portion of value by stripping off date information.


Weather related functions

celsius

Syntax
decimal celsius(decimal value)
Returns
Converts a temperature value from Fahrenheit to Celsius.

dewPoint

Syntax
decimal dewPoint(decimal temperature, decimal relativeHumidity[, string scale = 'F'])
Parameters
scale - optional, one of C or F, corresponding to the temperature range used for temperature. The result will be provided in the same scale. If no scale is provided, the Fahrenheit scale will be used.
Returns
Returns the due temperature for a given temperature and relative humidity

fahrenheit

Syntax
decimal fahrenheit(decimal value)
Returns
Converts a temperature value from Celsius to Fahrenheit.


Dynamic

if(condition, valueIfTrue, valueIfFalse)
evaluates a boolean and returns value1 if true, or value2 otherwise
least(values)
returns the value that is least found a series of numeric values
most(values)
returns the value that is most found a series of numeric values
previousValue([device;attribute])
returns the previous value of the attribute

Integers

age([device;attribute])
returns the number of milliseconds an attribute had the current value
count(values)
calculates the number of true/non-zero/non-empty items in a series of numeric values
int()
//todo
integer(decimal or string)
converts a decimal value to it's integer value
newer([device;attribute],[...], [device;attribute], threshold)
returns the number of devices whose attribute had the current value for less than the specified number of milliseconds
older([device;attribute],[...], [device;attribute], threshold)
returns the number of devices whose attribute had the current value for more than the specified number of milliseconds
previousAge([device;attribute])
returns the number of milliseconds an attribute had the previous value


Time

time(value)
returns the value as a time type
addSeconds(dateTime, seconds)
adds seconds to time, returns the value as a time type
addMinutes(dateTime, minutes)
adds minutes to time, returns the value as a time type
addHours(dateTime, hours)
adds hours to time, returns the value as a time type
addDays(dateTime, days)
adds days to time, returns the value as a time type
addWeeks(dateTime, weeks)
adds weeks to time, returns the value as a time type
Retrieved from "https://wiki.webcore.co/index.php?title=Functions&oldid=319"