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 1.2
  • heterogeneous 2
    • definition 1.2
    • media type column name 7.23
• 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.4
• collection table name 1.3
• 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 collection 1.2
• 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
  • definition 1.2
  • media type column name 7.23
• hint
  • SQL monitoring 1.5

---

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

• media type column name collection metadata component 7.23
• metadata, collection 1
• modifiers
  • See: item-method QBE operators
• monitoring performance 1.5
• MONITOR SQL hint 1.5

---

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.5
• 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 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.3
• table or view collection metadata component 7.3
• text-contains clause
  • definition 5.2.6
• time formats, ISO 8601 5.2.2.4

---

U

• USER_SODA_COLLECTIONS database view 1.4

---

V

• version column name collection metadata component 7.18
• version generation method collection metadata component 7.19
• view of your SODA collections 1.4

---

W

• wildcard character, path syntax 4
• write and read operations
  • monitoring performance 1.5

---

Y

• ym_iso_format ISO 8601 duration format 5.2.2.4