COMPNOCASE String Function

NextGen® Enterprise EHR Template Editor Help, 8.3.1

OREQUAL Function

Use: Compares multiple fields or variables to a specified value to determine if any of their values are equal. This function uses OR logic where any value being compared may 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 ORNOTEQUAL function compares multiple fields or variables to a specified field or variable to determine if any are not equal. Syntax: {OREQUAL( «no case» , «compare_to» , «value1» , «value2»,,,, )} Arguments: «no case» 1 = case insensitive 0 = case sensitive«compare_to» Value to compare against other values«value1» Value to be compared You can type "PICK: to display the Picklist window for selecting a picklist to determine if any of its values is equal to the source value. «value2»,,,, (to «valuen») Each additional value to be compared Returns: 1 = Equal 0 = Not equal

NextGen® Enterprise EHR Template Editor Help, 8.3.1

FIND String Function

Use: Locates the first occurrence of a substring in a string, starting at a specified position from the beginning of the string. Syntax: {FIND( «string» , «string», «num»)} Arguments: First «string» Character string to be searchedSecond «string» String value to be found«num» Zero-based character position in first string from where to begin the search Returns: The zero-based character position of the first character of the substring, if found -Or- -1 if the substring is not found Example 1: Fields = txt_field1, txt_field2{template_name_.txt_field1} = NextGen Healthcare{template_name_.txt_field2} = care{FIND( {template_name_.txt_field1}, {template_name_.txt_field2}, 0)} -Or-{FIND( {template_name_.txt_field1}, care, 0)} Result: 14 Example 2: Fields = txt_field1, txt_field2{template_name_.txt_field1} = NextGen Healthcare{template_name_.txt_field2} = Inc{FIND( {template_name_.txt_field1}, {template_name_.txt_field2}, 0)} -Or-{FIND( {template_name_.txt_field1}, Inc, 0)}Result: -1 Parent topi

NextGen® Enterprise EHR Template Editor Help 8

COMPNOCASE String Function

Use: Performs a case-insensitive comparison of two strings to see if they match. For example, in a case-insensitive comparison, abc is the same as ABC or aBc. Note: The EQUAL function compares multiple fields or variables to another field or variable. The comparison can be case sensitive or insensitive. Syntax: {COMPNOCASE( «string» , «string» )} Arguments: First «string» First character string to compareSecond «string» Second character string to compare Returns: 1 = Match 0 = No match Example 1: Fields = txt_field1, txt_field2{template_name_.txt_field1} = NextGen{template_name_.txt_field2} = nextgen{COMPNOCASE( {template_name_.txt_field1}, {template_name_.txt_field2} )} Or {COMPNOCASE( {template_name_.txt_field1}, nextgen} )}Result: 1 Example 2: Fields = txt_field1, txt_field2{template_name_.txt_field1} = Health Care{template_name_.txt_field2} = health{COMPNOCASE( {template_name_.txt_field1}, {template_name_.txt_field2} )} Or{COMPNOCASE( Health Care, {template_name_.txt_field2} )}Resu

NextGen® Enterprise EHR Template Editor Help, 8.3.1

MAX Database Function

Use: Displays the maximum value of a numeric field for the currently selected practice and patient. You can use this function with the following template types: Medical Records, Medical Records Popup, Medical Records Extended Popup, Demographics Extended Popup. Syntax: {MAX( «field» )} Arguments: «field» table_name.field_name (no braces) Returns: The maximum numeric value Example 1: Field = medical_record_template_.txt_mrt_numeric_field Five encounters (5, 45, 32, 121, 99){MAX( medical_record_template_.txt_mrt_numeric_field )} Result: 121 Example 2: Field = medical_record_popup_.txt_mrpu_numeric_fieldThree encounters (13, 84, 62){MAX( medical_record_popup_.txt_mrpu_numeric_field )} Result: 84 Example 3: Field = medical_record_ext_popup_.txt_mrepu_numeric_field Two encounters, three records per encounter(324, 356, 213, 278, 410, 156){MAX( medical_record_ext_popup_.txt_mrepu_numeric_field )} Result: 410 Example 4: Field = demographic_ext_popup_.txt_depu_numeric_field One encounter, four

NextGen® Enterprise EHR Template Editor Help 8

EQUAL Function

Use: Compares multiple fields or variables to a specified value to determine if all of their values are equal. This function uses AND logic where each value being compared must 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 COMPNOCASE function performs a case-insensitive comparison of two strings. The NOTEQUAL function compares multiple fields or variables to a specified field or variable to determine if they are not equal. Syntax: {EQUAL( «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 «value2»,,,, (to «valuen») Each additional field to be compared Returns: 1 = Equal 0 = Not equal Example 1: Case insensitiveFields: txt_field = Testtxt_other_fiel

NextGen® Enterprise EHR Template Editor Help, 8.3.1

EQUAL Function

Use: Compares multiple fields or variables to a specified value to determine if all of their values are equal. This function uses AND logic where each value being compared must 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 COMPNOCASE function performs a case-insensitive comparison of two strings. The NOTEQUAL function compares multiple fields or variables to a specified field or variable to determine if they are not equal. Syntax: {EQUAL( «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 «value2»,,,, (to «valuen») Each additional field to be compared Returns: 1 = Equal 0 = Not equal Example 1: Case insensitiveFields: txt_field = Testtxt_other_fiel

Use:	Performs a case-insensitive comparison of two strings to see if they match. For example, in a case-insensitive comparison, abc is the same as ABC or aBc. Note: The EQUAL function compares multiple fields or variables to another field or variable. The comparison can be case sensitive or insensitive.
Syntax:	`{COMPNOCASE( «string» , «string» )}`
Arguments:	`First «string» First character string to compare Second «string» Second character string to compare`
Returns:	1 = Match 0 = No match
Example 1:	`Fields = txt_field1, txt_field2 {template_name_.txt_field1} = NextGen {template_name_.txt_field2} = nextgen {COMPNOCASE( {template_name_.txt_field1}, {template_name_.txt_field2} )}` Or `{COMPNOCASE( {template_name_.txt_field1}, nextgen} )} Result: 1`
Example 2:	`Fields = txt_field1, txt_field2 {template_name_.txt_field1} = Health Care {template_name_.txt_field2} = health {COMPNOCASE( {template_name_.txt_field1}, {template_name_.txt_field2} )}` Or `{COMPNOCASE( Health Care, {template_name_.txt_field2} )} Result: 0`

COMPNOCASE String Function

Recommendations

OREQUAL Function

FIND String Function

COMPNOCASE String Function

MAX Database Function

EQUAL Function

EQUAL Function

COMPNOCASE String Function

OREQUAL Function

FIND String Function

COMPNOCASE String Function

MAX Database Function

EQUAL Function

EQUAL Function