www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Virtuoso Functions Guide

Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
RDF data
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
and
append
assign
avg
boolean
ceiling
concat
contains
count
create-attribute
create-comment
create-element
create-pi
current
distinct
doc
document
document-literal
empty
ends-with
every
except
false
filter
floor
fn:collection
for
format-number
function-available
generate-id
id
if
intersect
is_after()
is_before()
key
lang
last
let
list()
local-name
max
min
name
namespace-uri
normalize-space
not
number
or
position
processxquery
processxslt
processxsql
progn()
replace()
round
serialize
shallow
some
starts-with
string
string-length
substring
substring-after
substring-before
sum
system-property
text_contains()
translate
true
tuple()
union
unordered
unparsed-entity-uri
urlify
xmlview

Functions Index

for

Repeats some calculation for every item of a given sequence
any for ( varname string, source_set sequence, mapping_expn any);
Description

The function creates a temporary local variable, whose name is specified by varname argument. Then, for every item of source_set sequence it calculates the value of mapping_expn expression having set the created variable to that "current" item. It returns the "flattened" sequence of values returned by mapping_expn in the same order as they are calculated. "Flattened" means that if mapping_expn returns an sequence, items of this sequence will be added into the end of resulting sequence, one by one, instead of adding one item of type "sequence".

The temporary variable is destroyed on return.

This function is used in the implementation of "FOR" control operator in XQUERY, so you will probably use that operator in XQUERY expressions, not the function. This function may be useful in XPATH expressions and in XSLT stylesheets. It is not a part of library of standard XQUERY 1.0 functions.

Parameters
varname – Name of temporary variable
source_set – Sequence of items; every item will cause one call of mapping_expn
mapping_expn – An expression which should be calculated for items of source_set.
Return Types

Sequence

Examples

These two expressions are equivalent, but first may be used in any XPATH while second is written in XQUERY syntax

for('itm', /bid/item, 0.20 * $itm/price)
FOR $itm IN /bid/item RETURN 0.20 * $bid_item/price