Version: 96.2

CommunityEnterprise

Examples

Interactive examples!

All examples on this page are fully interactive! You can modify both the kJQ filter and the JSON data in real-time to see how different filters work.

Changes update instantly as you type, making it easy to experiment and learn kJQ syntax.

Basic filters

Truthy filter

Check if a field exists and is not null:

JSON Input

{
  "key": {
    "id": "user123"
  },
  "value": {
    "tx": {
      "status": true,
      "amount": 150
    },
    "meta": {
      "timestamp": "2023-06-20"
    }
  }
}

Filter Result

Scalar comparator filter

Compare values against numbers:

JSON Input

{
  "key": {
    "id": "tx456"
  },
  "value": {
    "tx": {
      "amount": 11,
      "status": "pending"
    }
  }
}

Filter Result

Selector comparator filter

Compare two fields within the same record:

JSON Input

{
  "key": {
    "id": "promo789"
  },
  "value": {
    "tx": {
      "amount": 10,
      "discount": 10,
      "status": "complete"
    }
  }
}

Filter Result

Function filters

Contains function

Check if a string or array contains specific text:

JSON Input

{
  "key": {
    "id": "alert001"
  },
  "value": {
    "tx": {
      "labels": [
        "URGENT-PENDING",
        "HIGH-PRIORITY"
      ],
      "amount": 500
    }
  }
}

Filter Result

Regex tests

Test if a field matches a regular expression:

JSON Input

{
  "key": {
    "id": "order_tx"
  },
  "value": {
    "tx": {
      "amount": 100,
      "currency": "USD"
    }
  }
}

Filter Result

Negated filter

Use not to invert filter results:

JSON Input

[
  {
    "tx": {
      "status": "COMPLETE",
      "amount": 250
    }
  }
]

Filter Result

Advanced selectors

Quoted selectors

Handle special characters in field names:

JSON Input

{
  "key": {
    "id": "seasonal_item"
  },
  "value": {
    "price.with.tax": 15.99,
    "category!": "seasonal",
    "description": "Holiday special"
  }
}

Filter Result

Multiple filters

AND operations

All conditions must be true:

JSON Input

{
  "key": {
    "currency": "USD"
  },
  "value": {
    "tx": {
      "amount": 15,
      "discount": 15,
      "labels": [
        "URGENT-PENDING"
      ]
    }
  }
}

Filter Result

OR operations

Any condition can be true:

JSON Input

{
  "key": {
    "currency": "EUR"
  },
  "value": {
    "tx": {
      "amount": 20,
      "discount": 5,
      "labels": [
        "URGENT-PROCESSING"
      ]
    }
  }
}

Filter Result

Mixed logic with precedence

Complex filters with explicit precedence using parentheses:

JSON Input

{
  "key": {
    "currency": "GBP"
  },
  "value": {
    "tx": {
      "price": 15.75,
      "pan": "****-****-****-8649",
      "discount": "3.98"
    }
  }
}

Filter Result

Date filtering

Basic date comparison

Convert dates to ISO-8601 format for comparison:

JSON Input

{
  "key": {
    "id": "event001"
  },
  "value": {
    "tx": {
      "start_date": "2023-06-15T10:30:00Z",
      "amount": 100
    }
  }
}

Filter Result

Unix timestamp comparison

Unix timestamps work directly with date manipulation:

JSON Input

{
  "key": {
    "id": "event001"
  },
  "value": {
    "tx": {
      "timestamp": 1693161507,
      "amount": 100
    }
  }
}

Filter Result

Date range filtering

Check if a date falls within a specific range:

JSON Input

{
  "key": {
    "id": "yearly_report"
  },
  "value": {
    "tx": {
      "start_date": "2023-03-15T08:00:00Z",
      "end_date": "2023-03-15T17:00:00Z"
    }
  }
}

Filter Result

Record size filtering

Total record size

Filter by total serialized record size:

JSON Input

{
  "key": {
    "user_id": "12345",
    "session_id": "abcdef"
  },
  "value": {
    "transaction": {
      "id": "tx_987654321",
      "amount": 299.99,
      "currency": "USD",
      "items": [
        {
          "name": "Product A",
          "quantity": 2,
          "price": 99.99
        },
        {
          "name": "Product B",
          "quantity": 1,
          "price": 100.01
        }
      ]
    }
  },
  "size": 180
}

Filter Result

Key and value sizes

Filter by individual component sizes:

JSON Input

{
  "key": {
    "id": "123"
  },
  "value": {
    "description": "This is a longer description that should exceed the minimum value size requirement for our filter",
    "metadata": {
      "created": "2023-06-20",
      "updated": "2023-06-21"
    }
  },
  "key-size": 25,
  "value-size": 120
}

Filter Result

Null key check

Find records with null keys:

JSON Input

{
  "key": null,
  "value": {
    "anonymous_event": true,
    "timestamp": "2023-06-20T10:00:00Z"
  }
}

Filter Result

Tombstone records

Find all records that are Kafka tombstone records:

JSON Input

{
  "key": "USER-1",
  "value": null
}

Filter Result

String slicing

Basic string slicing

Extract and compare substrings:

JSON Input

{
  "key": {
    "id": "order_001"
  },
  "value": {
    "transaction_id": "TXN12345",
    "amount": 150
  }
}

Filter Result

String slicing from end

Use negative indices to slice from the end:

JSON Input

{
  "key": {
    "timestamp": "2023-06-20T10:00:00Z"
  },
  "value": {
    "log_entry": "2023-06-20T10:00:00 FATAL_ERROR",
    "severity": "high"
  }
}

Filter Result

Complex nested string slicing

Extract substrings from nested objects:

JSON Input

{
  "key": {
    "event_batch": "batch_001"
  },
  "value": {
    "events": [
      {
        "timestamp": "2023-06-20T10:00:00Z",
        "type": "click"
      },
      {
        "timestamp": "2023-06-20T11:00:00Z",
        "type": "view"
      }
    ]
  }
}

Filter Result

Alternative and arithmetic operations

Alternative operator

Use fallback values with the // operator:

JSON Input

{
  "key": {
    "order": "12345"
  },
  "value": {
    "customer_id": "C123",
    "order_total": 299.99
  }
}

Filter Result

Basic arithmetic

Perform calculations on numeric fields:

JSON Input

{
  "key": {
    "invoice": "INV001"
  },
  "value": {
    "base_price": 80,
    "tax": 25,
    "currency": "USD"
  }
}

Filter Result

Success rate calculation

Calculate ratios using division:

JSON Input

{
  "key": {
    "service": "api_gateway"
  },
  "value": {
    "successful_requests": 950,
    "total_requests": 1000,
    "period": "last_hour"
  }
}

Filter Result

Complex arithmetic with alternatives

Combine arithmetic with fallback values:

JSON Input

{
  "key": {
    "customer": "premium_user"
  },
  "value": {
    "discount": 40,
    "coupon_value": 15,
    "total_savings": 55
  }
}

Filter Result

Map and select

Extracting user IDs from events

Check whether the events collection contains user_123:

JSON Input

{
  "key": {
    "topic": "user_events"
  },
  "value": {
    "events": [
      {
        "user_id": "user_123",
        "action": "login",
        "timestamp": 1634567890
      },
      {
        "user_id": "user_456",
        "action": "purchase",
        "timestamp": 1634567900
      },
      {
        "user_id": "user_789",
        "action": "logout",
        "timestamp": 1634567910
      }
    ]
  }
}

Filter Result

Filtering events with error codes

Extract and filter elements that match specific criteria:

JSON Input

{
  "key": {
    "topic": "application_logs"
  },
  "value": {
    "events": [
      {
        "request_id": "req_001",
        "status": "success",
        "response_time": 120
      },
      {
        "request_id": "req_002",
        "status": "error",
        "error_code": "E500",
        "response_time": 50
      },
      {
        "request_id": "req_003",
        "status": "success",
        "response_time": 95
      },
      {
        "request_id": "req_004",
        "status": "error",
        "error_code": "E404",
        "response_time": 30
      }
    ]
  }
}

Filter Result

Try your own

Use this playground to experiment with your own kJQ filters:

JSON Input

{
  "key": {
    "id": "your_key"
  },
  "value": {
    "example": "Modify this JSON and the filter above",
    "amount": 100,
    "tags": [
      "test",
      "example"
    ]
  }
}

Filter Result

Basic filters​

Truthy filter​

Scalar comparator filter​

Selector comparator filter​

Function filters​

Contains function​

Regex tests​

Negated filter​

Advanced selectors​

Quoted selectors​

Multiple filters​

AND operations​

OR operations​

Mixed logic with precedence​

Date filtering​

Basic date comparison​

Unix timestamp comparison​

Date range filtering​

Record size filtering​

Total record size​

Key and value sizes​

Null key check​

Tombstone records​

String slicing​

Basic string slicing​

String slicing from end​

Complex nested string slicing​

Alternative and arithmetic operations​

Alternative operator​

Basic arithmetic​

Success rate calculation​

Complex arithmetic with alternatives​

Map and select​

Extracting user IDs from events​

Filtering events with error codes​

Try your own​

Basic filters

Truthy filter

Scalar comparator filter

Selector comparator filter

Function filters

Contains function

Regex tests

Negated filter

Advanced selectors

Quoted selectors

Multiple filters

AND operations

OR operations

Mixed logic with precedence

Date filtering

Basic date comparison

Unix timestamp comparison

Date range filtering

Record size filtering

Total record size

Key and value sizes

Null key check

Tombstone records

String slicing

Basic string slicing

String slicing from end

Complex nested string slicing

Alternative and arithmetic operations

Alternative operator

Basic arithmetic

Success rate calculation

Complex arithmetic with alternatives

Map and select

Extracting user IDs from events

Filtering events with error codes

Try your own