SELECT <column_list>, XMLQuery (
'for $i IN <record_end_tag>
WHERE $i<item_end_tag> = <value>
ORDER BY $i<item_end_tag>
RETURN $i<item_end_tag>
PASSING BY VALUE <xml_record_column>
RETURNING CONTENTS) <returning_column_alias>
FROM <table_name>;
Note: What is within the parentheses is case sensitive and you can not use Upper Case or InitCap for commands.
SELECT person_id, XMLQuery('FOR
$i IN /PDRecord
WHERE $i /PDName = "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName eq "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
Greater Than
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName > "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName gt "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
Greater Than Or Equal To
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName >= "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName ge "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
Less Than
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName < "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName lt "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
Less Than Or Equal To
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName >= "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName le "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
Not Equals
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName != "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;
SELECT person_id, XMLQuery (
'FOR $i IN /PDRecord
WHERE $i /PDName ne "Daniel Morgan"
ORDER BY $i/PDName
RETURN $i/PDName'
PASSING BY VALUE person_data
RETURNING CONTENT) XMLData
FROM person_data;