|
Filter condition extension |
At first sight the means of creating filter condition allows creating only a simple condition, which consists of comparison of the user-introduced field values. But there can appear situations, when you need to create complicated filters or join conditions with field comparison and bracket application. For this purpose there is a complex element at the end of condition area. This is a list of separate conditions, braced between the left and right areas for logical operators and brackets.
If you need to join or compare two fields, then:
Choose “no” as an operation of comparison;
Indicate comparison ("=" or "<>" or "<= ...) in the field for right operators and brackets;
Insert the second field compared as the next string and also select “no” operation of comparison for it, too.