QueryObject | asyncairtable

An object to handle filtering the records returned by the #select and #upsert methods.

example

{
  id: 'Some ID',
  $and: [
    {$lte: {count: 10}},
    {$gte: {count: 5}}
  ],
  $or: [
    {$neq: {name: 'datboi'}},
    {$neq: {name: 'graham'}}
  ]
}

Hierarchy

QueryObject

Indexable

[key: string]: QueryField | QueryObject | QueryObject[] | undefined

Shortform equal

example

{field: value}

Index

Properties

Optional $and

$and: QueryObject[]

AND logical operator

example

{$and: [{expression}, {expression}, ...{expression}]}

Optional $eq

$eq: QueryObject

Equal operator

example

{$eq: {field: value}}

Optional $gt

$gt: QueryObject

Greater than operator

example

{$gt: {field: value}}

Optional $gte

$gte: QueryObject

Greater than or equal operator

example

{$gte: {field: value}}

Optional $lt

$lt: QueryObject

Less than operator

example

{$lt: {field: value}}

Optional $lte

$lte: QueryObject

Less than or equal operator

example

{$lte: {field: value}}

Optional $neq

$neq: QueryObject

Not equal operator

example

{$neq: {field: value}}

Optional $not

$not: QueryObject

NOT logical operator

example

{$not: expression}

Optional $or

$or: QueryObject[]

OR logical operator

example

{$or: [{expression}, {expression}, ...{expression}]}