Index

Symbols A B C D E F G H I J K L M N O P Q R S T U V W Y

---

Symbols

• , character (comma), path syntax 4

• . character (period), path syntax 4

• ` character (backquote), path syntax 4

• [ and ] characters (brackets), path syntax 4

• $, prefix for QBE operator names 2

• $abs operator 5.2.2.3

• $all operator 5.2.2.1

• $and operator 5.2.3

  • omitting 2.6, 5.2.3.1

  • overview 2.6

• $between operator 5.2.2.1

• $boolean operator 5.2.2.3

• $ceiling operator 5.2.2.3

• $ character (dollar sign)

  • escaping in QBE path 4

  • in operator names 5

• $contains operator

  • overview 2.11

  • reference 5.2.7.2

• $date operator 5.2.2.3

• $double operator 5.2.2.3

• $eq operator 5.2.2.1

  • omitting 5.2.2.1

• $exists operator 5.2.2.1

• $floor operator 5.2.2.3

• $gte operator 5.2.2.1

• $gt operator 5.2.2.1

• $id operator 5.2.5

  • overview 2.8

  • used with $textContains 5.2.6

• $in operator 5.2.2.1

• $intersects operator 5.2.7.1

• $length operator 5.2.2.3

• $lower operator 5.2.2.3

• $lte operator 5.2.2.1

• $lt operator 5.2.2.1

• $near operator 5.2.7.1

• $ne operator 5.2.2.1

• $nin operator 5.2.2.1

• $nor operator 5.2.3

  • overview 2.6

• $not operator 5.2.2.2

• $not QBE operator

  • overview 2.4

• $number operator 5.2.2.3

• $orderby operator 5.1

  • overview 2.9

• $or operator 5.2.3

  • overview 2.6

• $query operator 5.1

• $regex operator 5.2.2.1

• $size operator 5.2.2.3

• $startsWith operator 5.2.2.1

• $string operator 5.2.2.3

• $textContains operator

  • overview 2.12

  • reference 5.2.6

• $timestamp operator 5.2.2.3

• $type operator 5.2.2.3

• $upper operator 5.2.2.3

• $within operator 5.2.7.1

• • character (asterisk), path syntax 4

---

A

• array, object satisfying multiple conditions 2.7

• array index (position) 4

• array step (QBE path), definition 4

• asterisk character, path syntax 4

---

B

• backquote character, path syntax 4

• bracket characters, path syntax 4

• B-tree index

  • details 6

  • overview 3

---

C

• collection

  • heterogeneous 2

    • media type column name 7.23

  • mapped 1.6

• collection configuration 7

• collection metadata

  • components of 7

  • content column format 7.12

  • content column JSON validation 7.14

  • content column max length 7.13

  • content column name 7.10

  • content column SecureFiles LOB cache 7.16

  • content column SecureFiles LOB compression 7.15

  • content column SecureFiles LOB encryption 7.17

  • content column type 7.11

  • creation time stamp column name 7.22

  • default 7.1

  • default and custom 1

  • key column assignment method 7.7

  • key column max length 7.6

  • key column name 7.4

  • key column path 7.8

  • key column sequence name 7.9

  • key column type 7.5

  • last-modified column index name 7.21

  • last-modified time stamp column name 7.20

  • media type column name 7.23

  • read only 7.24

  • schema 7.2

  • table or view 7.3

  • version column name 7.18

  • version generation method 7.19

• collections, database view of 1.5

• collection table name 1.4

• comma character, path syntax 4

• comparison clause

  • definition 5.2.2.1

• comparison operator

  • definition 5.2.2.1

• comparison QBE operators

  • overview 2.3

• components, document 1

• composite filter specification 5.1

• condition

  • definition 5.2

• condition-operator clause

  • definition 5.2.2

• contains clause

  • definition 5.2.7.2

• content column format collection metadata component 7.12

• content column JSON validation collection metadata component 7.14

• content column max length collection metadata component 7.13

• content column name collection metadata component 7.10

• content column SecureFiles LOB cache collection metadata component 7.16

• content column SecureFiles LOB compression collection metadata component 7.15

• content column SecureFiles LOB encryption collection metadata component 7.17

• content column type collection metadata component 7.11

• creation time stamp column name collection metadata component 7.22

• CRUD operations 1

---

D

• database, SODA 1

• data guide

  • details 6

  • overview 3

• date formats, ISO 8601 5.2.2.4

• document 1.1

• document components 1

• document key 1

  • matching in QBE 5.2.5

• dollar sign, for QBE operator 2

• dollar-sign character

  • escaping in QBE path 4

  • in operator names 5

• ds_iso_format ISO 8601 duration format 5.2.2.4

• duration formats, ISO 8601 5.2.2.4

---

E

• empty filter condition ({}) 5.2

• empty query 5

• equality, scalar 5.2.1

---

F

• field-condition clause

  • definition 5.2.2

• field step (QBE path), definition 4

• filter

  • definition 5

• filter condition

  • definition 5.2

• filter specification 1, 2

  • definition 5

  • details 5

• full-text index,

  • details 6

  • overview 3

• full-text search

  • JSON, overview 2.11

  • non-JSON, overview 2.12

---

G

• guidelines 10.1

---

H

• heterogeneous collection 2

  • media type column name 7.23

• hint

  • SQL monitoring 1.7

---

I

• ID clause 5.2.5

• implicit $and operator 5.2.3.1

• index (position), array 4

• index specification

  • details 6

• index specifications

  • overview 3

• ISO 8601 formats 5.2.2.4

• item-method clause

  • definition 5.2.2.3

• item-method equality clause

  • definition 5.2.2.3

• item-method modifier clause

  • definition 5.2.2.3

• item-method QBE operators 5.2.2.3

  • $abs 5.2.2.3

  • $boolean 5.2.2.3

  • $ceiling 5.2.2.3

  • $date 5.2.2.3

  • $double 5.2.2.3

  • $floor 5.2.2.3

  • $length 5.2.2.3

  • $lower 5.2.2.3

  • $number 5.2.2.3

  • $size 5.2.2.3

  • $string 5.2.2.3

  • $timestamp 5.2.2.3

  • $type 5.2.2.3

  • $upper 5.2.2.3

  • overview 2.5

---

J

• JSON data format used for document content 7.12

• JSON data type used for document content 7.11

---

K

• key, document 1

  • matching in QBE 5.2.5

• key column assignment method collection metadata component 7.7

• key column max length collection metadata component 7.6

• key column name collection metadata component 7.4

• key column path collection metadata component 7.8

• key column sequence name collection metadata component 7.9

• key column type collection metadata component 7.5

---

L

• last-modified column index name collection metadata component 7.21

• last-modified time stamp column name collection metadata component 7.20

• lax field, spatial index specification

  • details 6

  • overview 3

• limitations 10.2

• logical combining clause

  • definition 5.2.3

• logical combining operator

  • definition 5.2.3

• logical combining operators

  • overview 2.6

---

M

• mapped collections 1.6

• media type column name collection metadata component 7.23

• metadata, collection 1

• modifiers

  • See: item-method QBE operators

• monitoring performance 1.7

• MONITOR SQL hint 1.7

---

N

• nested-condition clause 5.2.4

• nested conditions 2.7

• not clause

  • definition 5.2.2.2

---

O

• object in array, satisfying multiple conditions 2.7

• omitting $and operator 5.2.3.1

• omitting $eq operator 5.2.2.1

• operand, for QBE operator

  • definition 5

• operand, QBE 2, 5

• operator

  • $abs 5.2.2.3

  • $all 5.2.2.1

  • $and 5.2.3

    • omitting 2.6

    • overview 2.6

  • $between 5.2.2.1

  • $boolean 5.2.2.3

  • $ceiling 5.2.2.3

  • $contains

    • overview 2.11

    • reference 5.2.7.2

  • $date 5.2.2.3

  • $double 5.2.2.3

  • $eq 5.2.2.1

    • omitting 5.2.2.1

  • $exists 5.2.2.1

  • $floor 5.2.2.3

  • $gt 5.2.2.1

  • $gte 5.2.2.1

  • $id

    • overview 2.8

    • reference 5.2.5

  • $in 5.2.2.1

  • $intersects 5.2.7.1

  • $length 5.2.2.3

  • $lower 5.2.2.3

  • $lt 5.2.2.1

  • $lte 5.2.2.1

  • $ne 5.2.2.1

  • $near 5.2.7.1

  • $nin 5.2.2.1

  • $nor 5.2.3

    • overview 2.6

  • $not 5.2.2.2

    • overview 2.4

  • $number 5.2.2.3

  • $or 5.2.3

    • overview 2.6

  • $orderby 5.1

    • overview 2.9

  • $query 5.1

  • $regex 5.2.2.1

  • $size 5.2.2.3

  • $startsWith 5.2.2.1

  • $string 5.2.2.3

  • $textContains

    • overview 2.12

    • reference 5.2.6

  • $timestamp 5.2.2.3

  • $type 5.2.2.3

  • $upper 5.2.2.3

  • $within 5.2.7.1

• operator, QBE 2, 5

• orderby clause 5.1.1

• ordinary characters, definition 4

---

P

• path, QBE 2.2, 4

• period character, path syntax 4

---

Q

• QBE

  • definition 5

  • operand 2, 5

  • operator 2, 5

• QBE (query by example) 1

• QBE (query-by-example) 2

• QBE operators

  • $all 5.2.2.1

  • $and 5.2.3

  • $between 5.2.2.1

  • $contains

    • overview 2.11

    • reference 5.2.7.2

  • $eq 5.2.2.1

  • $exists 5.2.2.1

  • $gt 5.2.2.1

  • $gte 5.2.2.1

  • $id

    • overview 2.8

    • reference 5.2.5

  • $in 5.2.2.1

  • $intersects 5.2.7.1

  • $lax

    • for $orderby 5.1.1

    • for QBE spatial clause 5.2.7.1

  • $lt 5.2.2.1

  • $lte 5.2.2.1

  • $ne 5.2.2.1

  • $near 5.2.7.1

  • $nin 5.2.2.1

  • $nor 5.2.3

  • $not 5.2.2.2

    • overview 2.4

  • $or 5.2.3

  • $orderby 5.1, 5.1.1

    • overview 2.9

  • $query 5.1

  • $regex 5.2.2.1

  • $scalarRequired

    • for $orderby 5.1.1

    • for QBE spatial clause 5.2.7.1

  • $startsWith 5.2.2.1

  • $textContains

    • overview 2.12

    • reference 5.2.6

  • $within 5.2.7.1

  • comparison

    • overview 2.3

  • item-method 5.2.2.3

    • overview 2.5

  • spatial

    • overview 2.10

• QBE path 2.2, 4

• query-by-example 2

• query by example (QBE) 1

• query-by-example (QBE)

  • definition 5

---

R

• read and write operations

  • monitoring performance 1.7

• read only collection metadata component 7.24

• restrictions 10.2

---

S

• sample JSON documents used in examples 2.1

• scalar-equality clause

  • definition 5.2.1

• scalarRequired field, index specification

  • details 6

• scalarRequired field, index specifications

  • overview 3

• schema, database

  • accessing collection in different 1.6

• schema collection metadata component 7.2

• scoping fields to a parent field in QBE 5.2.4

• search, full-text

  • JSON, overview 2.11

  • non-JSON, overview 2.12

• search index

  • details 6

  • overview 3

• SODA database 1

• SODA guidelines 10.1

• SODA implementations 1

• SODA limitations 10.2

• SODA operator

  • definition 5

• SODA restrictions 10.2

• sorting JSON data returned by a QBE 5.1.1

• spatial clause

  • definition 5.2.7.1

• spatial index

  • details 6

  • overview 3

• spatial operator

  • $intersects 5.2.7.1

  • $near 5.2.7.1

  • $within 5.2.7.1

• spatial QBE operators

  • overview 2.10

• specification

  • filter

    • details 5

  • index

    • details 6

• specifications

  • index

    • overview 3

• SQL/JSON operators 1

• square bracket characters, path syntax 4

• syntactic characters, definition 4

• syntax, QBE path 4

---

T

• table name, collection 1.4

• table or view collection metadata component 7.3

• text-contains clause

  • definition 5.2.6

• time formats, ISO 8601 5.2.2.4

---

U

• updated collection 1.2

• USER_SODA_COLLECTIONS database view 1.5

• users

  • accessing collection of different 1.6

---

V

• version column name collection metadata component 7.18

• version generation method collection metadata component 7.19

• view of your SODA collections 1.5

---

W

• wildcard character, path syntax 4

• write and read operations

  • monitoring performance 1.7

---

Y

• ym_iso_format ISO 8601 duration format 5.2.2.4