Page Comparison

logical1 AND logical2

Logical AND operator

logical1 OR logical2

Logical OR operator

NOT(logical)

Logical NOT operator

TRUE

Returns the logical value TRUE.

FALSE

Returns the logical value FALSE.

abs(number)

Absolute value from the expression

ceiling(number)

Turns a Real number to its nearest greater Integer

floor(number)

Turns a Real number to its nearest lesserInteger

round(number)

Turns a Real number to its lesser (<=0.5) or greater (>0.5) Integer

round-half-to-even(real,long)

Rounds a real number with the required decimals

toFloat(number or string)

Transforms a number or string to Float

toInteger(number or string)

Transforms a number or string to Integer

random()

Returns a random number

left(String, Int)

Trims a string from the left a number of characters

right(String, Int)

Trims a string from the right a number of characters

starts-with(String, String)

Returns if a string starts with another string

ends-with(String, String)

Returns if a string ends with another string

lower-case(String)

Returns the lowercase string of the string

upper-case(String)

Returns the uppercase string of the string

capitalize-first(String)

Returns the string with the first letter in uppercase

compare(String, String)

Returns an integer (-1, 0, 1) resulting of the comparison of the strings

contains(String, String)

Returns if a string contains another string

matches(String, Regex)

Returns if a string matches a regular expression

concat(String, String)

Concatenates two strings (resulting in another string)

index-of-string-first(String, String)

Returns an integer representing the first position of a substring within a string

Returns the string without all the spaces and identation characters

substring(String, Int)

Returns the string that is the substring of the string from a position. example: substring("abcd",2)="bcd"

substring(String, Int, Int)

Returns the string that is the substring of the string from a position with a length given. example: substring("abcd",1,2)="bc"

substring-before(String, String)

Returns the string that is the substring that appears before the first occurrence of another specified string.  example: substring-before("abcd","b")="a"

substring-after(String, String)

Returns the string that is the substring that appears after the first occurrence of another specified string. example: substring-after("abcd","b")="cd"

replace(string, Regex, String)

Replaces all the occurrences of the regular expression by the chosen string.    example: replace("baba","b","cd")="cdacda"

replace-first(string, Regex, String)

Replaces the first occurrence of the regular expression by the chosen string.    example: replace-first("baba","b","cd")="cdaba"

count(path, [condition])

Counts the number of times the path is repeated on the source data (with optional condition)

sum(path, [condition])

min(path, [condition])

Returns the minimum value on the selected path (with optional condition)

avg(path, [condition])

Returns the average for the numeric values on the selected path that (with optional condition)

toISODate(date,"yyyy-MM-dd")

Transforms a string to a ISO date, being first parameter the date you want to read and the second parameter the pattern to read it

toISOTime(time,"HH:mm:ss")

Transforms a string to a ISO time, being first parameter the date you want to read and the second parameter the pattern to read it

toISODateTime(datetime,"yyyy-MM-dd'T'HH:mm:ss")

Transforms a string to a ISO date time, being first parameter the date you want to read and the second parameter the pattern to read it

monthNameFromValue(Int, Int)

Returns the name of the month from a value (from 1 = January to 12 = December) and a length of the desired output string. Any 0 or negative length returns the full word

day-from-date(date)

Extracts days value from an ISO Date

day-from-dateTime(datetime)

Extracts days value from an ISO DateTime

hours-from-dateTime(datetime)

Extracts hours value from an ISO DateTime

hours-from-time(time)

Extracts hours value from an ISO Time

minutes-from-dateTime(datetime)

TExtracts minutes value from an ISO DateTime

minutes-from-time(time)

Extracts minutes value from an ISO Time

calculates the total number of whole days in a normalized duration value. This is not necessarily the same as the integer that appears before the D in the value. For example, if the duration is P1DT36H, the function returns 2 rather than 1. This is because 36 hours is equal to 1.5 days, and the normalized value is therefore P2DT12H. This function does not round the number of days; if the duration is 2 days and 23 hours, it returns the integer 2.

uuid()

This function generates a unique identifier.

node-id(path)

Returns an unique id calculated from the source structure path

detDescription(code)

Returns the description of a given ontology code

isnull(value)

Value refers to an empty value.