Difference between revisions of "Field Values in Expressions"

Revision as of 00:51, 18 October 2011

The search value - a string, a date, a number.

Follow these guidelines when specifying values:

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

@@ Line 4: / Line 4: @@
 :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 (<tt><nowiki>''</nowiki></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 search for multiple field values, separate each value using vertical pipe (|)
 ::For example: <tt>company_name='Acme|Ajax'</tt>
+::(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 (<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>.