| Use: | Compares multiple fields or variables to a specified value to determine if any of their values are not equal. This function uses OR logic where any value being compared may not equal the source value in order to return an equal value for the group. You can compare values with or without regard to case (case sensitive or case insensitive). For example, in a case-insensitive comparison, abc is the same as ABC or aBc.
Note: The OREQUAL function compares multiple fields or variables to a specified field or variable to determine if any are equal.
|
| Syntax: | {ORNOTEQUAL( «no case» , «compare_to» , «value1» , «value2»,,,, )}
|
| Arguments: |
«no case»
1 = case insensitive
0 = case sensitive
«compare_to»
Field to compare other values to
«value1»
Field to be compared
You can type "PICK: to display the Picklist window for selecting a picklist to determine if any of its values is not equal to the source value.
«value2»,,,, (to «valuen»)
Each additional field to be compared
|
| Returns: | 1 = Not equal 0 = Equal |
| Example 1: |
Case insensitive
Fields:
txt_field = Test
txt_other_field1 = test
txt_other_field2 = Tests
{ORNOTEQUAL( 1 , {template_name_.txt_field} , {template_name_.txt_other_field1} , {template_name_.txt_other_field2} )}
Result: 1 |
| Example 2: |
Case insensitive
Fields:
txt_field = Test
txt_other_field1 = Test
txt_other_field2 = test
{ORNOTEQUAL( 1 , {template_name_.txt_field} , {template_name_.txt_other_field1} , {template_name_.txt_other_field2} )}
Result: 0 |
| Example 3 |
Case sensitive
Fields:
txt_field = Test
txt_other_field1 = Test
txt_other_field2 = test
{ORNOTEQUAL( 0 , {template_name_.txt_field} , {template_name_.txt_other_field1} , {template_name_.txt_other_field2} )}
Result: 1 |
| Example 4 |
Case sensitive
Field: condition_field = Cardiomyopathy
Picklist: Holter_Indications = Palpitations, Syncope, Near Syncope, A-Fib, A-Flutter, Arrhythmia, Tachycardia, Bradycardia, Cardiomyopathy
{ORNOTEQUAL( 0 , {condition_field} , "Pick: Holter Indications" )}
Result: 1 |
