Filter docs

Example 1: Find records where cut = "Premium"

{
  "path": "cut",
  "op": "Equals",
  "arg": "Premium",
}

Example 2: Find records and cut = "Premium" and price > 1000

{
  "children": [
    {
      "path": "cut",
      "op": "Equals",
      "arg": "Premium",

    },
    {
      "path": "price",
      "op": "GreaterThan",
      "arg": 1000.0,

    }
  ]
}

Example 3: Find records and cut = "Premium" or color != "J11"

{
  "match_all": false,
  "children": [
    {
      "path": "cut",
      "op": "Equals",
      "arg": "Premium",

    },
    {
      "path": "color",
      "op": "Equals",
      "arg": "J11",
      "negate": true
    }
  ]
}

Example 4: Find records where cut in ("Premium", "Ideal"). Note the arg value contains multiple values separated by comma.

{
  "path": "cut",
  "op": "In",
  "arg": "Premium,Ideal",
}

Operators Equals, In, StartsWith, EndsWith, Contains, LessThan, LessThanEquals, GreaterThan, GreaterThanEquals, IsNull