Difference between revisions of "Alphabetic Operators"

From AgileApps Support Wiki
imported>Aeric
(Created page with ':{| border="1" cellpadding="5" cellspacing="0" !Operator !Description |- |<tt><nowiki>equals</nowiki></tt> | Returns only records with the specified value |- |<tt><nowiki>not equ…')
 
imported>Aeric
Line 8: Line 8:
|<tt><nowiki>not equal to</nowiki></tt>
|<tt><nowiki>not equal to</nowiki></tt>
| Returns only records that do not include the specified value
| Returns only records that do not include the specified value
|-
|-
|<tt>contains</tt>|| Returns only records that contain the specified value
|<tt>less than</tt>
| Returns only records that are less than the specified value
|-
|-
|<tt>not contains</tt>|| Returns only records that do not contain the specified value
|<tt>less than or equal to</tt>
| Returns only records that are less than or equal to the specified value
|-
|-
|<tt>starts with</tt> || Returns only records that start with the specified value
|<tt><nowiki>greater than</nowiki></tt>
| Returns only records that are more than the specified value
|-
|-
|<tt>does not start with</tt> || Returns records that do not start with the specified value
|<tt><nowiki>greater than or equal to</nowiki></tt>
| Returns only records that are more than or equal to the specified value
 
|-
|-
|<tt>ends with</tt> || Returns only records that end with the specified value
|<tt>contains</tt>|| Returns only records that contain the specified value
|-
|-
|<tt>less than</tt>
|<tt>does not contain</tt>|| Returns only records that do not contain the specified value
| Returns only records that are less than the specified value
|-
|-
|<tt><nowiki>greater than</nowiki></tt>
|<tt>starts with</tt> || Returns only records that start with the specified value
| Returns only records that are more than the specified value
<!--
|-
|-
|<tt>less than equals</tt>
|<tt>ends with</tt> || Returns only records that end with the specified value
| Returns only records that are less than or equal to the specified value
|-
|<tt><nowiki>greater than equals</nowiki></tt>
| Returns only records that are more than or equal to the specified value
-->
|}
|}

Revision as of 20:13, 10 June 2011

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 or equal to 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 or equal to Returns only records that are more than or equal to the specified value
contains Returns only records that contain the specified value
does not contain 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