Field Values in Expressions
From LongJump Support Wiki
Revision as of 20:07, 10 June 2011 by imported>Aeric (Created page with ";<tt>FIELD_VALUE</tt>:The search value; a value can be either a string, a date, a number :Follow these guidelines when specifying values: :*The value can be partial text or whol…")
- FIELD_VALUE
- The search value; a value can be either a string, a date, a number
- Follow these guidelines when specifying values:
- The value can be partial text or whole words
- Enclose strings and date/time values in 'single quotes'
- To specify date values, use the Date Format as specified in Company Information
- To search for a blank (empty) string, use two single quotes, with nothing between them ().
- To search for a blank (empty) field of other kinds, use a field value of BLANK
- To include multiple values for a field, separate each value using the pipe symbol (|)
- To include a single quote in the value, specify four single quotes (').
- For example, to search for the phrase, That's right! you would specify 'That's right!'.
- Examples:
- String: 'Paper 123'
- Date: '06/06/2007'
- Numeric Value: 9383
- Empty Field: "" or BLANK
- Examples: