Index

Symbols

, character (comma), path syntax 4
. character (period), path syntax 4
` character (backquote), path syntax 4
[ and ] characters (brackets), path syntax 4
$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 paths 4
- in operator names 5
$contains operator 5.2.6.1
$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
$in operator 5.2.2.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
$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 2.9, 5.1
$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
$timestamp operator 5.2.2.3
$type operator 5.2.2.3
$upper operator 5.2.2.3
* character (asterisk), path syntax 4

A

array index 4
array step (path), definition 4
asterisk character, path syntax 4

B

backquote character, path syntax 4
bracket characters, path syntax 4
B-tree index, details 6

C

collection configuration 7
collection metadata
- components of 7
- content column JSON validation 7.11
- content column max length 7.10
- content column name 7.8
- content column SecureFiles LOB cache 7.13
- content column SecureFiles LOB compression 7.12
- content column SecureFiles LOB encryption 7.14
- content column type 7.9
- creation time stamp column name 7.19
- default and custom 1
- key column assignment method 7.6
- key column max length 7.5
- key column name 7.3
- key column sequence name 7.7
- key column type 7.4
- last-modified column index name 7.18
- last-modified time stamp column name 7.17
- media type column name 7.20
- read only 7.21
- schema 7.1
- table or view 7.2
- version column name 7.15
- version generation method 7.16
collections 1.2
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.6.1
content column JSON validation collection metadata component 7.11
content column max length collection metadata component 7.10
content column name collection metadata component 7.8
content column SecureFiles LOB cache collection metadata component 7.13
content column SecureFiles LOB compression collection metadata component 7.12
content column SecureFiles LOB encryption collection metadata component 7.14
content column type collection metadata component 7.9
creation time stamp column name collection metadata component 7.19
CRUD operations 1

D

database, SODA 1
data guide, details 6
date and time formats, ISO 8601 5.2.2.4
document collections 1.2
document components 1
document key 1
- matching in QBE 5.2.5
document metadata 1
documents 1.1
dollar-sign character
- escaping in paths 4
- in operator names 5

E

empty filter condition ({}) 5.2
empty query 5
equality, scalar 5.2.1

F

field-condition clause
- definition 5.2.2
field step (path), definition 4
filter
- definition 5
filter condition
- definition 5.2
filter specification 1, 2
- definition 5
filter specifications 2
- details 5
full-text index, details 6

G

guidelines 8.1

I

ID clause 5.2.5
implicit $and operator 5.2.3.1
index, array 4
index specifications
- details 6
- overview 3
ISO 8601 date and time 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

K

key, document 1
- matching in QBE 5.2.5
key column assignment method collection metadata component 7.6
key column max length collection metadata component 7.5
key column name collection metadata component 7.3
key column sequence name collection metadata component 7.7
key column type collection metadata component 7.4

L

last-modified column index name collection metadata component 7.18
last-modified time stamp column name collection metadata component 7.17
limitations 8.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.20
metadata, collection and document 1
modifiers
- See: item-method QBE operators

N

nested-condition clause 5.2.4
nested conditions 2.7
not clause
- definition 5.2.2.2

O

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 5.2.6.1
- $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 5.2.5
  - overview 2.8
- $in 5.2.2.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
- $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 2.9, 5.1
- $query 5.1
- $regex 5.2.2.1
- $size 5.2.2.3
- $startsWith 5.2.2.1
- $string 5.2.2.3
- $timestamp 5.2.2.3
- $type 5.2.2.3
- $upper 5.2.2.3
operator, QBE 2, 5
orderby clause 5.1.1
ordinary characters, definition 4

P

paths 4
paths, QBE 2.2
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
- $eq 5.2.2.1
- $exists 5.2.2.1
- $gt 5.2.2.1
- $gte 5.2.2.1
- $id 5.2.5
  - overview 2.8
- $in 5.2.2.1
- $lt 5.2.2.1
- $lte 5.2.2.1
- $ne 5.2.2.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
- $query 5.1
- $regex 5.2.2.1
- $startsWith 5.2.2.1
- comparison
  - overview 2.3
- item-method 5.2.2.3
  - overview 2.5
QBE paths 2.2
query-by-example 2
query by example (QBE) 1
query-by-example (QBE)
- definition 5

R

read only collection metadata component 7.21
restrictions 8.2

S

sample JSON documents used in examples 2.1
scalar-equality clause
- definition 5.2.1
schema collection metadata component 7.1
scoping fields to a parent field in QBE 5.2.4
search index, details 6
SODA database 1
SODA guidelines 8.1
SODA implementations 1
SODA limitations 8.2
SODA operator
- definition 5
SODA restrictions 8.2
sorting JSON documents returned by a QBE 5.1.1
special-criterion clause 5.2.5
specifications
- filter
  - details 5
- index
  - details 6
square bracket characters, path syntax 4
syntactic characters, definition 4
syntax, path 4

T

table name, collection 1.3
table or view collection metadata component 7.2
time and date formats, ISO 8601 5.2.2.4

V

version column name collection metadata component 7.15
version generation method collection metadata component 7.16

W

wildcard character, path syntax 4