Difference between revisions of "Filter Expression Builder"
imported>Aeric |
imported>Aeric |
||
Line 6: | Line 6: | ||
# Specify a value to compare to | # Specify a value to compare to | ||
# Add or remove comparisons, as needed. | # 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]] | :[[File:filterexpression_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.