Skip to main content
クエリ

​
プロパティ

​
$expr

**expr**: { `and: (AndOperation | { or`: (AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation)[]; } | { `not: any[]; } | { eq`: `any`[]; } | { `gt: any[]; } | { lt`: `any`[]; } | { `gte: any[]; } | { lte`: `any`[]; } | { `in: any[]; } | { contains`: { `case_insensitive?`: `boolean` | `null`; `input`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation; `substr`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation; }; } | { `literal: string|number|boolean|Record<string, LiteralOperation> | LiteralOperation[] | null; } | { getField`: `string`; } | { `convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation; to: ”string”|”double”|”int”|”bool”|”exists”; }; } | { size`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation; })[]; } | { `or: ({ and`: (AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation)[]; } | OrOperation | { `not: any[]; } | { eq`: `any`[]; } | { `gt: any[]; } | { lt`: `any`[]; } | { `gte: any[]; } | { lte`: `any`[]; } | { `in: any[]; } | { contains`: { `case_insensitive?`: `boolean` | `null`; `input`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation; `substr`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation; }; } | { `literal: string|number|boolean|Record<string, LiteralOperation> | LiteralOperation[] | null; } | { getField`: `string`; } | { `convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation; to: ”string”|”double”|”int”|”bool”|”exists”; }; } | { size`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation; })[]; } | { `not: any[]; } | { eq`: `any`[]; } | { `gt: any[]; } | { lt`: `any`[]; } | { `gte: any[]; } | { lte`: `any`[]; } | { `in: any[]; } | { contains`: { `case_insensitive?`: `boolean` | `null`; `input`: { `and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation[]; } | { or`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation[]; } | { `not: any[]; } | { eq`: `any`[]; } | { `gt: any[]; } | { lt`: `any`[]; } | { `gte: any[]; } | { lte`: `any`[]; } | { `in: any[]; } | ContainsOperation | { literal`: `string` | `number` | `boolean` | `Record`<`string`, LiteralOperation> | LiteralOperation[] | `null`; } | { `getField: string; } | { convert`: { `input`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation; `to`: `"string"` | `"double"` | `"int"` | `"bool"` | `"exists"`; }; } | { `size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation; }; substr: { and`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation[]; } | { `or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation[]; } | { not`: `any`[]; } | { `eq: any[]; } | { gt`: `any`[]; } | { `lt: any[]; } | { gte`: `any`[]; } | { `lte: any[]; } | { in`: `any`[]; } | ContainsOperation | { `literal: string|number|boolean|Record<string, LiteralOperation> | LiteralOperation[] | null; } | { getField`: `string`; } | { `convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation; to: ”string”|”double”|”int”|”bool”|”exists”; }; } | { $size`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; }; }; }
$Expr

​
Union Members

型リテラル
{ $and: (AndOperation | { $or: (AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他6件 … | SizeOperation)[]; } | { $not: any[]; } | { $eq: any[]; } | { $gt: any[]; } | { $lt: any[]; } | { $gte: any[]; } | { $lte: any[]; } | { $in: any[]; } | { $contains: { case_insensitive?: boolean | null; input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他6件 … | SizeOperation; substr: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他6件 … | SizeOperation; }; } | { $literal: string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null; } | { $getField: string; } | { $convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他6件 … | SizeOperation; to: "string" | "double" | "int" | "bool" | "exists"; }; } | { $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他6件 … | SizeOperation; })[]; }
$and
**and**: (AndOperation | &#123; `or: (AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation)[]; &#125; | &#123; not`: `any`[]; &#125; | &#123; `eq: any[]; &#125; | &#123; gt`: `any`[]; &#125; | &#123; `lt: any[]; &#125; | &#123; gte`: `any`[]; &#125; | &#123; `lte: any[]; &#125; | &#123; in`: `any`[]; &#125; | &#123; `contains: &#123; case_insensitive?: boolean|null; input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation; substr: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation; &#125;; &#125; | &#123; literal`: `string` | `number` | `boolean` | `Record`&lt;`string`, LiteralOperation&gt; | LiteralOperation[] | `null`; &#125; | &#123; `getField: string; &#125; | &#123; convert`: &#123; `input`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 more ... | SizeOperation; `to`: `"string"` | `"double"` | `"int"` | `"bool"` | `"exists"`; &#125;; &#125; | &#123; `size`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; })[]
$And
型リテラル
{ $or: ({ $and: (AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation)[]; } | OrOperation | { $not: any[]; } | { $eq: any[]; } | { $gt: any[]; } | { $lt: any[]; } | { $gte: any[]; } | { $lte: any[]; } | { $in: any[]; } | { $contains: { case_insensitive?: boolean | null; input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; substr: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; }; } | { $literal: string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null; } | { $getField: string; } | { $convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; to: "string" | "double" | "int" | "bool" | "exists"; }; } | { $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; })[]; }
$or
**or**: (&#123; `and: (AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 他6件 ... | SizeOperation)[]; &#125; | OrOperation | &#123; not`: `any`[]; &#125; | &#123; `eq: any[]; &#125; | &#123; gt`: `any`[]; &#125; | &#123; `lt: any[]; &#125; | &#123; gte`: `any`[]; &#125; | &#123; `lte: any[]; &#125; | &#123; in`: `any`[]; &#125; | &#123; `contains: &#123; case_insensitive?: boolean|null; input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 他6件 ... | SizeOperation; substr: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 他6件 ... | SizeOperation; &#125;; &#125; | &#123; literal`: `string` | `number` | `boolean` | `Record`&lt;`string`, LiteralOperation&gt; | LiteralOperation[] | `null`; &#125; | &#123; `getField: string; &#125; | &#123; convert`: &#123; `input`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 他6件 ... | SizeOperation; `to`: `"string"` | `"double"` | `"int"` | `"bool"` | `"exists"`; &#125;; &#125; | &#123; `size`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他6件 … | SizeOperation; })[]
$Or
型リテラル
{ $not: any[]; }
$not
$not: any[]
$Not
Max Items
1
Min Items
1
型リテラル
{ $eq: any[]; }
$eq
$eq: any[]
$Eq
Max Items
2
Min Items
2
型リテラル
{ $gt: any[]; }
$gt
$gt: any[]
$Gt
Max Items
2
Min Items
2
型リテラル
{ $lt: any[]; }
$lt
$lt: any[]
$Lt
Max Items
2
Min Items
2
型リテラル
{ $gte: any[]; }
$gte
$gte: any[]
$Gte
Max Items
2
Min Items
2
型リテラル
{ $lte: any[]; }
$lte
$lte: any[]
$Lte
Max Items
2
Min Items
2
型リテラル
{ $in: any[]; }
$in
$in: any[]
$In
Max Items
2
Min Items
2
型リテラル
{ $contains: { case_insensitive?: boolean | null; input: { $and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]; } | { $or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]; } | { $not: any[]; } | { $eq: any[]; } | { $gt: any[]; } | { $lt: any[]; } | { $gte: any[]; } | { $lte: any[]; } | { $in: any[]; } | ContainsOperation | { $literal: string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null; } | { $getField: string; } | { $convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; to: "string" | "double" | "int" | "bool" | "exists"; }; } | { $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; }; substr: { $and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]; } | { $or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]; } | { $not: any[]; } | { $eq: any[]; } | { $gt: any[]; } | { $lt: any[]; } | { $gte: any[]; } | { $lte: any[]; } | { $in: any[]; } | ContainsOperation | { $literal: string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null; } | { $getField: string; } | { $convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; to: "string" | "double" | "int" | "bool" | "exists"; }; } | { $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; }; }; }
$contains
$contains: object
$contains 操作の仕様です。
  • input: 検索対象の string。
  • substr: 検索する部分文字列。
  • case_insensitive: true の場合、大文字と小文字を区別せずに一致します。
$contains.case_insensitive
optional case_insensitive: boolean | null
大文字と小文字を区別しない
デフォルト
$contains.input
input: { $and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]; } | { $or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]; } | { $not: any[]; } | { $eq: any[]; } | { $gt: any[]; } | { $lt: any[]; } | { $gte: any[]; } | { $lte: any[]; } | { $in: any[]; } | ContainsOperation | { $literal: string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null; } | { $getField: string; } | { $convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; to: "string" | "double" | "int" | "bool" | "exists"; }; } | { $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; }
入力
Union Members
型リテラル
{ $and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他 6 件 … | SizeOperation[]; }
$and
$and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他 6 件 … | SizeOperation[]
$And
型リテラル
{ $or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他 6 件 … | SizeOperation[]; }
$or
$or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他 6 件 … | SizeOperation[]
$Or
型リテラル
{ $not: any[]; }
$not
$not: any[]
$Not
Max Items
1
Min Items
1
型リテラル
{ $eq: any[]; }
$eq
$eq: any[]
$Eq
Max Items
2
Min Items
2
型リテラル
{ $gt: any[]; }
$gt
$gt: any[]
$Gt
Max Items
2
Min Items
2
型リテラル
{ $lt: any[]; }
$lt
$lt: any[]
$Lt
Max Items
2
Min Items
2
型リテラル
{ $gte: any[]; }
$gte
$gte: any[]
$Gte
Max Items
2
Min Items
2
型リテラル
{ $lte: any[]; }
$lte
$lte: any[]
$Lte
Max Items
2
Min Items
2
型リテラル
{ $in: any[]; }
$in
$in: any[]
$In
Max Items
2
Min Items
2
ContainsOperation
型リテラル
{ $literal: string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null; }
$literal
$literal: string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null
$Literal
型リテラル
{ $getField: string; }
$getField
$getField: string
$Getfield
型リテラル
{ $convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他 6 件 … | SizeOperation; to: "string" | "double" | "int" | "bool" | "exists"; }; }
$convert
$convert: object
$convert の変換の詳細を指定します。
  • input: 変換するオペランド。
  • to: 変換先のタイプ。
$convert.input
input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation
入力
$convert.to
to: "string" | "double" | "int" | "bool" | "exists"
To
型リテラル
{ $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他 6 件 … | SizeOperation; }
$size
$size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他 6 件 … | SizeOperation
$Size
$contains.substr
substr: { $and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]; } | { $or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]; } | { $not: any[]; } | { $eq: any[]; } | { $gt: any[]; } | { $lt: any[]; } | { $gte: any[]; } | { $lte: any[]; } | { $in: any[]; } | ContainsOperation | { $literal: string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null; } | { $getField: string; } | { $convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; to: "string" | "double" | "int" | "bool" | "exists"; }; } | { $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; }
Substr
Union Members
型リテラル
{ $and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他 6 件 … | SizeOperation[]; }
$and
$and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他 6 件 … | SizeOperation[]
$And
型リテラル
{ $or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他 6 件 … | SizeOperation[]; }
$or
$or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他 6 件 … | SizeOperation[]
$Or
型リテラル
{ $not: any[]; }
$not
$not: any[]
$Not
Max Items
1
Min Items
1
型リテラル
{ $eq: any[]; }
$eq
$eq: any[]
$Eq
Max Items
2
Min Items
2
型リテラル
{ $gt: any[]; }
$gt
$gt: any[]
$Gt
Max Items
2
Min Items
2
型リテラル
{ $lt: any[]; }
$lt
$lt: any[]
$Lt
Max Items
2
Min Items
2
型リテラル
{ $gte: any[]; }
$gte
$gte: any[]
$Gte
Max Items
2
Min Items
2
型リテラル
{ $lte: any[]; }
$lte
$lte: any[]
$Lte
Max Items
2
Min Items
2
型リテラル
{ $in: any[]; }
$in
$in: any[]
$In
Max Items
2
Min Items
2
ContainsOperation
型リテラル
{ $literal: string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null; }
$literal
$literal: string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null
$Literal
型リテラル
{ $getField: string; }
$getField
$getField: string
$Getfield
型リテラル
{ $convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他 6 件 … | SizeOperation; to: "string" | "double" | "int" | "bool" | "exists"; }; }
$convert
$convert: object
$convert の変換の詳細を指定します。
  • input: 変換対象のオペランド。
  • to: 変換先のタイプ。
$convert.input
input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他6件 … | SizeOperation
入力
$convert.to
to: "string" | "double" | "int" | "bool" | "exists"
変換先
型リテラル
{ $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他 6 件 … | SizeOperation; }
$size
$size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 他 6 件 … | SizeOperation
$Size