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

Littéral de type
{ $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
Littéral de type
{ $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 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
Littéral de type
{ $not: any[]; }
$not
$not : any[]
$Not
Nombre maximal d’éléments
1
Min Items
1
Littéral de type
{ $eq: any[]; }
$eq
$eq: any[]
$Eq
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $gt: any[]; }
$gt
$gt : any[]
$Gt
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $lt: any[]; }
$lt
$lt : any[]
$Lt
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $gte: any[]; }
$gte
$gte : any[]
$Gte
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $lte: any[]; }
$lte
$lte : any[]
$Lte
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $in: any[]; }
$in
$in: any[]
$In
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $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
$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.
$contains.case_insensitive
optional case_insensitive : boolean | null
Insensible à la casse
Par défaut
$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; }
Entrée
Membres de l’union
Littéral de type
{ $and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation[]; }
$and
$and : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation[]
$And
Littéral de type
{ $or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 more … | SizeOperation[]; }
$or
$or : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation[]
$Or
Littéral de type
{ $not: any[]; }
$not
$not : any[]
$Not
Nombre maximal d’éléments
1
Min Items
1
Littéral de type
{ $eq: any[]; }
$eq
$eq: any[]
$Eq
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $gt: any[]; }
$gt
$gt: any[]
$Gt
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $lt: any[]; }
$lt
$lt : any[]
$Lt
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $gte: any[]; }
$gte
$gte : any[]
$Gte
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $lte: any[]; }
$lte
$lte : any[]
$Lte
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $in: any[]; }
$in
$in: any[]
$In
Nombre maximal d’éléments
2
Min Items
2
ContainsOperation
Littéral de type
{ $literal: string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null; }
$literal
$literal : string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null
$Literal
Littéral de type
{ $getField: string; }
$getField
$getField : string
$Getfield
Littéral de type
{ $convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation; to: "string" | "double" | "int" | "bool" | "exists"; }; }
$convert
$convert : object
Spécifie les détails de conversion pour $convert.
  • input : l’opérande à convertir.
  • to : le type cible de la conversion.
$convert.input
input : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation
Entrée
$convert.to
to : "string" | "double" | "int" | "bool" | "exists"
To
Littéral de type
{ $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation; }
$size
$size : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | 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
Membres de l’union
Littéral de type
{ $and: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation[]; }
$and
$and : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation[]
$And
Littéral de type
{ $or: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation[]; }
$or
$or : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation[]
$Or
Littéral de type
{ $not: any[]; }
$not
$not: any[]
$Not
Nombre maximal d’éléments
1
Min Items
1
Littéral de type
{ $eq: any[]; }
$eq
$eq: any[]
$Eq
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $gt: any[]; }
$gt
$gt: any[]
$Gt
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $lt: any[]; }
$lt
$lt : any[]
$Lt
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $gte: any[]; }
$gte
$gte : any[]
$Gte
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $lte: any[]; }
$lte
$lte: any[]
$Lte
Nombre maximal d’éléments
2
Min Items
2
Littéral de type
{ $in: any[]; }
$in
$in: any[]
$In
Nombre maximal d’éléments
2
Min Items
2
ContainsOperation
Littéral de type
{ $literal: string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null; }
$literal
$literal : string | number | boolean | Record<string, LiteralOperation> | LiteralOperation[] | null
$Literal
Littéral de type
{ $getField: string; }
$getField
$getField : string
$Getfield
Littéral de type
{ $convert: { input: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation; to: "string" | "double" | "int" | "bool" | "exists"; }; }
$convert
$convert : object
Spécifie les détails de conversion pour $convert.
  • input : l’opérande à convertir.
  • to : le type cible de la conversion.
$convert.input
input : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation
Entrée
$convert.to
to: "string" | "double" | "int" | "bool" | "exists"
To
Littéral de type
{ $size: AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 de plus … | SizeOperation; }
$size
$size : AndOperation | OrOperation | NotOperation | EqOperation | GtOperation | LtOperation | GteOperation | … 6 autres … | SizeOperation
$Size