XQuery Reference Guide
|
 |
 |
|
|
 |
 |
The World Wide Web (W3C) specification for XQuery supports a discrete set of functions. BEA Liquid Data for WebLogic supports a subset of those functions as built-in functions. The Liquid Data built-in functions are accessible in the Data View Builder from Builder Toolbar—>Toolbox tab—>Functions panel.
For more information on the functions described here, see also:
This section provides a complete reference of the W3C functions Liquid Data supports, as well as any extended functions Liquid Data supports. This functions reference is organized by category as follows:
You can browse the Liquid Data XQuery functions in the Data View Builder. The functions are located in the Design tab —> Toolbox tab —> XQuery Functions. You can also make your own custom functions. This section describes the conventions used in the Liquid Data XQuery functions and describes the XQuery data types.
The xf: prefix is a W3C XML naming convention, also known as a namespace. Liquid Data supports extended functions that are enhancements to the XQuery specification, which you can recognize by their extended function prefix xfext:. For example, the full XQuery notation for an extended function is xfext:function_name. Extended functions accept standard input types, but they are limited to single values.
Liquid Data also supports extensions to XQuery data types that are designated with xsext:datatype notation. When you encounter the xsext: prefix, it means that the data type may have Liquid Data-imposed restrictions that are necessary to interface successfully with the Liquid Data Server.
The xfext: prefix identifies an extended function. The prefix identifies the type of function to you but the Data View Builder does not recognize or process the prefix.
An occurrence indicator indicates the number of items in a sequence. This notation usually appears on a parent node in a schema. Use these identifiers to determine the repeatability of a node.
These occurrence indicators also communicate information about the data type when they appear in a function signature. For example:
Every data element or variable has a data type. Function parameters have data type requirements and the function result is returned as a data type. The following table describes other data types that conform to the XQuery specification. Current compliance with the W3C XQuery specification extends to XQuery 1.0 and XPath 2.0 Functions and Operators specification dated 30 April 2002. Another helpful reference is XML Schema Part 2: Datatypes.
You can construct date and time patterns using standard Java class symbols. The following table shows the pattern symbols you can use.
Repeat each symbol to match the maximum number of characters required to represent the actual value. For example, to represent 4 July 2002, the pattern is d MMMM yyyy. To represent 12:43 PM, the pattern is hh:mm a.
Accessor and node functions operate on different types of nodes and node values. They accept single node input and return a value based on the node type. These function are not available in the XQuery functions section of the Data View Builder, but the Data View Builder will, in some circumstances, generate queries that use these functions. The functions available are:
Returns the typed-value of each input node. This function is not available in the XQuery functions section of the Data View Builder.
The xf:data function is available to Liquid Data, but you cannot explicitly map a node in the Data View Builder, so you therefore cannot construct a query in the Data View Builder that uses the xf:data function. In some cases, however, the Data View Builder will implicitly generate queries that use the xf:data function. The typical case when the Data View Builder generates the xf:data function is when it does not know the name of the elements at query generation time, and it uses the xf:data function in a variable expression containing wildcard characters.
If the source value is not a node, the function returns an error.
xf:data(<a>{3}</a>) returns the numeric value 3. xf:data(<a/>) returns an empty list (). xf:data((<a>{3}</a>, <a>{7}</a>)) generates a compile-time error because the parameter is a list of nodes. xf:data(<date location="SD">2002-07-12</date>) returns the string value "2002-07-12.".xf:data(3) generates a compile-time error because 3 is not a node.Returns the specified document. This function is not available in the XQuery functions section of the Data View Builder.
The input of this version of the xf:document function is the logical name of a Liquid Data data source.
Use the xf:document function to specify an XML document. Because Liquid Data models data sources as XML documents, the XML document specified can represent a relational database, an XML file, or other data sources registered in the Liquid Data Administration Console. The xf:document function is available to Liquid Data, but you cannot explicitly map a node in the Data View Builder. In many cases, however, the Data View Builder implicitly generates queries that use the xf:document function.
xf:document("My_Relational_DS")
Returns the specified document for the given dynamic data source. This function is not available in the XQuery functions section of the Data View Builder.
This version of the xf:document function is used with dynamic XML and delimited file data sources (a dynamic data source is a data source in which the data file is specified at query runtime). For the first input, specify the logical name of a Liquid Data data source. For the second input, specify a URL or file (absolute path or relative to the Liquid Data Repository for the type of data source).
Use the xf:document function to specify an XML document. Because Liquid Data models data sources as XML document, the XML document specified can represent a relational database, an XML file, or other data sources registered in the Liquid Data Administration Console. The xf:document function is available to Liquid Data, but you cannot explicitly map a node in the Data View Builder. In many cases, however, the Data View Builder implicitly generates queries that use the xf:document function.
xf:document("My_XML_DS", "c:\myFolder\file.xml")
Returns a string value that corresponds to the local name of the specified node. This function is not available in the XQuery functions section of the Data View Builder.
The xf:local-name function is available to Liquid Data, but you cannot explicitly map a node in the Data View Builder, so you therefore cannot construct a query in the Data View Builder that uses the xf:local-name function. In some cases, however, the Data View Builder will implicitly generate queries that use the xf:local-name function. The typical case when the Data View Builder generates the xf:local-name function is when it does not know the name of the elements at query generation time, and it uses the xf:local-name function in a variable expression containing wildcard characters.
xf:local-name(<db:homes/>) returns the string value "homes."xf:local-name(73) generates a compile-time error because the parameter is a number and not a node.
Aggregate functions process a sequence as argument and return a single value computed from values in the sequence. Except for the Count function, if the sequence contains nodes, the function extracts the value from the node and uses it in the computation. The following aggregate functions are available:
Returns the average of a sequence of numbers.
If the source value contains nodes, the value of each node is extracted using the xf:data function. If an empty list occurs, it is discarded.
If the source value contains only numbers, the Avg function returns the average of the numbers, which is the sum of the source sequence divided by the count of the source sequence.
If the source value is an empty list, the function returns an empty list.
If the source value contains non-numeric data, the function returns an error.
Liquid Data requires a list of double precision values instead of a list of items.
xf:avg((4, 10)) returns the double precision floating point value 7.0.xf:avg((4, (), 10)) also returns the double precision floating point value 7.0.xf:avg((4, "10")) generates a compile-time error because the input sequence contains a string.Returns the number of items in the sequence in an unsigned integer.
If the source value is an empty list, the function returns an empty list.
Liquid Data returns an integer value (xs:integer) instead of an unsigned int (xs:unsignedInt) value.
xf:count((3, "10")) returns the integer value 2. xf:count(()) returns the integer value 0. xf:count((3, "10", (), )) returns the value 3 (the empty list is ignored). Returns the maximum value from a sequence. If there are two or more items with the same value, the specific item whose value is returned is implementation-dependent.
If the source value contains nodes, the value of each node is extracted using the xf:data function. If an empty list occurs, it is discarded.
All values in the list must be instances of one of the following types:
For example, if the list contains items with typed values that represent both decimal values and dates, an error will occur.
The values in the sequence must have a total order:
Both of these conditions must be true; otherwise, the function returns an error.
Returns the minimum value from a sequence of numbers. If there are two or more items with the same value, the specific item whose value is returned is implementation-dependent.
If the source value contains nodes, the value of each node is extracted using the Data function. If an empty list occurs, it is discarded.
After extracting the values from nodes, the sequence must contain only values of a single type.
The values in the sequence must have a total order:
Both of these conditions must be true; otherwise, the function returns an error.
xf:min((3, 10)) returns the value 3.xf:min((<a>{4}</a>, 3, (), <b>{2}</b>)) returns <b>{2}</b>.xf:min((3, 4, "2")) generates an error because the sequence contains both numeric and string values.xf:min(()) returns an empty list ().Returns the sum of a sequence of numbers.
If the source value contains nodes, the value of each node is extracted using the Data function. If an empty list occurs, it is discarded.
If the source value contains only numbers, the Sum function returns the sum of the numbers.
If the source value contains non-numeric data, the function returns an error.
If the input sequence is empty, the function returns an empty list.
xf:sum((3, 8, (), 1)) returns the value 12. xf:sum(()) returns an empty list ().xf:sum((<a>{4}</a>, 3)) returns a value of 7.xf:sum(("7", 3)) generates a compile-time error because the sequence that is passed in to the function is not homogenous.
Boolean functions return true (1) or false(0) values. The following boolean functions are available:
Returns the boolean value false.
Conforms to the current specification.
xf:false() returns false. xf:false(34) generates a compile-time error because the function does not accept any parameters.Returns true if the value of the source value is false and false if the value of the source value is true.
xf:not(xf:false()) returns the boolean value true.xf:not(xf:true()) returns the boolean value false.xf:not(32) generates a compile-time error because the input value is not boolean.xf:not(()) returns the boolean value true.Returns the boolean value true.
Conforms to the current specification.
xf:true() returns true.xf:true("34") generates a compile-time error because the function does not accept any parameters.
Cast functions process a source value as the argument and type cast the output to a different datatype. Type casting will typically fail if applied to more than one element. An empty list is allowed, but the result of the type casting will consist of an empty list. Type casting functions are more likely to generate exceptions at run time if the parameter cannot be converted to the corresponding type.
The following table describes Liquid Data data types that conform to the XQuery specification that you can use in type casting functions. For more information about data types, see the XQuery 1.0 and XPath 2.0 Functions and Operators specification. The following cast functions are available:
Converts the input to a boolean value (true or false).
If the input parameter is empty, the function returns an empty list. Otherwise, Liquid Data generates an error.
This function uses the xf:boolean-from-string function.
Conforms to the current specification; however, Liquid Data does not accept the values "1" and "0" to represent true and false, as described in the W3C XML Schema document.
cast as xs:boolean ("true") returns the boolean value true.cast as xs:boolean ("FalSE") returns the boolean value false.cast as xs:boolean (0) generates a runtime error because the value cannot be cast to a boolean value.cast as xs:boolean (1) generates a runtime error because the value cannot be cast to a boolean value.cast as xs:boolean (()) returns an empty list ().Converts the input to a byte value.
This function uses the xf:byte function.
This function will complete sucessfully only if the value cast is a numeric value greater than -128 or less than 128; all other values will fail.
Conforms to the current specification.
cast as xs:byte(22) returns the byte value of 22.cast as xs:byte(22.9334) returns the byte value 22.Converts the input to a date value.
This function uses the xf:date function.
The string must contain a date in one of these formats:
where YYYY represents the year, MM represents the month (as a number), DD represents the day, hh and mm represents the number of hours and minutes that the timezone differs from GMT (UTC). Z indicates that the date is in the GMT timezone.
If the string cannot be parsed into a date value, Liquid Data generates an error.
Conforms to the current specification.
cast as xs:date ("2002-07-23") returns the date 2002-07-23.cast as xs:date ("2002-07") generates a runtime error because the value cannot be converted to a date.Converts the input to a dateTime value.
This function uses the xf:date function.
Conforms to the current specification.
cast as xs:dateTime ("2002-07-23T23:04:44") returns the dateTime value July 23rd, 2002 at 11:04:44 PM in the local timezone.cast as xs:dateTime ("2002-07-23T23:04:44-08:00") returns the dateTime value July 23rd, 2002 at 11:04:44 PM in the a timezone that is offset by -8 hours from GMT (UTC).cast as xs:date ("2002-07-23") generates a runtime error because no time value is specified.Converts the input to a decimal value.
This function uses the xf:decimal function.
cast as xs:decimal ("213") returns the decimal value 213.cast as xs:decimal ("-100") returns the decimal value -100.cast as xs:decimal (0) returns the decimal value 0.Converts the input to a double precision value.
This function uses the xf:double function.
cast as xs:double ("21") returns the double precision value 21.0.cast as xs:double ("-3e3") returns the double precision value -3000.0.cast as xs:double (0) returns the double precision value 0.0.cast as xs:double ("abc) generates a runtime error because the string cannot be converted to a double precision value.Converts the input to a floating point value.
This function uses the xf:float function.
cast as xs:float ("21") returns the floating point value 21.0.cast as xs:float ("-3e3") returns the floating point value -3000.0.cast as xs:float (0) returns the floating point value 0.0.cast as xs:float ("abc) generates a runtime error because the string cannot be converted to a floating point value.Converts the input to an int value.
This function uses the xf:int function.
Conforms to the current specification.
Converts the input to an integer value.
This function uses the xf:integer function.
Conforms to the current specification.
Converts the input to a long value.
This function uses the xf:long function.
Conforms to the current specification.
Converts the input to a short value.
This function uses the xf:short function.
Conforms to the current specification.
Converts the input to a string value.
This function uses the xf:string function.
xf:string as both a constructor and an accessor.xsext:anyType input instead of a list of items.cast as xs:string ("abc") returns the string value abc.cast as xs:string (21) returns the string value 21.cast as xs:string (xf:true()) returns the string value true.cast as xs:string (xf:false()) returns the string value false.Converts the input to a time value.
This function uses the xf:time function.
Conforms to the current specification.
cast as xs:time ("09:35:20") returns the time value 9:35:20 AM in the current timezone.cast as xs:time (<a>09:35:20</a>) returns the time value 9:35:20 AM in the current timezone.cast as xs:time ("9:35:20") generates a runtime error because the time format is incorrect (hour specified with 1 digit instead of 2) and therefore the string cannot be converted to a time value.cast as xs:time ("21:35:20-08:00") returns the time value 9:35:20 PM in the a timezone that is offset by -8 hours from GMT (UTC).
XQuery has operators that are specific to comparisons operations. The following operators are available:
Returns true if Parameter1 is exactly equal to Parameter2.
This is a comparison operator that you can use as a function to compare operands.
If either operand is a node, Liquid Data extracts its typed value first, then performs a type check to ensure that the type of one operand is promotable to the other type; otherwise Liquid Data generates an error.
If either operand is an empty list, the function returns an empty list.
Returns true if Parameter1 is greater than or equal to Parameter2.
This is a comparison operator that you can use as a function to compare operands.
If either operand is a node, Liquid Data extracts its typed value first, then performs a type check to ensure that the type of one operand is promotable to the other type; otherwise Liquid Data generates an error.
If either operand is an empty list, the function returns an empty list.
See the examples for eq.
Returns true if Parameter1 is greater than Parameter2.
This is a comparison operator that you can use as a function to compare operands.
If either operand is a node, Liquid Data extracts its typed value first, then performs a type check to ensure that the type of one operand is promotable to the other type; otherwise Liquid Data generates an error.
If either operand is an empty list, the function returns an empty list.
Liquid Data does not cast xs:anySimpleType to any other supported type.
Liquid Data does not support these data types: xs:yearMonthDuration, xs:dayTimeDuration, gregorian, xs:hexBinary, xs:base64Binary, xs:anyURI, xs:QName, or xs:NOTATION values.
See the examples for the "eq" operator (previous entry in this table).
Returns true if Parameter1 is less than or equal to Parameter2.
This is a comparison operator that you can use as a function to compare operands.
If either operand is a node, Liquid Data extracts its typed value first, then performs a type check to ensure that the type of one operand is promotable to the other type; otherwise Liquid Data generates an error.
If either operand is an empty list, the function returns an empty list.
Liquid Data does not cast xs:anySimpleType to any other supported type.
Liquid Data does not support these data types: xs:yearMonthDuration, xs:dayTimeDuration, gregorian, xs:hexBinary, xs:base64Binary, xs:anyURI, xs:QName, or xs:NOTATION values.
See the examples for for eq.
Returns true if Parameter1 is less than or equal to Parameter2.
This is a comparison operator that you can use as a function to compare operands.
If either operand is a node, Liquid Data extracts its typed value first, then performs a type check to ensure that the type of one operand is promotable to the other type; otherwise Liquid Data generates an error.
If either operand is an empty list, the function returns an empty list.
Liquid Data does not cast xs:anySimpleType to any other supported type.
Liquid Data does not support these data types: xs:yearMonthDuration, xs:dayTimeDuration, gregorian, xs:hexBinary, xs:base64Binary, xs:anyURI, xs:QName, or xs:NOTATION values.
See the examples for for eq.
The result is false if both values are false and true if at least one of the values is true. Parameter2 is not evaluated if Parameter1 evaluates to true.
This is a boolean operator that you can use as a function to return a true or false result. It is not a standard XQuery operator, but necessary to complete certain comparative expressions in Liquid Data.
The arguments and return type are all boolean.
If either operand is a node, Liquid Data extracts its typed value first, then performs a type check to ensure that the type of one operand is promotable to the other type; otherwise Liquid Data generates an error.
If either operand is an empty list, the function returns an empty list.
Liquid Data does not support these data types: xs:yearMonthDuration, xs:dayTimeDuration, gregorian, xs:hexBinary, xs:base64Binary, xs:anyURI, xs:QName, or xs:NOTATION values.
See the examples for eq.
Constructor functions process a source value as the argument. Every data element or variable has a data type. The data type determines the value that any function parameter can contain and the operations that can be performed on it. The Liquid Data supports the following type casting functions. The following constructor functions are available:
Returns a boolean value of true or false from the string source value.
If the input parameter is empty, the function returns an empty list. Otherwise, Liquid Data generates an error.
xf:boolean-from-string("true") returns the boolean value true.xf:boolean-from-string("FaLSe") returns the boolean value false.xf:boolean-from-string("43") generates a runtime error because the input value cannot be parsed into a boolean value.xf:boolean-from-string(43) generates a compile-time error because the input value is not a string.Constructs a byte integer value from the string source value.
An error occurs if the source value is greater than 127 or less than -128.
Liquid Data truncates the input if it is a non-integer number.
If the number falls outside of the range of byte values, the number wraps.
If the number is an integer that falls within the range, the value is unchanged.
If the input is a string, Liquid Data tries to parse it into a byte value.
If the input is the boolean value true, the function returns 1. If it is false, it returns 0.
xf:byte('127') returns the byte value one hundred twenty seven. xf:byte(38) returns the byte value 38. xf:byte("-4") returns the byte value -4.xf:byte(128) returns the byte value -128 because the number wraps.xf:byte(-129) returns the byte value 127 because the number wraps. xf:byte(xf:true()) returns the byte value 1. xf:byte(xf:false()) returns the byte value 0. xf:byte("true") generates a runtime error because the string literal cannot be converted to a byte value.xf:byte('128') returns an error because one hundred twenty eight is invalid for a byte integer expression. Constructs a decimal value from the source value.
xf:decimal("3") returns the decimal value 3. xf:decimal(99.1) returns the decimal value 99.1 (the same value that is input to the function). xf:decimal(xf:true()) returns the decimal value 1.xf:decimal(xf:false()) returns the decimal value 0.xf:decimal("true") generates a runtime error because the string literal cannot be converted to a decimal value.Constructs a double precision value from the source value.
xf:double("3") returns the double precision floating point value 3.0.xf:double(5.1) returns the double precision floating point value 5.1.xf:double(xf:true()) returns the double precision floating point value 1.0.xf:double(xf:false()) returns the double precision floating point value 0.0.xf:double("true") generates a runtime error because the string literal cannot be converted to a double precision floating point value.xf:double("12345678901234567890") evaluates to the double precision floating point value 1.2345678901234567E19.Constructs a floating point value from the source value.
xf:float(1) returns the floating-point value 1.0.xf:float("1") returns the floating-point value 1.0.xf:float(xf:true()) returns the floating point value 1.0.xf:float(xf:false()) returns the floating-point value 0.0.xf:float("true") generates a runtime error because the string literal cannot be converted to a floating-point value.xf:float("12345678901234567890") returns the floating-point value 1.2345679E19.Constructs an integer value from the source value. The largest integer value is limited to a 32-bit expression.
An error occurs if the source value is greater than 2,147,483,647 or less than -2,147,483,648. To the Liquid Data Server, the xf:int function is exactly the same as the xf:integer function.
xf:int(4056) returns the int value 4056.xf:int("-35") returns the int value -35.xf:int(xf:true()) returns the int value 1.xf:int(xf:false()) returns the int value 0.xf:int("true") generates a runtime error because the string literal cannot be converted to an int value.Constructs an integer value from the source value. The largest integer value is limited to a 32-bit expression.
An error occurs if the source value is greater than 2,147,483,647 or less than -2,147,483,648. To the Liquid Data Server, the xf:integer function is exactly the same as the xf:int function.
xf:integer(4056) returns the int value 4056.xf:integer("-35") returns the int value -35.xf:integer(xf:true()) returns the int value 1.xf:integer(xf:false()) returns the int value 0.xf:integer("true") generates a runtime error because the string literal cannot be converted to an int value.Constructs a four-byte integer value from the source value. Use a long integer data type when the value exceeds the limitations imposed by other integer data types.
An error occurs if the source value is greater than 9,223,372,036,854,775,807 or less than -9,223,372,036,854,775,808.
xf:long(1) returns the long integer value 1.xf:long("-91") returns the long integer value -91.xf:long(xf:true()) returns the long integer value 1.xf:long(xf:false()) returns the long integer value 0. xf:long("true") generates a runtime error because the string literal cannot be converted to a long integer value.Constructs a two-byte integer value from the source value. The largest short integer value is limited to a 16-bit expression.
An error occurs if the source value is greater than 32,767 or less than -32,768.
xf:short(1) returns the short integer value 1.xf:short("-91") returns the short integer value -91.xf:short(xf:true()) returns the short integer value 1.xf:short(xf:false()) returns the short integer value 0.xf:short("true") generates an error because the string literal cannot be converted to a short integer value.Constructs a string value from the source value. The source value can be a sequence, a node of any kind, or a simple value.
Liquid Data accepts any simple value, but supports no other accessor types, such as a sequence or other type of node.
xf:string(1) returns the string value 1.xf:string("-91") returns the string value -91.xf:string(xf:true()) returns the string value true.xf:string(xf:false()) returns the string value false.xf:string("abc", "def") generates a compile-time error because the function does not accept two parameters.xf:string(("abc", "def")) generates a compile-time error because the function does not accept a sequence as parameter.xf:string(<a/>) returns an empty string value "".xf:string(<a>abc</a>) returns the string value abc.
Date and Time functions extract all or part of a dateTime expression and use it in a query. The following date and time functions are available:
Adds the number of days specified by Parameter2 to the date specified by Parameter1. The value of Parameter2 may be negative.
If Parameter1 has a timezone, it remains unchanged. The returned value is always normalized into a correct Gregorian calendar date. If either parameter is an empty list, the function returns an empty list.
Conforms to the current specification.
xf:add-days(xf:date("2002-07-15"), -3) returns a date value corresponding to July 12, 2002.xf:add-days(xf:date("2002-07-15"), 0) returns a date value corresponding to July 15, 2002.xf:add-days(xf:date("2002-07-15"), 2) returns a date value corresponding to July 17, 2002.xf:add-days("2002-07-15", 2) generates a compile-time error because the first parameter is a string and not a date value.Returns the current date and time.
Returned data type: xs:dateTime
The function returns the current date and time in the current timezone.
If the function is called multiple times during the execution of a query, it returns the same value each time.
Liquid Data returns the time zone where the Liquid Data Server is running.
xf:current-dateTime() can return a dateTime value such as 2002-07-25T01:00:38.812-08:00, which represents July 25th, 2002 at 1:00:38 and 812 thousandths of a second in a time zone that is offset by -8 hours from GMT (UTC).
Takes a string (rather than dateTime) and a parameter and returns a date from a source value, which must contain a date in one of these formats:
The representation for date is the leftmost representation for dateTime: YYYY-MM-DD+hh:mm with an optional following time zone indicator (Z).
Liquid Data supports this year range: 0000-9999.
Conforms to the current specification.
xf:date("2002-07-15") returns a date value corresponding to July 15th, 2002 in the current time zone.xf:date("2002-07-15-08:00") returns a date value corresponding to July 15th, 2002 in a timezone that is offset by -8 hours from GMT (UTC).xf:date("2002-7-15") generates a runtime error because the month is not specified with two digits.xf:date("2002-07-15Z") returns a date value corresponding to July 15th, 2002 in the GMT time zone.xf:date("2002-02-31") generates a runtime error because the string (02-31) does not represent a valid date.Returns a dateTime value from a source value, which must contain a date and time in one of these formats:
Returns a date and time in YYYY-MM-DDT+hh:mm:ss format.
This expression can be preceded by an optional leading minus (-) sign to indicate a negative number. If the sign is omitted, positive (+) is assumed.
Use additional digits to increase the precision of fractional seconds if desired. The format ss.ss... with any number of digits after the decimal point is supported. Fractional seconds are optional.
Liquid Data supports this year range: 0000-9999.
Conforms to the current specification.
xf:dateTime("2002-07-15T21:09:44") returns a date value corresponding to July 15th, 2002 at 9:09PM and 44 seconds in the current time zone.xf:dateTime("2002-07-15T21:09:44.566") returns a date value corresponding to July 15th, 2002 at 9:09PM and 44.566 seconds in the current time zone xf:dateTime("2002-07-15T21:09:44-08:00") returns a date value corresponding to July 15th, 2002 at 9:09PM and 44 seconds, in a time zone that is offset by -8 hours from GMT (UTC).xf:dateTime("2002-7-15T21:09:44") generates a runtime error because the month is not specified using two digits xf:dateTime("2002-07-15T21:09:44Z") returns a date value corresponding to July 15th, 2002 at 9:09PM and 44 seconds, in the GMT timezone Returns an integer value representing the day identified in date.
The day value ranges from 1 to 31.
If the source value is an empty list, the function returns an empty list.
Conforms to the current specification.
xf:get-day-from-date(xf:date("2002-07-15")) returns the integer value 15.xf:get-hours-from-dateTime(()) returns an empty list ().Returns an integer value representing the day identified in dateTime.
The day value ranges from 1 to 31.
If the source value is an empty list, the function returns an empty list.
Conforms to the current specification.
xf:get-day-from-dateTime(xf:dateTime("2004-01-07T21:09:44")) returns the integer value 7.xf:get-hours-from-dateTime(()) returns an empty list ().Returns an integer value representing the hour identified in dateTime.
The hour value ranges from 0 to 23.
If the source value is an empty list, the function returns an empty list.
Conforms to the current specification.
xf:get-hours-from-dateTime(xf:dateTime("2002-07-15T21:09:44")) returns the integer value 21.xf:get-hours-from-dateTime(()) returns an empty list ().Returns an integer representing the hour identified in time.
The hour value ranges from 0 to 23, inclusive.
If the source value is an empty list, the function returns an empty list.
Conforms to the current specification.
xf:get-hours-from-time(xf:time("21:09:44")) returns the integer value 21.xf:get-hours-from-time(()) returns an empty list (). Returns an integer value representing the minutes identified in dateTime.
Returns an integer value representing the minute identified in the source value. The minute value ranges from 0 to 59, inclusive.
If the source value is an empty list, the function returns the empty list.
Conforms to the current specification.
xf:get-minutes-from-dateTime(xf:dateTime("2002-07-15T21:09:44")) returns the integer value 9.xf:get-minutes-from-dateTime(()) returns an empty list ().Returns an integer value representing the minutes identified in time.
The minute value ranges from 0 to 59.
If the source value is an empty list, the function returns an empty list.
Conforms to the current specification.
xf:get-minutes-from-time(xf:time("21:09:44")) returns the integer value 9.xf:get-minutes-from-time(()) returns an empty list ().Returns an integer value representing the month identified in date.
Returns an integer value representing the month identified in the source value. The month value ranges from 1 to 12, inclusive.
If the source value is an empty list, the function returns the empty list.
Conforms to the current specification.
xf:get-month-from-date(xf:date("2004-01-07")) returns the integer value 1.xf:get-month-from-date(()) returns an empty list ().Returns an integer value representing the month identified in dateTime.
The month value ranges from 1 to 12.
If the source value is an empty list, the function returns an empty list.
Conforms to the current specification.
xf:get-month-from-dateTime(xf:dateTime("2004-01-07T21:09:44")) returns the integer value 1.xf:get-month-from-dateTime(()) returns an empty list ().Returns an integer value representing the seconds identified in dateTime.
The seconds value ranges from 0 to 60.999. The precision (number of digits) of fractional seconds depends on the relevant facet of the argument.
The value can be greater than 60 seconds to accommodate occasional leap seconds used to keep human time synchronized with the rotation of the planet.
If the source value is an empty list, the function returns an empty list.
Conforms to the current specification.
xf:get-seconds-from-dateTime(xf:dateTime("2002-07-15T21:09:44")) returns the integer value 44.xf:get-seconds-from-dateTime(()) returns an empty list ().Returns an integer value representing the seconds identified in time.
The seconds value ranges from 0 to 60.999. The precision (number of digits) of fractional seconds depends on the relevant facet of the argument.
The value can be greater than 60 seconds to accommodate occasional leap seconds used to keep human time synchronized with the rotation of the planet.
If the source value is an empty list, the function returns an empty list.
Conforms to the current specification.
xf:get-seconds-from-time(xf:time("21:09:44")) returns the integer value 44.xf:get-seconds-from-time(()) returns an empty list ().Returns an integer value representing the year identified in date.
The year value ranges from 1000 to 999999.
If the source value is an empty list, the function returns an empty list.
Conforms to the current specification.
xf:get-year-from-date(xf:date("2004-01-07")) returns the integer value 2004.xf:get-year-from-date(()) returns an empty list ().Returns an integer value representing the year identified in dateTime.
The year value ranges from 1000 to 999999.
If the source value is an empty list, the function returns an empty list.
Conforms to the current specification.
xf:get-year-from-dateTime(xf:dateTime("2002-07-15T21:09:44")) returns the integer value 2004.xf:get-year-from-dateTime(()) returns an empty list ().Returns a tine from a source value, which must contain the time in one of these formats:
Liquid Data generates an error if it cannot parse the string successfully.
Conforms to the current specification.
xf:time("22:04:22") returns a time value corresponding to 10:04PM and 22 seconds in the current time zone.xf:time("22:04:22.343") returns a time value corresponding to 10:04PM and 22.343 seconds, in the current time zone.xf:time("22:04:22-08:00") returns a time value corresponding to 10:04PM and 22 seconds in a time zone that is offset by -8 hours from GMT (UTC).xf:time("22:4:22") generates a runtime error because the minutes are not specified with two digits.xf:time("22:04:22Z") returns a time value corresponding to 10:04PM and 22 seconds in the GMT time zone.Can be used to convert a dataTime to a date. Returns the leftmost date portion of a dateTime value.
This is an extended function. It has an xfext: prefix identifier (namespace), which is the extension to the standard XQuery function namespace (xf:). For more information about extended functions, see Naming Conventions. For more information about valid formats for dateTime, see xf:dateTime.
Liquid Data supports date-from-dateTime as an extended function.
xfext:date-from-dateTime(xf:dateTime("2002-07-15T21:09:44")) returns a date value corresponding to July 15th, 2002 in the current time zone.xfext:date-from-dateTime(()) returns an empty list ().Returns the right-most date portion of a dateTime value according to the pattern specified by Parameter1. For more information, see Date and Time Patterns.
This is an extended function. It has an xfext: prefix identifier (namespace), which is the extension to the standard XQuery function namespace (xf:). For more information about extended functions, see Naming Conventions.
Liquid Data supports date-from-string-with-format as an extended function.
xfext:date-from-string-with-format("yyyy-MM-dd G", "2002-06-22 AD") returns the specified date in the current time zone.xfext:date-from-string-with-format("yyyy-MM-dd", "2002-July-22") generates an error because the date string does not match the specified format.xfext:date-from-string-with-format("yyyy-MMM-dd", "2002-July-22") returns the specified date in the current time zone.Returns the date as a string formatted according to the pattern specified by Parameter1. For more information on the date patterns, see Date and Time Patterns.
This is an extended function. It has an xfext: prefix identifier (namespace), which is the extension to the standard XQuery function namespace (xf:). For more information about extended functions, see Naming Conventions.
Liquid Data supports date-to-string-with-format as an extended function.
xfext:date-to-string-with-format("yy-dd-mm", xf:date("2004-07-15")) returns the string 04-15-07.xfext:date-to-string-with-format("yyyy-mm-dd", xf:date("2004-07-15")) returns the string 2004-07-15.Returns a new dateTime value from a string source value according to the pattern specified by Parameter1.
This is an extended function. It has an xfext: prefix identifier (namespace), which is the extension to the standard XQuery function namespace (xf:).
For more information about extended functions, see Naming Conventions, and see Date and Time Patterns.
Liquid Data supports dateTime-from-string-with-format as an extended function.
xfext:dateTime-from-string-with-format("yyyy-MM-dd G", "2002-06-22 AD") returns the specified date, 12:00:00AM in the current time zone.xfext:dateTime-from-string-with-format("yyyy-MM-dd 'at' hh:mm", "2002-06-22 at 11:04") returns the specified date, 11:04:00AM in the current time zone.xfext:dateTime-from-string-with-format("yyyy-MM-dd", "2002-July-22") generates an error because the date string does not match the specified format.xfext:dateTime-from-string-with-format("yyyy-MMM-dd", "2002-July-22") returns 12:00:00AM in the current time zone.Returns the dateTime as a string formatted according to the pattern specified by Parameter1. For more information on the date patterns, see Date and Time Patterns.
This is an extended function. It has an xfext: prefix identifier (namespace), which is the extension to the standard XQuery function namespace (xf:). For more information about extended functions, see Naming Conventions.
Liquid Data supports dateTime-to-string-with-format as an extended function.
xfext:dateTime-to-string-with-format("dd MMMM yyyy hh:mm a G", xf:dateTime("2004-01-07T22:09:44")) returns the string 07 January 2004 10:09 PM AD.xfext:dateTime-to-string-with-format("MM-dd-yyyy", xf:dateTime("2004-01-07T22:09:44")) returns the string 01-07-2004.Returns the time from dateTime.
This is an extended function. It has an xfext: prefix identifier (namespace), which is the extension to the standard XQuery function namespace (xf:). For more information about extended functions, see Naming Conventions. For more information about valid formats for dateTime, see xf:dateTime.
Liquid Data supports time-from-dateTime as an extended function.
xfext:time-from-dateTime(xf:dateTime("2002-07-15T21:09:44")) returns a date value corresponding to 9:09:44PM in the current time zone.xfext:time-from-dateTime(()) returns an empty list ().Returns a new time value from a string source value according to the pattern specified by Parameter1.
This is an extended function. It has an xfext: prefix identifier (namespace), which is the extension to the standard XQuery function namespace (xf:).
For more information about extended functions, see Naming Conventions, and see Date and Time Patterns.
Liquid Data supports time-from-string-with-format as an extended function.
xfext:time-from-string-with-format("HH.mm.ss", "21.45.22") returns the time 9:45:22PM in the current time zone.xfext:time-from-string-with-format("hh:mm:ss a", "8:07:22 PM") returns the time 8:07:22PM in the current time zone.xfext:time-from-string-with-format("hh:mm:ss z", "8:07:22 EST") returns the time 8:07:22AM in the EST time zone.Returns the time as a string formatted according to the pattern specified by Parameter1. For more information on the date patterns, see Date and Time Patterns.
This is an extended function. It has an xfext: prefix identifier (namespace), which is the extension to the standard XQuery function namespace (xf:). For more information about extended functions, see Naming Conventions.
Liquid Data supports time-to-string-with-format as an extended function.
xfext:time-to-string-with-format("hh:mm a", xf:time("22:09:44")) returns the string 10:09 PM.xfext:time-to-string-with-format("HH:mm a", xf:time("22:09:44")) returns the string 22:09 PM.
XQuery has operators that are specific to logical operations. The following logical operators are available:
The result is true if both values are true, and false if one of the values is false.
This is a boolean operator that you can use as a function to return a true or false result.
The arguments and return type are all boolean.
The following table shows how Liquid Data determines the result. The leftmost column contains the possible values of the first parameter; the top row contains the possible values of the second parameter.
xf:true() and xf:true() returns the boolean value true.xf:true() and xf:false() returns the boolean value false.xf:false() and xf:false() returns the boolean value false.xf:true() and (<a/>, <b/>) generates a compile-time error because lists are not supported as input parameters to boolean operators.xf:false() and "false" generates a compile-time error because the second parameter is not a boolean value.The result is false if both values are false and true if at least one of the values is true. Parameter2 is not evaluated if Parameter1 is true.
This is a boolean operator that you can use as a function to return a true or false result.
The arguments and return type are all boolean.
The following table shows how Liquid Data determines the result. The leftmost column contains the possible values of the first parameter; the top row contains the possible values of the second parameter
xf:true() or xf:true() returns the boolean value true.xf:true() or xf:false() returns the boolean value true.xf:false() or xf:false() returns the boolean value false.xf:true() or (<a/>, <b/>) generates a compile-time error because lists are not supported as parameters to boolean operators.xf:false() or "false" generates a compile-time error because the second parameter is not a boolean value.
XQuery has operators that are specific to numeric operations. The following numeric operators are available:
Returns the arithmetic product of the operands: ($operand1*$operand2).
This is a numeric operator that you can use as if it were a function to compute numeric results.
The operator accepts two numeric values as parameters, computes their product, and returns the result.
Liquid Data applies the following rules:
12 * 3 returns the decimal value 36.xf:integer("1") * 3.1 returns the decimal value 3.1."abc" * "cde" generates a compile-time error because the operator can be used only with numbers.Returns the arithmetic sum of the operands: ($operand1+$operand2).
This is a numeric operator that you can use as if it were a function to compute numeric results.
The operator accepts two numeric values as parameters, computes their sum, and returns the result.
Liquid Data applies the following rules:
20 + 1 returns the decimal value 21.xf:integer("1") + 3.1 returns the decimal value 4.1."abc" + "cde" generates a compile-time error because the operator can only be used with numbers.Returns the arithmetic difference of the operands: ($operand1-$operand2).
This is a numeric operator that you can use as if it were a function to compute numeric results.
Liquid Data applies the following rules:
20 - 1 returns the decimal value 19.xf:integer("1") - 3.1 returns the decimal value -2.1."abc" - "cde" generates a compile-time error because the operator can only be used with numbers.Returns the arithmetic quotient of the operands ($operand1/$operand2).
This is a numeric operator that you can use as if it were a function to compute numeric results.
Liquid Data applies the following rules:
2 div 5 returns the decimal value 0.3 div 5 returns the decimal value 1.4 div "abc" generates a compile-time error because the operator can only be used with numbers.Returns the remainder after dividing the first operand by the second operand:
($operand1 mod $operand2).
This is a numeric operator that you can use as if it were a function to compute numeric results.
Liquid Data applies the following rules:
Liquid Data does not support not-a-number (NaN) or the negative and positive infinity values -INF and INF.
2 mod 5 returns the decimal value 2.3 mod 5 returns the decimal value -2.4 mod "abc" generates a compile-time error because the operator can only be used with numbers.
Numeric functions operate on numeric data types. The following numeric functions are available:
Returns the smallest (closest to negative infinity) integer that is not smaller than the source value.
If the argument is an empty list, the function returns an empty list.
Conforms to the current specification.
xf:ceiling(38.3) returns the integer value 39.xf:ceiling(38) returns the integer value 38.xf:ceiling(-3.3) returns the integer value -3.xf:ceiling("38.3") generates a compile-time error because the parameter is a string and not a numeric value.Returns the largest (closest to positive infinity) integer that is not greater than the source value.
If the argument is an empty list, the function returns an empty list.
Conforms to the current specification.
xf:floor(38.3) returns the integer value 38.xf:floor(38) returns the integer value 38.xf:floor(-3.3) returns the integer value -4.xf:floor("38.3") generates a compile-time error because the parameter is a string and not a numeric value.Returns the integer that is closest to the source value.
Round(x) produces the same result as the Floor function(x+0.5). If there are two such numbers, returns the one that is closest to +INF.
If the argument is +INF, returns +INF.
If the argument is -INF, returns -INF.
If the argument is +0, returns +0.
If the source value is an empty list, the function returns an empty list.
Liquid Data does not support not-a-number (NaN) or -0.
xf:round(3) returns the integer value 3.xf:round(3.3) returns the integer value 3.xf:round(3.5) returns the integer value 4.xf:round(3.7) returns the integer value 4.xf:round(-3.3) returns the integer value -3.xf:round(-3.5) returns the integer value -3.xf:round(-3.7) returns the integer value -4.xf:round(-0) returns the integer value 0.xf:round("3.3") generates an error because the parameter is a string and not a numeric value.Returns a decimal value rounded to the specified precision (scale).
The scale input is the precision with which to round the decimal input. A scale value of 1 rounds the input to tenths, a scale value of 2 rounds it to hundreths, and so on.
This is an extended function and is not part of the XQuery specification.
Returns a decimal value truncated to the specified precision (scale).
The scale input is the precision with which to truncate the decimal input. A scale value of 1 truncates the input to tenths, a scale value of 2 truncates it to hundreths, and so on.
This is an extended function and is not part of the XQuery specification.
xfext:decimal-truncate(127.444, 2) returns 127.44.xfext:decimal-truncate(0.1234567, 6) returns 0.123456.
The other functions folder is where the if-then-else function is in the Data View Builder.
The xfext:if-then-else function accepts the value of a boolean parameter to select one of two other input parameters.
The If-then-else function is an extended function. For more information about extended functions, see Naming Conventions.
Liquid Data examines the value of the first parameter. If the condition is true, Liquid Data returns the value of the second parameter (then). If the condition is false, Liquid Data returns the value of the third parameter (else). If the returned condition is not a boolean value, Liquid Data generates an error.
This is an extended function. Liquid Data converts it to an XQuery if-then-else expression.
xfext:if-then-else (xf:true(), 3, "10") returns the value 3.xfext:if-then-else (xf:false(), 3, "10") returns the string value 10.xfext:if-then-else ("true", 3, "10") generates a compile-time error because the condition is a string value and not a boolean value.
A sequence is an ordered collection of zero or more items. An item may be a node or a simple typed value. Therefore, a sequence can be an ordered collection of nodes, a collection of simple typed values, or any mix of nodes and simple typed values. Sequences may not contain other sequences but may contain duplicate items. There is no difference between a single item, such as a node or a simple typed value, and a sequence containing that single item.
If the source value contains only nodes, the function removes duplicates and returns a subset of unique values.
The Liquid Data xf:distinct-values function varies from the standard XQuery function by removing duplicates from the result.
If the source value is an empty list, the function returns an empty list.
xf:distinct-values(("a", "b", "c", "b")) returns the string abc.xf:distinct-values((<x>a</x>, <x>b</x>, <x>c</x>, <x>b</x>)) returns the string sequence (<x>a</x>, <x>b</x>, <x>c</x>).xf:distinct-values(("a", <x>b</x>, <x>c</x>, "b")) generates a compile-time error because the list contains mixed nodes and values.Returns true if the specified list of items is empty; otherwise, returns false.
Liquid Data supports an optional boolean returned value.
xf:empty((1, 2, 3)) returns the boolean value false.xf:empty(1) returns the boolean value false.xf:empty(()) returns the boolean value true.Returns the contiguous sequence of items described by Parameter 1 beginning at the position indicated by the Parameter 2 and continuing until the end of the sequence.
The first item of a sequence is located at position 1, not position 0.
If you omit the length parameter, the function returns all items up to the end of the source sequence.
If the starting location is greater than the number of items in the sequence, the function returns an empty list.
If the item list is empty, Liquid Data returns an empty list.
xf:subsequence(("a", "b", "c", "d", "e"), 2) returns the string value bcde.xf:subsequence("abcde", 2) returns the string value bcde.xf:subsequence("abcde", 6) returns the empty string "".xf:subsequence("abcde", 2, 3) returns the string value bcd.xf:subsequence("abcde", 2, 10) returns the string value bcde.xf:subsequence("abcde", ()) returns an empty list ().Returns the contiguous sequence of items described by Parameter 1 beginning at the position indicated by the Parameter 2 and continuing for the number of items indicated by the value of Parameter 3.
The value of Parameter 2 can be greater than the number of items in the value of Parameter 1, in which case the subsequence includes items to the end of Parameter 3.
If the sum of the starting location and the length parameter is greater than the length of the source sequence, the function returns all items up to the end of the sequence.
The first item of a sequence is located at position 1, not position 0.
If the starting location is greater than the number of items in the sequence, the function returns an empty list.
If the item list is an empty list, Liquid Data returns an empty list.
Liquid Data is able to process either format of xf:subsequence. Adding a third parameter automatically invokes Format 2.
xf:subsequence(("a", "b", "c", "d", "e"), 2) returns the string value bcde.xf:subsequence("abcde", 2) returns the string value bcde.xf:subsequence("abcde", 6) returns the empty string "".xf:subsequence("abcde", 2, 3) returns the string value bcd.xf:subsequence("abcde", 2, 10) returns the string value bcde.xf:subsequence("abcde", ()) returns an empty list ().
Strings from a character set may need to be sorted differently for different applications. You must consider the sort order when you invoke string comparisons. Some string functions will require understanding of the default sort order and any other special collation. The string functions are case sensitive. For more information, see the Character Model for the World Wide Web 1.0. The following string functions are available:
Returns -1, 0, or 1, depending on whether the value of Parameter1 is less than (-1), equal to (0), or greater than (1)the value of Parameter2.
If either argument is an empty list, the result is an empty list.
Liquid Data generates an error if either parameter is not a string.
Liquid Data does not support the xf:compare format that accepts collations.
xf:compare("a", "b") returns the integer value -1.xf:compare("a", "a") returns the integer value 0.xf:compare("b", "a") returns the integer value 1.xf:compare("a", 3) generates a compile-time error because the second parameter is not a string.xf:compare("a", ()) returns an empty list ().xf:compare((), "a") returns an empty list ().Returns a string that concatenates Parameter1 with Parameter2.
The result string may not reflect Unicode or other W3C normalization.
Returns an empty string if the function has no arguments. If any argument is an empty list, it is treated as an empty string.
Liquid Data generates an error if either parameter is not a string.
Liquid Data does not support a variable number of parameters to be concatenated. Choose only two strings to concatenate with each operation.
xf:concat("a", "b") returns the string value "ab."xf:concat("a", xf:concat("b", "c")) returns the string value "abc."xf:concat("abc", ()) returns the string value "abc."xf:concat((), "abc") returns the string value "abc."xf:concat((), ()) returns an empty list ().xf:concat("a", 4) generates a compile-time error because the second parameter is not a string.Returns a boolean value of true or false indicating whether Parameter1 contains a string that is equal to Parameter2 at the beginning, at the end, or anywhere within Parameter1.
If the value of Parameter2 is a zero-length string, the function returns true. If the value of Parameter1 is a zero-length string and the value of Parameter2 is not a zero-length string, the function returns false.
If the value of Parameter1 or Parameter2 is an empty list, the function returns an empty list.
Liquid Data generates an error if either parameter is not a string.
Liquid Data does not support the xf:contains format that accepts collations.
xf:contains("abc", "a") returns the boolean value true.xf:contains("abc", "b") returns the boolean value true.xf:contains("abc", "c") returns the boolean value true.xf:contains("abc", "d") returns the boolean value false.xf:contains("abc", "") returns the boolean value true.xf:contains("abc", ()) returns an empty list ().xf:contains((), "abc") returns an empty list ().xf:contains("abc", 4) generates a compile-time error because the second parameter is not a string.Returns a boolean value or true or false indicating whether Parameter1 ends with a string that is equal to Parameter2.
If Parameter2 is a zero-length string, then the function returns true. If Parameter1 is a zero-length string and Parameter2 is not a zero-length string, the function returns false.
If Parameter1 or Parameter2 is an empty list, the function returns an empty list.
Liquid Data generates an error if either parameter is not a string.
Liquid Data does not support the xf:ends-with format that accepts collations.
xf:ends-with("abc", "a") returns the boolean value false.xf:ends-with("abc", "b") returns the boolean value false.xf:ends-with("abc", "c") returns the boolean value true.xf:ends-with("abc", "d") returns the boolean value false.xf:ends-with("abc", "") returns the boolean value true.xf:ends-with("abc", ()) returns an empty list ().xf:ends-with((), "abc") returns an empty list ().xf:ends-with("abc", 4) generates a compile-time error because the second parameter is not a string.Returns the value of the input string after translating every uppercase letter to its corresponding lower-case value.
Every uppercase letter that does not have a lower-case corresponding value and every character that is not an uppercase letter appears in the output in its original form.
If the source value is an empty list, the function returns an empty list.
Conforms to the current specification.
xf:lower-case("ABc!D") returns the string value abc!d.xf:lower-case("") returns the empty string "".xf:lower-case(()) returns the empty list ().xf:lower-case(4) generates a compile-time error because the parameter is not a string. Returns a boolean value or true or false indicating whether Parameter1 starts with a string that is equal to Parameter2.
If Parameter2 is a zero-length string, then the function returns true. If Parameter1 is a zero-length string and tParameter2 is not a zero-length string, the function returns false.
If Parameter1 or Parameter2 is an empty list, the function returns an empty list.
Liquid Data generates an error if either parameter is not a string.
Liquid Data does not support the xf:ends-with format that accepts collations.
xf:starts-with("abc", "a") returns the boolean value true.xf:starts-with("abc", "b") returns the boolean value false.xf:starts-with("abc", "c") returns the boolean value false.xf:starts-with("abc", "d") returns the boolean value false.xf:starts-with("abc", "") returns the boolean value true.xf:starts-with("abc", ()) returns the empty list ().xf:starts-with((), "abc") returns the empty list ().xf:starts-with("abc", 4) generates a compile-time error because the second parameter is not a string.Returns an integer equal to the number of characters in the input source string.
If the source value is an empty list, the function returns an empty list.
Liquid Data generates an error if either parameter is not a string.
xf:string-length("abc") returns the integer value 3.xf:string-length("") returns the integer value 0.xf:string-length(()) returns the empty list ().xf:string-length(4) generates a compile-time error because the parameter is not a string.Returns that part of the Parameter1 source string from the starting location specified by Parameter2.
If the starting location is a negative value, or greater than the length of source string, an error occurs.
The first character of a string is located at position 1 (not position 0).
If Parameter1 or Parameter2 is an empty list, the function returns an empty list.
If you omit Parameter3, the function returns characters up to the end of the source string.
Liquid Data generates an error if Parameter1 is not a string or if the starting location is less than 1.
Returns that part of the Parameter1 source string from the starting location specified by Parameter2 and continuing for the number of characters equal to the length specified by Parameter3.
If the starting location is a negative value, or greater than the length of the source string, an error occurs.
The first character of a string is located at position 1 (not position 0).
If you omit length, the substring identifies characters to the end of the source string.
If length exceeds the number of characters in the source string, the function identifies only characters until the end of the source string.
If Parameter1, Parameter2, or Parameter3 is an empty list, the function returns an empty list.
Liquid Data generates an error if Parameter1 is not a string or if the starting location is less than 1.
Liquid Data is able to process either format of xf:substring. Adding a third parameter automatically invokes Format 2.
Returns that part of the Parameter1 source string that follows the first occurrence of those characters specified in Parameter2.
If Parameter2 is a zero-length string, the function returns the value of Parameter1. If Parameter1 is a zero-length string and Parameter2 is a zero-length string, the function returns a zero-length string.
If Parameter1 does not contain a string that is equal to Parameter2, the function returns a zero-length string.
If Parameter1 or Parameter2 is an empty list, the function returns an empty list.
Liquid Data does not support the xf:substring-after format that accepts collations.
xf:substring-after("abcde", "d") returns the string value "e."xf:substring-after("abcde", "") returns the string value "abcde."xf:substring-after("abcde", "x") returns the empty string "".xf:substring-after("abcde", ()) returns the empty list ().xf:substring-after((), "x") returns the empty list ().xf:substring-after("abc34de", 3) generates a compile-time error because the second parameter is not a string.Returns that part of the Parameter1 source string that precedes the first occurrence of those characters specified in Parameter2.
If Parameter2 is a zero-length string, the function returns the value of Parameter1. If Parameter1 is a zero-length string and Parameter2 is a zero-length string, the function returns a zero-length string.
If Parameter1 does not contain a string that is equal to Parameter2, the function returns a zero-length string.
If Parameter1 or Parameter2 is an empty list, the function returns an empty list.
Liquid Data does not support the xf:substring-before format that accepts collations.
xf:substring-before("abcde", "d") returns the string value abc.xf:substring-before("abcde", "") returns the string value abcde.xf:substring-after("abcde", "x") returns the empty string "".xf:substring-before("abcde", ()) returns an empty list ().xf:substring-before((), "x") returns an empty list ().xf:substring-before("abc34de", 3) generates a compile-time error because the second parameter is not a string.Returns the value of the input string after translating every lower-case letter to its uppercase correspondent.
Every lower-case letter that does not have an uppercase corresponding value and every character that is not a lower-case letter appears in the output in its original form.
If the source value is an empty list, the function returns an empty list.
Liquid Data generates an error if the parameter is not a string.
Conforms to the current specification.
xf:upper-case("ABc!D") returns the string value ABC!D.xf:upper-case("") returns the empty string "".xf:upper-case(()) returns the empty list ().xf:upper-case(4) generates a compile-time error because the parameter is not a string.Returns a list of integers (either an empty list with 0 integers or a list with 2 integers) specifying which characters in the string input matches the input regular expression. When the function returns a match, the first integer represents the index of (the position of) the first character of the matching substring and the second integer represents the number of matching characters starting at the first match.
The index of the first character of the input source is 1, the index of the second character is 2, and so on.
The regularExpression input uses a standard regular expression language. The regular expression language uses the following components:
This is an extended function and is not part of the XQuery specification.
xfext:match("abcde", "bcd") evaluates to the list (2,3)xfext:match("abcde", ()) evaluates to the empty list ()xfext:match((), "bcd") evaluates to the empty list ()xfext:match("abc", 4) generates an error at compile time because the second parameter is not a stringxfext:match("abcccdee", "[bc]") evaluates to the list (2,1)Returns the value of the input string with leading and trailing white space removed from the string.
If the input string is an empty list, the function returns an empty list.
Liquid Data generates an error if the parameter is not a string.
The xfext:trim function is an extended function. For more information about extended functions, see Naming Conventions.
xfext:trim("abc") returns the string value "abc"xfext:trim(" abc ") returns the string value "abc"xfext:trim(()) returns the empty list ()xfext:trim(5) generates a compile-time error because the parameter is not a stringTests whether a string contains the specified pattern. Typically, this function is used as a condition for a query, similar to the SQL LIKE operator used in a predicate of SQL queries. Returns TRUE if the pattern is matched in the source expression, otherwise returns FALSE.
source Input data type: xs:string?pattern Input data type: xs:string?escape Input data type: xs:string?The percentage character (%) is a wildcard character representing a string of zero or more characters. The underscore character (_) is a is a wildcard character representing any single character.
Use the xfext:sql-like function to specify query conditions that satisfy a search pattern. For example, you can use the xfext:sql-like function to constrain a query that returns first names to return only first names that begin with the letter H.
The escape input parameter specifies an escape character. The escape character is needed to specify one of the wildcard characters (_ and %) in the search pattern.
The xfext:sql-like function is an extended function. For more information about extended functions, see Naming Conventions.
xfext:sql-like($RTL_CUSTOMER.ADDRESS_1/FIRST_NAME,"H%","\") returns TRUE for all FIRST_NAME elements in $RTL_CUSTOMER.ADDRESS that start with the character H.xfext:sql-like($RTL_CUSTOMER.ADDRESS_1/FIRST_NAME,"_a%","\") returns TRUE for all FIRST_NAME elements in $RTL_CUSTOMER.ADDRESS that start with any character and have a second character of the letter a.xfext:sql-like($RTL_CUSTOMER.ADDRESS_1/FIRST_NAME,"H\%%","\") returns TRUE for all FIRST_NAME elements in $RTL_CUSTOMER.ADDRESS that start with the characters H%.
The treat functions process a source value as the argument and treat that source value as if it is the datatype in the treat function. These functions are used when mapping optional values (which do not have to have data associated with them) to mandatory values (which do have to have data associated with them). From the Query menu Automatic Treat As checkbox, you can set up the Data View Builder to automatically add treat functions when they are needed, or you can add them manually. Without the treat functions, some queries that attempt to map optional fields (for example, nullable relational database columns) to mandatory fields might fail.
Unlike the cast functions, the treat functions do not change the type of the input value; instead they ensure that an expression has the intended type when it is evaluated for query execution.
A typical use case is when you need to map elements from a nullable relational database column that you know do not contain any null values.
Another use case is where you need to map non-nullable (mandatory) elements to a function that produces optional (nullable) output. For example, if you map an xf:string type to a custom function that outputs an xf:string? type, and then map that output to an xf:string type, there will be a type mismatch which will cause the query to fail during compilation. The type mismatch is because the output type of the function is xf:string?, which mismatches xf:string. You can correct this by placing a treat as xs:string function betweenthe custom function and the output.
The following table describes Liquid Data data types that conform to the XQuery specification that you can use in treat as functions. For more information about data types, see the XQuery 1.0 and XPath 2.0 Functions and Operators specification. The following treat as functions are available:
Treats the input value as if it is a boolean value (true or false). Use to map optional boolean elements to mandatory boolean elements.
See Treat Functions.
Conforms to the current specification.
Treats the input value as if it is a byte value. Use to map optional boolean elements to mandatory boolean elements.
See Treat Functions.
Conforms to the current specification.
Treats the input value as if it is a date value. Use to map optional boolean elements to mandatory boolean elements.
See Treat Functions.
Conforms to the current specification.
Treats the input value as if it is a dateTime value. Use to map optional boolean elements to mandatory boolean elements.
See Treat Functions.
Conforms to the current specification.
Treats the input value as if it is a decimal value. Use to map optional boolean elements to mandatory boolean elements.
See Treat Functions.
Conforms to the current specification.
Treats the input value as if it is a double value. Use to map optional boolean elements to mandatory boolean elements.
See Treat Functions.
Conforms to the current specification.
Treats the input value as if it is a float value. Use to map optional boolean elements to mandatory boolean elements.
See Treat Functions.
Conforms to the current specification.
Treats the input value as if it is a int value. Use to map optional boolean elements to mandatory boolean elements.
See Treat Functions.
Conforms to the current specification.
Treats the input value as if it is a integer value. Use to map optional boolean elements to mandatory boolean elements.
See Treat Functions.
Conforms to the current specification.
Treats the input value as if it is a long value. Use to map optional boolean elements to mandatory boolean elements.
See Treat Functions.
Conforms to the current specification.
Treats the input value as if it is a short value. Use to map optional boolean elements to mandatory boolean elements.
See Treat Functions.
Conforms to the current specification.
Treats the input value as if it is a string value. Use to map optional boolean elements to mandatory boolean elements.
See Treat Functions.
Conforms to the current specification.
Treats the input value as if it is a time value. Use to map optional boolean elements to mandatory boolean elements.
See Treat Functions.
|
|
|