AgileApps Support Wiki Pre Release

Difference between revisions of "Field Values in Expressions"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 20: Line 20:


:*To include a single quote in the value you're searching for, specify four single quotes (<tt><nowiki>''''</nowiki></tt>).  
:*To include a single quote in the value you're searching for, specify four single quotes (<tt><nowiki>''''</nowiki></tt>).  
::For example, to search for the phrase, <tt>That's right!</tt> you would specify <tt><nowiki>'That''''s right!'</nowiki></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:

Revision as of 00:51, 18 October 2011

FIELD_VALUE

The search value - 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 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 search for multiple field values, separate each value using vertical pipe (|)
For example: company_name='Acme|Ajax'
(The criteria is satisfied when the company name is either Acme or Ajax)
  • To search for a field value that happens to contain a vertical pipe (|), you need to "escape" the pipe so it is recognized as a literal character in the field. To do that, ...
  • To include a single quote in the value you're searching for, 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