-
DocPath
-
A document field name definition as represented by a string or an X DevAPI
expression instance.
Type:
Example
// string
'foo.bar.baz'
'$.foo.bar'
'foo[0].bar'
// X DevAPI expression
mysqlx.expr('foo.bar.baz')
mysqlx.expr('$.foo.bar')
mysqlx.expr('foo[0].baz')
-
DocPaths
-
One or more field document path.
Type:
-
DocumentOrJSON
-
A document definition as represented by a plain JavaScript object, a JSON
string or an X DevAPI expression instance.
Type:
Example
// literal object
{ foo: 'bar' }
// JSON string
'{ "foo": "bar" }'
// X DevAPI expression
mysqlx.expr('{"foo":"bar"}')
-
DocumentsOrJSON
-
One or more document definitions.
Type:
-
ExprOrLiteral
-
A document definition as represented by a plain JavaScript object, a JSON
string or an X DevAPI expression instance.
Type:
Example
// primitive JavaScript values
'foo'
true
false
3
1.234
// X DevAPI expression literal
mysqlx.expr('{"foo":"bar"}')
-
ProjectedDocumentExprStr
-
A document field name and optional alias to include as part of a result set.
Type:
Example
// string
foo.bar.baz as path
foo[2].bar as path
foo.*.bar as path
// X DevAPI expression
mysqlx.expr('foo.bar.baz as path')
mysqlx.expr('foo[2].bar as path')
mysqlx.expr('foo.*.bar as path')
mysqlx.expr('{ "foobar": concat(foo, bar) }')
-
ProjectedDocumentsExprStr
-
One or more document field names and corresponding optional aliases.
Type:
-
ProjectedSearchExprStr
-
A column name and optional alias to include as part of a result set.
Type:
Example
// string
foo as baz
bar as qux
// X DevAPI expression
mysqlx.expr('foo as bar', { mode: mysqlx.Mode.TABLE })
mysqlx.expr('bar as qux', { mode: mysqlx.Mode.TABLE })
mysqlx.expr('{ "foobar": concat(foo, bar) }', { mode: mysqlx.Mode.TABLE })
-
ProjectedSearchExprStrList
-
One or more column names and corresponding optional aliases.
Type:
-
SearchConditionStr
-
Expression that establishes the filtering criteria.
Type:
- See:
-
-
SearchExprStr
-
Expression that establishes the elements to include in an aggregation.
Type:
-
SearchExprStrList
-
One or more expressions that establishes an aggregation.
Type:
- See:
-
-
SortExprStr
-
A column name and optional alias to include as part of a result set.
Type:
-
SortExprStrList
-
One or more column names and corresponding optional aliases.
Type:
- See:
-
-
TableField
-
A column name definition as represented by a string or an X DevAPI
expression instance.
Type:
Example
'foo.bar.baz->>"$qux.quux"'
-
TableFields
-
One or more document definitions.
Type:
-
int64
-
An integer value that can loose precision, in which case it can potentially
be represented by a BigInt or a string.
Type: