Expression Find window

Use to locate specific records in line data documents. An expression is a combination of Operator, Operand, and Function that yields a single result. Content Manager OnDemand find expressions support arithmetic calculations, comparisons, logical evaluations, and string manipulation. See Find expressions for more information. Find expressions support the use of functions that return special information from the system about fields, data, dates, and so forth. See Functions for an explanation of the functions supported by Content Manager OnDemand. See Searching for documents with Find for help with creating a find expression.

You can use more than one comparison in a single find expression. This is called nesting comparisons. You can nest as many comparisons as you like in a find expression (up to 32764 characters). Nested comparisons evaluate from the inside out. You must use parentheses where appropriate to achieve the result that you want.

Wildcard (Expression Find) characters can be included in the comparison values of a find expression when the search involves a character string.

Available options include:

Fields: The logical view fields defined for the document. You can define logical view fields with the administrative client.
Operators: The calculation and evaluation symbols that can be used in find expressions.
Functions: The Content Manager OnDemand functions that can be used in find expressions.
Data Formats: The date formats that can be used in find expressions. The list contains the standard date formats provided with Content Manager OnDemand and user-defined date formats. Use the Update command to add and delete date formats.
Selection: Information about the selected item (Fields, Operators, Functions, Date Formats). To include the selected item in the find expression, click Insert.
Expression: The find expression. You can insert items into a find expression by selecting an item (Fields, Operators, Functions, Date Formats), and clicking Insert. You can change the find expression by typing in the Expression field. You can recall a find expression from the Expression list.

Available commands include:

Find: Locate the next record that matches the find expression.
Find All: Locate all records that match the find expression.
Cancel: Close the Expression Find window.
Help: Display help for the Expression Find window.
Update: Add date formats to or remove date formats from the Date Formats list.
Insert: Insert the item (Fields, Operators, Functions, Date Formats) into the Expression field at the insertion point.
Delete: Remove the find expression from the Expression list.
<<<<<: Decrease the size of the Expression field.
>>>>>: Increase the size of the Expression field.

You can access the Expression Find command from the Search menu or from the toolbar by clicking the Expression Find toolbar button. (If the Expression Find toolbar button does not appear on the toolbar, select Customize Toolbar from the Options menu to add it.)