HomeReports in EvergreenAppendicesAppendix C: Operators

3. Appendix C: Operators

Operators describe the ways two pieces of data can be compared to one another.  Operators are used when creating filters to determine which database records should be included in a report.  Different data types have different transform options.

 

Operator

Description


Equals

compares a field’s value and returns any data that matches EXACTLY


Contains Matching Substring

This operator checks if a field contains a specific, case-sensitive substring 

 

Contains Matching Substring (Ignore Case)

This operator identical to Contains Matching Substring, except it is not case-sensitive.

Greater Than

Returns information where the field value is ‘greater than’ the value specified.  For dates, beyond a given date or later than a given date;  For text fields, this means higher strings (for example “oranges” is Greater Than “bananas”);

Greater Than Or Equal To

Greater Than or Equal To is identical to Greater Than, except it also returns data that is equal to your parameter.

Less Than

Returns information where the field value is ‘less than’ the value specified.  For dates, before a given date ;  For text fields, this means lower strings (for example “bananas” is less than “oranges”);

Less Than Or Equal To

This operator is identical to Less Than except it returns information that is equal and less than.

In List

Enables you to pick from a list of choices;

Not In List

Not In List is the opposite of In List – Enables you to exclude from a list of choices;

Between

Between requires you to specify two parameters ; mostly used for date ranges

Not Between

Like Between, Not Between requires you to specify two parameters; it returns TRUE for fields that are not between your parameters.

Is NULL

Is NULL returns values that hold no data.    It is recommended to use Is NULL or Blank instead of Is NULL

Is Not NULL

Returns data that hold some data;

Is NULL or Blank

Is NULL or Blank returns TRUE for fields that either hold no data or do hold 'empty' data.

Is Not NULL or Blank

This operator returns TRUE for fields that hold some non-trivial data.

 

 

When to use what?

 



Knowledge Tags

This page was: Helpful | Not Helpful