Difference between revisions of "Alphabetic Operators"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
 
Line 13: Line 13:
| Returns only records that are less than the specified value
| Returns only records that are less than the specified value
|-
|-
|<tt>less than or equal to</tt>
|<tt>less than equals</tt>
| Returns only records that are less than or equal to the specified value
| Returns only records that are less than or equal to the specified value
|-
|-
Line 19: Line 19:
| Returns only records that are more than the specified value
| Returns only records that are more than the specified value
|-
|-
|<tt><nowiki>greater than or equal to</nowiki></tt>
|<tt><nowiki>greater than equals</nowiki></tt>
| Returns only records that are more than or equal to the specified value
| Returns only records that are more than or equal to the specified value


Line 25: Line 25:
|<tt>contains</tt>|| Returns only records that contain the specified value
|<tt>contains</tt>|| Returns only records that contain the specified value
|-
|-
|<tt>does not contain</tt>|| Returns only records that do not contain the specified value
|<tt>not contains</tt>|| Returns only records that do not contain the specified value
|-
|-
|<tt>starts with</tt> || Returns only records that start with the specified value
|<tt>starts with</tt> || Returns only records that start with the specified value

Latest revision as of 23:19, 7 February 2012

Operator Description
equals Returns only records with the specified value
not equal to Returns only records that do not include the specified value
less than Returns only records that are less than the specified value
less than equals Returns only records that are less than or equal to the specified value
greater than Returns only records that are more than the specified value
greater than equals Returns only records that are more than or equal to the specified value
contains Returns only records that contain the specified value
not contains Returns only records that do not contain the specified value
starts with Returns only records that start with the specified value
ends with Returns only records that end with the specified value