1
Download Unify DataServer/ELS Reference
Transcript
You can specify ranges of characters by separating two characters with a dash (-). For example, you can specify all upper case letters by the class: [ABCDEFGHIJKLMNOPQRSTUVWXYZ] or more conveniently, by [A-Z]. You can specify all upper and lower case letters by [azA-Z]. You can specify other classes similarly. Inexact matching on non-string fields You can also specify inexact matches on non-string fields with the following set of expressions. The values you supply are f1 and f2. > f1 The greater than expression. All fields with values greater than the entered value match the expression. <f1 The less than expression. All fields with values less than the entered value match the expression. !f1 The logical not expression. All fields that do not match the entered value match the expression. f1-f2 The range expression. All field values that match the entered values, or are between the entered values, match the expression. This is equivalent to >= f1 AND <=f2. !f1-f2 This expression matches all field values that are outside the range of entered values. This is equivalent to <f1 OR>f2. You can specify search expressions for any number of fields on the screen form. The search expression must begin in the first character position of the screen field. The result is to AND all the expressions together to produce a query. 342 Unify DataServer/ELS Developer’s Reference
