Skip to main content
Requête

​
Propriétés

​
$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

​
Membres de l’union

{ $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** : (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**: (&#123; `and: (AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 de plus ... | 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 de plus ... | SizeOperation; substr: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | ... 6 de plus ... | 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 de plus ... | SizeOperation; `to`: `"string"` | `"double"` | `"int"` | `"bool"` | `"exists"`; &#125;; &#125; | &#123; `size`: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation; })[]
$Or
{ $not: any[]; }
$not : any[]
$Not 1 1
{ $eq: any[]; }
$eq: any[]
$Eq 2 2
{ $gt: any[]; }
$gt : any[]
$Gt 2 2
{ $lt: any[]; }
$lt : any[]
$Lt 2 2
{ $gte: any[]; }
$gte : any[]
$Gte 2 2
{ $lte: any[]; }
$lte : any[]
$Lte 2 2
{ $in: any[]; }
$in: any[]
$In 2 2
{ $contains: { case_insensitive?: boolean | null; input: { $and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation[]; } | { $or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | 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 de plus … | SizeOperation; to: "string" | "double" | "int" | "bool" | "exists"; }; } | { $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation; }; substr: { $and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation[]; } | { $or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | 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 de plus … | SizeOperation; to: "string" | "double" | "int" | "bool" | "exists"; }; } | { $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation; }; }; }
$contains : object
Spécification de l’opération $contains.
  • input : la chaîne dans laquelle effectuer la recherche.
  • substr : la sous-chaîne à rechercher.
  • case_insensitive : si la valeur est true, la correspondance ne tient pas compte de la casse.
optional case_insensitive : boolean | null
Insensible à la casse
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; }
Entrée { $and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation[]; }
$and : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation[]
$And
{ $or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]; }
$or : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation[]
$Or
{ $not: any[]; }
$not : any[]
$Not 1 1
{ $eq: any[]; }
$eq: any[]
$Eq 2 2
{ $gt: any[]; }
$gt: any[]
$Gt 2 2
{ $lt: any[]; }
$lt : any[]
$Lt 2 2
{ $gte: any[]; }
$gte : any[]
$Gte 2 2
{ $lte: any[]; }
$lte : any[]
$Lte 2 2
{ $in: any[]; }
$in: any[]
$In 2 2
ContainsOperation
{ $literal: string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null; }
$literal : string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null
$Literal
{ $getField: string; }
$getField : string
$Getfield
{ $convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation; to: "string" | "double" | "int" | "bool" | "exists"; }; }
$convert : object
Spécifie les détails de conversion pour $convert.
  • input : l’opérande à convertir.
  • to : le type cible de la conversion.
input : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation
Entrée
to : "string" | "double" | "int" | "bool" | "exists"
To
{ $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation; }
$size : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation
$Size
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 { $and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation[]; }
$and : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation[]
$And
{ $or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation[]; }
$or : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation[]
$Or
{ $not: any[]; }
$not: any[]
$Not 1 1
{ $eq: any[]; }
$eq: any[]
$Eq 2 2
{ $gt: any[]; }
$gt: any[]
$Gt 2 2
{ $lt: any[]; }
$lt : any[]
$Lt 2 2
{ $gte: any[]; }
$gte : any[]
$Gte 2 2
{ $lte: any[]; }
$lte: any[]
$Lte 2 2
{ $in: any[]; }
$in: any[]
$In 2 2
ContainsOperation
{ $literal: string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null; }
$literal : string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null
$Literal
{ $getField: string; }
$getField : string
$Getfield
{ $convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation; to: "string" | "double" | "int" | "bool" | "exists"; }; }
$convert : object
Spécifie les détails de conversion pour $convert.
  • input : l’opérande à convertir.
  • to : le type cible de la conversion.
input : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation
Entrée
to: "string" | "double" | "int" | "bool" | "exists"
To
{ $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation; }
$size : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation
$Size