XQuery Reference Guide

XQuery and XML Specification Implementation

Supported XQuery and XML Schema Versions In Liquid Data

XQuery

XQuery Functions and Operators

XML Schema

W3C XML and XQuery

XQuery Use in Liquid Data and the Data View Builder

Learning More About the XQuery Language

Understanding XQuery in Liquid Data

XQuery Syntax in Liquid Data

query_prologue

namespace_declaration

query_expression

variable_definition

qualified_name

sortby_expression

XQuery Expressions

XML Markup Expression

FLWR Expression

PATH Expressions

Conditional Expressions (if-then-else)

Built-In Functions

Constants

String Constants

Numeric Constants

Variables

Operators

Quantified Expressions

Query Parameters

XQuery Comments and Join Hints

Comments

Join Hints

Specifying Joins and Unions in XQuery

Using Multiple For Statements to Create a Result

Working From a Hierarchical Result Document Backwards: a Technique

Specifying Aggregates and Groups (Group By)

Specifying a Union-All Query

Reading the XQuery Syntax Diagrams

Text Conventions

Follow the Lines and Arrows Coming Into the Diagram

Blocks with No Arrows Indicate Optional Content

Blocks with Arrows (Loops) Indicate Repeatable Options

Functions Reference

About Liquid Data XQuery Functions

Naming Conventions

Occurrence Indicators

Data Types

Date and Time Patterns

Accessor and Node Functions

xf:data

xf:document (format 1)

xf:document (format 2)

xf:local-name

Aggregate Functions

xf:avg

xf:count

xf:max

xf:min

xf:sum

Boolean Functions

xf:false

xf:not

xf:true

Cast Functions

cast as xs:boolean

cast as xs:byte

cast as xs:date

cast as xs:dateTime

cast as xs:decimal

cast as xs:double

cast as xs:float

cast as xs:int

cast as xs:integer

cast as xs:long

cast as xs:short

cast as xs:string

cast as xs:time

Comparison Operators

eq

ge

gt

le

lt

ne

Constructor Functions

xf:boolean-from-string

xf:byte

xf:decimal

xf:double

xf:float

xf:int

xf:integer

xf:long

xf:short

xf:string

Date and Time Functions

xf:add-days

xf:current-dateTime

xf:date

xf:dateTime

xf:get-day-from-date

xf:get-day-from-dateTime

xf:get-hours-from-dateTime

xf:get-hours-from-time

xf:get-minutes-from-dateTime

xf:get-minutes-from-time

xf:get-month-from-date

xf:get-month-from-dateTime

xf:get-seconds-from-dateTime

xf:get-seconds-from-time

xf:get-year-from-date

xf:get-year-from-dateTime

xf:time

xfext:date-from-dateTime

xfext:date-from-string-with-format

xfext:date-to-string-with-format

xfext:dateTime-from-string-with-format

xfext:dateTime-to-string-with-format

xfext:time-from-dateTime

xfext:time-from-string-with-format

xfext:time-to-string-with-format

Logical Operators

and

or

Numeric Operators

* (multiply)

+ (add)

- (subtract)

div

mod

Numeric Functions

xf:ceiling

xf:floor

xf:round

xfext:decimal-round

xfext:decimal-truncate

Other Functions

xfext:if-then-else

Sequence Functions

xf:distinct-values

xf:empty

xf:subsequence (format 1)

xf:subsequence (format 2)

String Functions

xf:compare

xf:concat

xf:contains

xf:ends-with

xf:lower-case

xf:starts-with

xf:string-length

xf:substring (format1)

xf:substring (format 2)

xf:substring-after

xf:substring-before

xf:upper-case

xfext:match

xfext:trim

xfext:sql-like

Treat Functions

treat as xs:boolean

treat as xs:byte

treat as xs:date

treat as xs:dateTime

treat as xs:decimal

treat as xs:double

treat as xs:float

treat as xs:int

treat as xs:integer

treat as xs:long

treat as xs:short

treat as xs:string

treat as xs:time

Supported Data Types

JDBC Types in Liquid Data

java.sql.Types Data Types

JDBC Data Type Names

Database-Specific Data Type Names

Oracle Data Type Names

Microsoft SQL Server Data Type Names

DB2 Data Type Names

Sybase Data Type Names

Informix Data Type Names