JSON Conditions

Schema

{
  "operator": "string",
  "path": "string",
  "case_sensitive": true|false,
  "default": true|false,
  "value": "any",
  "value_path": "string",
  "value_type": "string",
  "match_type": "all|any",
  "conditions": [ 
    {}
  ]
}

Fields

operator (Required)

Specifies the logical or comparison operation to perform.

conditions

A list of child conditions. Used with logical operators (and, or, not, tree).

path

The dot notation JSON path pointing to the element(s) in the document to evaluate, e.g. user.address.city or items[*].price

value

The value to compare against the document's data at path. The type should align with value_type.

value_path

An alternative to value. If specified, the value to compare against will be dynamically retrieved from the document itself using this dot notation JSON path.

value_type

Specifies the data type for comparison; values are

case_sensitive

If true, string comparisons (e.g., eq, ne, match) will be case-sensitive.

match_type

When path resolves to multiple tokens (e.g. an array), this defines how the condition is applied.

• all: The condition must be true for all resolved tokens.
• any: The condition must be true for at least one resolved token.

default

If true, and the path does not exist, the condition will evaluate to true. This is useful for providing default behavior when data is optional.

Examples

Simple Equality Check

Match documents where status is active.

{
  "operator": "eq",  
  "path": "status",
  "value": "active",
  "case_sensitive": false
}

Logical AND

Match documents where category is "electronics" AND price is greater than 500.

{
  "operator": "amd",
  "conditions": [
    {
      "operator": "eq",  
      "path": "category",
      "value": "electronics",
      "case_sensitive": false
    },
    {
      "operator": "gt",  
      "path": "price",
      "value": 500,
      "value_type": "number"
    }
  ]
}

Logical OR with Case-Insensitive Match

Match documents where tag is urgent (case-insensitive) OR priority is high.

{
  "operator": "or",
  "conditions": [
    {
      "operator": "eq",  
      "path": "tag",
      "value": "urgent",
      "case_sensitive": false
    },
    {
      "operator": "eq",  
      "path": "priority",
      "value": "high",
      "case_sensitive": false
    }
  ]
}

Existence Check

Match documents that have a metadata.timestamp field.

{
  "operator": "exists",
  "path": "metadata.timestamp",
}

Regular Expression Match

Match documents where product_code starts with "ABC-".

{
  "condition": "match",
  "path": "product_code",
  "value": "^ABC-.*$",
  "case_sensitive": false
}

Array Element Matching (match_type)

Match documents where any item in the tags array is "featured".

{
  "operator": "eq",
  "path": "tags[*]",
  "value": "featured",
  "match_type": "any"
}

Dynamic Value Comparison (value_path)

Match documents where item.price is greater than item.cost.

{
  "operator": "gt",
  "path": "item.price",
  "value_path": "item.cost",
  "value_type": "number"
}

Count Operator

Match documents where the $.items array has exactly 3 elements.

{
  "operator": "count",
  "path": "items",
  "value": 3,
  "value_type": "number"
}

IsNull

Match documents where description is null.

{
  "operator": "isnull",
  "path": "description"
}