# About CompareValidator

The ComparisonValidator performs a logical comparison between an attribute value and another value. The supported operators are:

- `EQUALS`

- `NOT EQUALS`

- `GREATER THAN`

- `GREATER OR EQUAL TO`

- `LESS THAN`

- `LESS OR EQUAL TO`

The other value can be either a literal value, the results of a SQL query, or the results of a view object query:

Type | Description
Literal value | The list is created by providing one or more literal values to compare.
Query result | The list is created by executing a SQL query using a custom view object. The values are defined by the first column returned by the query. In both `ListValidator` and `CompareValidator`, attributes from the entity object being validated can be used as bind variables, for example, "`SELECT UNIQUE loc FROM dept WHERE loc = %Loc%`", where `Loc` is an attribute on the entity object being validated and thus has a method `getLoc` defined on it.
View object attribute | The list is created by executing the query for a predefined view object. Choose the view object from the tree structure.