Difference between revisions of "Field Values in Expressions"
From LongJump Support Wiki
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…") |
imported>Aeric |
||
| Line 4: | Line 4: | ||
:*Enclose strings and date/time values in 'single quotes' | :*Enclose strings and date/time values in 'single quotes' | ||
:*To specify date values, use the [[Date Format]] as specified in [[Company Information]] | :*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 (<tt>''</tt>). | :*To search for a blank (empty) string, use two single quotes, with nothing between them (<tt><nowiki>''</nowiki></tt>). | ||
:*To search for a blank (empty) field of other kinds, use a field value of <tt>BLANK</tt> | :*To search for a blank (empty) field of other kinds, use a field value of <tt>BLANK</tt> | ||
:*To include multiple values for a field, separate each value using the pipe symbol (|) | :*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 (<tt>''''</tt>). | :*To include a single quote in the value, specify four single quotes (<tt><nowiki>''''</nowiki></tt>). | ||
::For example, to search for the phrase, </tt>That's right!</tt> you would specify </tt>'That''''s right!'</tt>. | ::For example, to search for the phrase, </tt>That's right!</tt> you would specify </tt><nowiki>'That''''s right!'</nowiki></tt>. | ||
::Examples: | ::Examples: | ||
| Line 14: | Line 14: | ||
:::Date: <tt>'06/06/2007'</tt> | :::Date: <tt>'06/06/2007'</tt> | ||
:::Numeric Value: <tt>9383</tt> | :::Numeric Value: <tt>9383</tt> | ||
:::Empty Field: <tt> | :::Empty Field: <tt><nowiki>''</nowiki></tt> or <tt>BLANK</tt> | ||
Revision as of 20:08, 10 June 2011
- 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: