Filter Operators

Complete reference for query filter operators.

Comparison Operators

eq - Equal

{
  "column": "status",
  "operator": "eq",
  "value": "active"
}

SQL: status = 'active'

neq - Not Equal

{
  "column": "status",
  "operator": "neq",
  "value": "deleted"
}

SQL: status != 'deleted'

gt - Greater Than

{
  "column": "age",
  "operator": "gt",
  "value": 18
}

SQL: age > 18

gte - Greater Than or Equal

{
  "column": "price",
  "operator": "gte",
  "value": 100
}

SQL: price >= 100

lt - Less Than

{
  "column": "stock",
  "operator": "lt",
  "value": 10
}

SQL: stock < 10

lte - Less Than or Equal

{
  "column": "rating",
  "operator": "lte",
  "value": 5
}

SQL: rating <= 5

Pattern Matching

like - Pattern Match (Case Sensitive)

{
  "column": "name",
  "operator": "like",
  "value": "%John%"
}

SQL: name LIKE '%John%'

ilike - Pattern Match (Case Insensitive)

{
  "column": "email",
  "operator": "ilike",
  "value": "%@gmail.com"
}

SQL: email ILIKE '%@gmail.com'

Null Checks

is - IS NULL / IS NOT NULL

{
  "column": "deleted_at",
  "operator": "is",
  "value": null
}

SQL: deleted_at IS NULL

Array Operators

in - In Array

{
  "column": "status",
  "operator": "in",
  "value": ["active", "pending", "review"]
}

SQL: status IN ('active', 'pending', 'review')

contains - Array Contains

{
  "column": "tags",
  "operator": "contains",
  "value": ["tech", "news"]
}

SQL: tags @> ARRAY['tech', 'news']

overlaps - Array Overlaps

{
  "column": "categories",
  "operator": "overlaps",
  "value": ["sports", "entertainment"]
}

SQL: categories && ARRAY['sports', 'entertainment']

Dynamic Values

Use templates for dynamic filter values:

{
  "column": "user_id",
  "operator": "eq",
  "value": "{{auth.sub}}"
}

{
  "column": "id",
  "operator": "eq",
  "value": "{{params.id}}"
}

{
  "column": "name",
  "operator": "ilike",
  "value": "%{{query.search}}%"
}

Combining Filters

Multiple filters are combined with AND:

{
  "filters": [
    { "column": "status", "operator": "eq", "value": "active" },
    { "column": "created_at", "operator": "gte", "value": "2024-01-01" },
    { "column": "category", "operator": "in", "value": ["tech", "science"] }
  ]
}

SQL: status = 'active' AND created_at >= '2024-01-01' AND category IN ('tech', 'science')

Operator Reference

Operator	Description	Value Type
eq	Equal	any
neq	Not equal	any
gt	Greater than	number, date
gte	Greater or equal	number, date
lt	Less than	number, date
lte	Less or equal	number, date
like	Pattern match	string
ilike	Case-insensitive pattern	string
is	IS NULL check	null
in	In array	array
contains	Array contains	array
overlaps	Array overlaps	array