Find expressions

You locate specific records within a document using find expressions. A find expression is analogous to a WHERE clause in SQL: you could search for all records with a value of 'x' for a specific field. You can also use various operators to refine your search: you could search for all records where the value of field 'foo' is 'bar AND bazz' or 'bar NOT bazz'.

When you use a find expression to locate specific records in a document, Content Manager OnDemand returns a value of Yes or No based on the find expression for each record in the document. The first record that returns Yes is highlighted in the document window. You can use the Find Next and Find Previous commands to move directly to other records that match the find expression. (If you choose Find All, the records that return Yes are listed in the occurrence part of the viewing window. You can move directly to a record in the document by double-clicking the line number in the occurrence window.)

Field references in find expressions
A field reference instructs Content Manager OnDemand to use the value of a logical view field in the current record. For example, in the formula: invoiceAmt * 0.05, the name invoiceAmt is a reference to the value in the invoiceAmt logical view field. In one record, the find expression might calculate 48 * 0.05; in another, 10 * 0.05. The Fields list of the Expression Find window shows the logical view field names. When you create a find expression, double-click a field name to enter a field reference into the find expression. You can create logical view fields with the administrative client.
Constants
A constant is a value that is evaluated exactly as you type it -- the value does not change from one record to another. Constants can be numbers or text strings. Text strings must be enclosed in single quotation marks, like this:
  • 'Barbara Price'
  • 'ABC Company, Inc.'
  • '737 Hamblock Road, Barking, England'
Enter a constant in a find expression by typing the value in the Expression field.
Operators
Operators are symbols that act on an arithmetic, comparison, logical, or string expression. Enter an operator in a find expression by selecting it from the Operators list.