Criteria Operators
Criteria operators are used to compare two values. When the comparison is true, a record is included. When the comparison is false, the record is not included.
Note: If the Not column is checked, the comparison is reversed.
Example: When running the Staff Sign In report, the Query Parameters form is displayed. By specifying that "Shift" = "A", all A shift staff will be included in the report. Check not and all staff except A shift staff are included in the report.
Note: There are limited search options for narrative and notes fields in FH Enterprise. Equal (=) and like ($) are the only operators allowed for searching for values in narrative and notes fields in FH Enterprise.
Operator | Stands for | Means this |
---|---|---|
= |
Equal to |
If the comparison matches the matching record is included in the results. |
== |
Exactly Equal to |
If the comparison matches character for character the matching record is included in the results. |
<> |
Not Equal to |
If the comparison does not match the record is included in the results. |
>= |
Greater Than or Equal to |
If the comparison matches or is a greater value the record is included in the results. |
> |
Greater Than |
If the comparison is a greater value the record is included in the results. |
<= |
Less Than or Equal to |
If the comparison matches or is a lesser value the record is included in the results. |
< |
Less Than |
If the comparison is a lesser value the record is included in the results. |
$ |
Contains |
If the comparison results in a match the record is included in the results. Example: States that contain an "X", which include New Mexico and Texas. |
In |
In List of Values |
If the comparison matches the record is included in the results. This allows you to specify a list of values to use in the comparison. If a lookup is available, press to display available values, or type each comparison value in quotations separated by a comma ("example 1","example 2"). |
Between |
Between Values |
If the comparison matches and is in between the two specified values the record is included in the results. |
Empty |
Empty Value |
If the specified field is empty the record is included in the results. |
Null |
Null Value |
If the specified field contains a NULL value, the record is included in the results. Having no explicitly assigned value, NULL is not equivalent to zero or blank. A value of NULL is not considered to be greater than, less than, different than, or equivalent to any other value, including another value of NULL. |
Related Topics: