Difference between revisions of "Boolean"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
<tt>LOGICAL OPERATOR</tt>
====LOGICAL_OPERATOR====
:{|
:Logical operators can be used to build more complex expressions.
Logical operators provide the ability to include or exclude groups of records in [[Expressions]].  


The logical operators are:  
:The logical operators are:  
:<tt>&&</tt> Logical AND (and)
:: <tt>AND</tt>
:<tt>||</tt> Logical OR (or)
:: <tt>OR</tt>


;Considerations:
:;Considerations:
:* Logical expressions can be grouped using parentheses: <tt>()</tt>
::* Two subexpressions joined by a logical operator form a ''logical expression''.
:* Logical expressions resolve to a Boolean value: ''1/0'' or ''TRUE/FALSE''.
::* Logical expressions resolve to a Boolean value: ''1/0'' or ''TRUE/FALSE''.
|}
::* Use parentheses--<tt>()</tt>--to group expressions logically and to join multiple expressions.
::* Parentheses are used in pairs; each open parenthesis "(" requires a closing parenthesis ")".
::* For example:
:::  <tt>((<expression1> AND <expression2>) OR (<expression3> AND <expression_4>))</tt>
<!--
:::  <tt>((<expression1> && <expression2>) || (<expression3> && <expression_4>))</tt>  -->

Latest revision as of 00:43, 18 October 2011

LOGICAL_OPERATOR

Logical operators can be used to build more complex expressions.
The logical operators are:
AND
OR
Considerations
  • Two subexpressions joined by a logical operator form a logical expression.
  • Logical expressions resolve to a Boolean value: 1/0 or TRUE/FALSE.
  • Use parentheses--()--to group expressions logically and to join multiple expressions.
  • Parentheses are used in pairs; each open parenthesis "(" requires a closing parenthesis ")".
  • For example:
((<expression1> AND <expression2>) OR (<expression3> AND <expression_4>))