AgileApps Support Wiki Pre Release

Difference between revisions of "Field Values in Expressions"

From AgileApps 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>""</tt> or <tt>BLANK</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