gistfile1.json

{
  "id": "a0d36000000m9U6AAI",
  "table": "consumers",
  "condition": "OR",
  "rules": [
    {
      "condition": "AND",
      "rules": [
        {
          "id": "name_first",
          "field": "name_first",
          "type": "string",
          "input": "text",
          "operator": "equal",
          "value": "Maura"
        },
        {
          "id": "zip",
          "field": "zip",
          "type": "string",
          "input": "text",
          "operator": "equal",
          "value": "20740"
        },
        {
          "id": "age",
          "field": "age",
          "type": "integer",
          "input": "text",
          "operator": "greater_or_equal",
          "value": "18"
        },
        {
          "condition": "AND",
          "rules": [
            {
              "id": "name_first",
              "field": "name_first",
              "type": "string",
              "input": "text",
              "operator": "not_contains",
              "value": "Beers"
            },
            {
              "id": "age",
              "field": "age",
              "type": "integer",
              "input": "text",
              "operator": "between",
              "value": [
                "10",
                "30"
              ]
            }
          ]
        }
      ]
    },
    {
      "condition": "AND",
      "rules": [
        {
          "id": "name_last",
          "field": "name_last",
          "type": "string",
          "input": "text",
          "operator": "begins_with",
          "value": "Franco"
        },
        {
          "id": "num_of_children",
          "field": "num_of_children",
          "type": "integer",
          "input": "text",
          "operator": "less_or_equal",
          "value": "4"
        },
        {
          "id": "median_income",
          "field": "median_income",
          "type": "double",
          "input": "text",
          "operator": "greater_or_equal",
          "value": "40.8"
        }
      ]
    },
    {
      "id": "city",
      "field": "city",
      "type": "string",
      "input": "text",
      "operator": "equal",
      "value": "College Park"
    }
  ]
}