> XQuery and XQSE
Developer’s Guide
XQuery and XQSE
Developer’s Guide
fn-bea:is-access-allowed
fn-bea:is-user-in-group
fn-bea:is-user-in-role
fn-bea:userid
fn-bea:date-from-dateTime
fn-bea:date-from-string-with-format
fn-bea:date-to-string-with-format
fn-bea:dateTime-from-string-with-format
fn-bea:dateTime-to-string-with-format
fn-bea:time-from-dateTime
fn-bea:time-from-string-with-format
fn-bea:time-to-string-with-format
Date and Time Patterns
fn-bea:async
fn-bea:fence
fn-bea:timeout and fn-bea:timeout-with-label
fn-bea-timeout Signature
fn-bea-timeout-with-label Signature
Operational Details
fn-bea:fail-over, fn-bea:fail-over-with-label, fn-bea:fail-over-retry, and fn-bea:fail-over-retry-with-label
Usage Suggestions
fn-bea:format-number
fn-bea:decimal-round
fn-bea:decimal-truncate
fn-bea:get-property
fn-bea:inlinedXML
fn-bea:rename
fn-bea:QName-from-string
fn-bea:interleave
fn-bea:match
fn-bea:sql-like
fn-bea:trim
fn-bea:trim-left
fn-bea:trim-right
fn-bea:pad-left
Pad Left Function Using Default Character (ASCII 32)
Pad Left Function with Specified Pad String
fn-bea:pad-right
Pad Right Function Using Default Character (ASCII 32)
Pad Right Function with Specified Pad String
fn-bea:current-value
fn-bea:old-value
Generalized FLWGOR (group by)
Optional Indicator in Direct Element and Attribute Constructors
Metadata and Data Type Mappings Get Stored in Annotated Files
Runtime Connection Management—Connection Sharing
Date and Time Data Type Differences: Timezones and Time Precision
How AquaLogic Data Services Platform Handles Timezone Information
How AquaLogic Data Services Platform Handles Fractional Seconds
Scope Differences for Expressions and Data Types
Function and Operator Pushdown
Aggregate Functions
Parameters in Generated SQL Statements
Cast Operation Pushdown
Path Expressions Pushdown
Constant Pushdown
Variable Pushdown
Simple Projection Queries
Where Clause Pushdown
Order By Clause Pushdown
Inner Join Pushdown
Outer Join Pushdown
Semi-Joins and Anti-Semi-Joins
Group By Pushdown
Distinct-by Pushdown
Simple Aggregate Pattern
Group-By with a Nested Where Clause Translates to SQL HAVING Clause
Outer Join with Aggregate Pattern
If-Then-Else Pattern
Subsequence Pushdown