Difference between revisions of "Filter Expression Builder"
imported>Aeric (Created page with "'''''In progress...'''''") |
imported>Aeric |
||
(29 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
''''' | The interactive builder makes it easy to build up a [[Filter Expression]] of medium complexity, one line at a time--where each line compares the value of a field to some value. When the [[Lookup]] field display type points to [[Users]], a special value of '''$userid''' is applicable only for Lookup field display type. '''$userid''' dynamically parses to the logged in user ID. The '''$userid''' cannot not be used with any other field display type. | ||
<noinclude>__TOC__</noinclude> | |||
====Creating a Filter Expression==== | |||
To create a filter expression: | |||
# Select an object field and a comparison operator | |||
# Specify a value to compare to | |||
# Add or remove comparisons, as needed. | |||
{{Note|The multi-value lookup field is not supported in filtering of records in Reports.}} | |||
:[[File:filterexpression_ljp11334.png|600px]] | |||
====Specifying Values==== | |||
Comparison values are most often specified as numbers and strings, as in the example above. | |||
:* Number - a collection of digits: <tt>91410</tt> | |||
:* String - a sequence of alphanumeric characters in quotes: <tt>'This is a string'</tt> | |||
It is also possible to specify values for other kinds of fields. | |||
:Learn more:'' | |||
::* [[Filter Expressions#FIELD_VALUE]] | |||
::* [[Field Display Types]] | |||
====Using the Advanced Options==== | |||
Clicking '''Advanced Options''' lets you put parentheses around expression elements, and choose the logical operatores <tt>AND</tt> and <tt>OR</tt> to determine how the elements are combined. | |||
:[[File:filterexpressionadvanced_ljp11334.png|600px]] |
Latest revision as of 10:40, 21 May 2020
The interactive builder makes it easy to build up a Filter Expression of medium complexity, one line at a time--where each line compares the value of a field to some value. When the Lookup field display type points to Users, a special value of $userid is applicable only for Lookup field display type. $userid dynamically parses to the logged in user ID. The $userid cannot not be used with any other field display type.
Creating a Filter Expression
To create a filter expression:
- Select an object field and a comparison operator
- Specify a value to compare to
- Add or remove comparisons, as needed.
Specifying Values
Comparison values are most often specified as numbers and strings, as in the example above.
- Number - a collection of digits: 91410
- String - a sequence of alphanumeric characters in quotes: 'This is a string'
It is also possible to specify values for other kinds of fields.
- Learn more:
Using the Advanced Options
Clicking Advanced Options lets you put parentheses around expression elements, and choose the logical operatores AND and OR to determine how the elements are combined.