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
 
(One intermediate revision by the same user not shown)
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>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>does not start with</tt> || Returns records that do not start with the specified value
|-
|<tt>ends with</tt> || Returns only records that end with the specified value
|-
|-
|<tt>less than</tt>
|<tt>less than</tt>
| Returns only records that are less than the specified value
| Returns only records that are less than the specified value
|-
|<tt>less than equals</tt>
| Returns only records that are less than or equal to the specified value
|-
|-
|<tt><nowiki>greater than</nowiki></tt>
|<tt><nowiki>greater than</nowiki></tt>
| Returns only records that are more than the specified value
| Returns only records that are more than the specified value
<!--
|-
|<tt>less than equals</tt>
| Returns only records that are less than or equal to the specified value
|-
|-
|<tt><nowiki>greater than equals</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
-->
 
|-
|<tt>contains</tt>|| Returns only records that 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>ends with</tt> || Returns only records that end 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