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

Type Literal
{ $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; })[]; }
$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 more ... | 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 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; })[]
$Or
유형 리터럴
{ $not: any[]; }
$not
$not: any[]
$Not
최대 항목 수
1
최소 항목 수
1
유형 리터럴
{ $eq: any[]; }
$eq
$eq: any[]
$Eq
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $gt: any[]; }
$gt
$gt: any[]
$Gt
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $lt: any[]; }
$lt
$lt: any[]
$Lt
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $gte: any[]; }
$gte
$gte: any[]
$Gte
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $lte: any[]; }
$lte
$lte: any[]
$Lte
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $in: any[]; }
$in
$in: any[]
$In
최대 항목 수
2
최소 항목 수
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: 검색 대상 문자열입니다.
  • 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 more … | SizeOperation[]; }
$and
$and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]
$And
유형 리터럴
{ $or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]; }
$or
$or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]
$Or
유형 리터럴
{ $not: any[]; }
$not
$not: any[]
$Not
최대 항목 수
1
최소 항목 수
1
유형 리터럴
{ $eq: any[]; }
$eq
$eq: any[]
$Eq
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $gt: any[]; }
$gt
$gt: any[]
$Gt
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $lt: any[]; }
$lt
$lt: any[]
$Lt
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $gte: any[]; }
$gte
$gte: any[]
$Gte
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $lte: any[]; }
$lte
$lte: any[]
$Lte
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $in: any[]; }
$in
$in: any[]
$In
최대 항목 수
2
최소 항목 수
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 more … | 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 more … | 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 more … | SizeOperation[]; }
$and
$and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]
$And
유형 리터럴
{ $or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]; }
$or
$or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]
$Or
유형 리터럴
{ $not: any[]; }
$not
$not: any[]
$Not
최대 항목 수
1
최소 항목 수
1
유형 리터럴
{ $eq: any[]; }
$eq
$eq: any[]
$Eq
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $gt: any[]; }
$gt
$gt: any[]
$Gt
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $lt: any[]; }
$lt
$lt: any[]
$Lt
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $gte: any[]; }
$gte
$gte: any[]
$Gte
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $lte: any[]; }
$lte
$lte: any[]
$Lte
최대 항목 수
2
최소 항목 수
2
유형 리터럴
{ $in: any[]; }
$in
$in: any[]
$In
최대 항목 수
2
최소 항목 수
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 more … | 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"
변환 대상 타입
유형 리터럴
{ $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation; }
$size
$size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6개 더 … | SizeOperation
$Size