You are here: All Help Topics > Accounting and Assurance > Calculations, Functions and Linkages > | Operator

Or Operator

Used to combine two filter commands. Either condition must be true in order for the expression to be true.

Syntax

condition1|condition2

DATABASE -> FIELD OPERATOR VALUE | DATABASE -> FIELD OPERATOR VALUE

Example 1

GL->JE_DESC="VISA"|GL->JE_DESC="AMERICAN EXPRESS"

Filters all Journal entries with a journal description that is either "AMERICAN EXPRESS" or "VISA".

Tip: The journal description must match these descriptions in the filter exactly or the filter will not select them. In order to Find journal entries where "VISA" or "AMERICAN EXPRESS" was only part of the journal description, use other functions such as IN or SCANSTR to filter instead. To deal with issues of case difference, the description in the journal might be in lower case or a mix of upper and lower case, use the function UPPER ,or LOWER . More than one function can be used in a filter at a time. Functions can be nested in the filter to define the criteria. For using dates in a filter, see Date Fields for more information.

Operator	Description	Syntax	Example
<	Less than	value 1<value2	C1<C2 Condition is true if cell 1 is less than cell 2.
<=	Less than or equal to	value 1<= value2	C1<=C2 Condition is true if cell 1 is less than or equal to cell 2.
>	Greater than	value 1 >value2	C1>C2 Condition is true if cell 1 is greater than cell 2.
>=	Greater than or equal to	value1>=value2	C1>= C2 Condition is true if cell 1 is greater than or equal to cell 2.
=	Equal to	value1=value2	C1=C2 Condition is true if cell 1 is qual to cell 2.
<>	Not equal to	value1<>value2	C1<>C2 Condition is true if cell 1 idoes not equal cell2.

Filter Type	Database
Financial Statement	AM Database
Journal or Ledger	GL Database

Or Operator

Database

Field

Comparison Operators

Value