A table of predefined XPath functions for use with message maps.
Name | Parameters | Notes |
---|---|---|
true | ||
false | ||
sum | Source field from the message or database. | Source has to be a numeric type and repeats. |
avg | ||
max | ||
min | ||
count | Source field from the message or database. | |
concat | Two, or more, strings. | You cannot use fn:concat($source/myElem) to concatenate instances of 'myElem'. |
not | 1- Expression resolved to a Boolean value. | |
exists | Source field from the message or database. | |
empty | ||
substring | 1- String |
For example: fn:substring($source/po:purchaseOrder/billTo/street, 3, 5) |
year-from-dateTime | 1- xs:dateTime | For example: fn:month-from-dateTime(xs:dateTime($source/po:purchaseOrder/shipTo/datetime)) where $source/po:purchaseOrder/shipTo/datetime is xs:string. |
month-from-dateTime | ||
day-from-dateTime | ||
hours-from-dateTime | ||
minutes-from-dateTime | ||
seconds-from-dateTime | ||
year-from-date | 1-xs:date | For example: fn:year-from-date(xs:date($source/po:purchaseOrder/billTo/date)) where $source/po:purchaseOrder/billTo/date is xs:string. |
month-from-date | ||
day-from-date | ||
hours-from-time | 1- xs:time | Some examples: fn:hours-from-time(xs:time("13:20:10:5")) |
minutes-from-time | ||
seconds-from-time | ||
years-from-duration | 1- xdt:dayTimeDuration | For example: fn:minutes-from-duration(xdt:dayTimeDuration(PT47H30M)) |
months-from-duration | ||
days-from-duration | ||
hours-from-duration | ||
minutes-from-duration | ||
seconds-from-duration |