Settings:   
Output:  
Data:  
Validation:  
Benchmark:  

SpEL:  
SQL:  
loading styles for mui
(
)
is

Validation errors:no

spelFormat:
(user.login == user.firstName.toLowerCase() && stock == false && slider == 35 && results.?[product == 'abc' && score > 8].size() > 0 && cars.?[vendor == 'Toyota' && year >= 2010].size() > 2)

stringFormat:
(t1.login == LOWER(user.firstName) && stock is false && slider == 35 && (results.product == "abc" && results.score > 8) && COUNT OF cars WHERE (vendor == "Toyota" && year >= 2010) > 2)

humanStringFormat:
(User.login = Lowercase(String: Username) AND NOT In stock AND Slider = 35 AND (Results.product = abc AND Results.score > 8) AND COUNT OF Cars WHERE (vendor = Toyota AND year >= 2010) > 2)

sqlFormat:
[
  "Aggregation is not supported for cars"
]
(t1.login = LOWER(user.firstName) AND stock = false AND slider = 35 AND (results.product = 'abc' AND results.score > 8) AND (cars.vendor = 'Toyota' AND cars.year >= 2010))

jsonLogicFormat:
// Rule:
{ "and": [ { "==": [ { "var": "user.login" }, { "toLowerCase": [ { "var": "user.firstName" } ] } ] }, { "==": [ { "var": "stock" }, false ] }, { "==": [ { "var": "slider" }, 35 ] }, { "some": [ { "var": "results" }, { "and": [ { "==": [ { "var": "product" }, "abc" ] }, { ">": [ { "var": "score" }, 8 ] } ] } ] }, { ">": [ { "reduce": [ { "filter": [ { "var": "cars" }, { "and": [ { "==": [ { "var": "vendor" }, "Toyota" ] }, { ">=": [ { "var": "year" }, 2010 ] } ] } ] }, { "+": [ 1, { "var": "accumulator" } ] }, 0 ] }, 2 ] } ] }

// Data:
{ "user": { "firstName": null, "login": null }, "stock": null, "slider": null, "results": [ { "product": null, "score": null } ], "cars": [ { "vendor": null, "year": null } ] }

mongodbFormat:
{
  "$and": [
    {
      "$expr": {
        "$eq": [
          "$user.login",
          {
            "$toLower": "$user.firstName"
          }
        ]
      }
    },
    {
      "stock": false
    },
    {
      "slider": 35
    },
    {
      "results": {
        "$elemMatch": {
          "product": "abc",
          "score": {
            "$gt": 8
          }
        }
      }
    },
    {
      "$expr": {
        "$gt": [
          {
            "$size": {
              "$ifNull": [
                {
                  "$filter": {
                    "input": "$cars",
                    "as": "el",
                    "cond": {
                      "$and": [
                        {
                          "$eq": [
                            "$$el.vendor",
                            "Toyota"
                          ]
                        },
                        {
                          "$gte": [
                            "$$el.year",
                            2010
                          ]
                        }
                      ]
                    }
                  }
                },
                []
              ]
            }
          },
          2
        ]
      }
    }
  ]
}

elasticSearchFormat:
{
  "bool": {
    "must": [
      {
        "term": {
          "stock": false
        }
      },
      {
        "term": {
          "slider": 35
        }
      },
      {
        "bool": {
          "must": [
            {
              "term": {
                "results.product": "abc"
              }
            },
            {
              "range": {
                "results.score": {
                  "gt": "8"
                }
              }
            }
          ]
        }
      },
      {
        "bool": {
          "must": [
            {
              "term": {
                "cars.vendor": "Toyota"
              }
            },
            {
              "range": {
                "cars.year": {
                  "gte": "2010"
                }
              }
            }
          ]
        }
      }
    ]
  }
}

Tree:
{
  "type": "group",
  "id": "9a99988a-0123-4456-b89a-b1607f326fd8",
  "children1": [
    {
      "id": "a98ab9b9-cdef-4012-b456-71607f326fd9",
      "type": "rule",
      "properties": {
        "field": "user.login",
        "operator": "equal",
        "value": [
          {
            "func": "string.LOWER",
            "args": {
              "str": {
                "valueSrc": "field",
                "value": "user.firstName"
              }
            }
          }
        ],
        "valueSrc": [
          "func"
        ],
        "valueType": [
          "text"
        ],
        "valueError": [
          null
        ],
        "fieldSrc": "field"
      }
    },
    {
      "id": "98a8a9ba-0123-4456-b89a-b16e721c8cd0",
      "type": "rule",
      "properties": {
        "field": "stock",
        "operator": "equal",
        "value": [
          false
        ],
        "valueSrc": [
          "value"
        ],
        "valueType": [
          "boolean"
        ],
        "valueError": [
          null
        ],
        "fieldSrc": "field"
      }
    },
    {
      "id": "aabbab8a-cdef-4012-b456-716e85c65e9c",
      "type": "rule",
      "properties": {
        "field": "slider",
        "operator": "equal",
        "value": [
          35
        ],
        "valueSrc": [
          "value"
        ],
        "valueType": [
          "number"
        ],
        "valueError": [
          null
        ],
        "fieldSrc": "field"
      }
    },
    {
      "id": "aaab8999-cdef-4012-b456-71702cd50090",
      "type": "rule_group",
      "properties": {
        "conjunction": "AND",
        "field": "results"
      },
      "children1": [
        {
          "id": "99b8a8a8-89ab-4cde-b012-31702cd5078b",
          "type": "rule",
          "properties": {
            "field": "results.product",
            "operator": "select_equals",
            "value": [
              "abc"
            ],
            "valueSrc": [
              "value"
            ],
            "valueType": [
              "select"
            ],
            "valueError": [
              null
            ],
            "fieldSrc": "field"
          }
        },
        {
          "id": "88b9bb89-4567-489a-bcde-f1702cd53266",
          "type": "rule",
          "properties": {
            "field": "results.score",
            "operator": "greater",
            "value": [
              8
            ],
            "valueSrc": [
              "value"
            ],
            "valueType": [
              "number"
            ],
            "valueError": [
              null
            ],
            "fieldSrc": "field"
          }
        }
      ]
    },
    {
      "id": "a99a9b9b-cdef-4012-b456-7175a7d54553",
      "type": "rule_group",
      "properties": {
        "mode": "array",
        "operator": "greater",
        "valueType": [
          "number"
        ],
        "value": [
          2
        ],
        "valueSrc": [
          "value"
        ],
        "conjunction": "AND",
        "valueError": [
          null
        ],
        "field": "cars",
        "fieldSrc": "field"
      },
      "children1": [
        {
          "id": "99a9a9a8-89ab-4cde-b012-3175a7d55374",
          "type": "rule",
          "properties": {
            "field": "cars.vendor",
            "operator": "select_equals",
            "value": [
              "Toyota"
            ],
            "valueSrc": [
              "value"
            ],
            "valueError": [
              null
            ],
            "valueType": [
              "select"
            ],
            "fieldSrc": "field"
          }
        },
        {
          "id": "988bbbab-4567-489a-bcde-f175a7d58793",
          "type": "rule",
          "properties": {
            "field": "cars.year",
            "operator": "greater_or_equal",
            "value": [
              2010
            ],
            "valueSrc": [
              "value"
            ],
            "valueError": [
              null
            ],
            "valueType": [
              "number"
            ],
            "fieldSrc": "field"
          }
        }
      ]
    }
  ],
  "properties": {
    "conjunction": "AND",
    "not": false
  }
}