- Contents
- Index
- Search
Display results with all search words
Search Features
Special Search Features for Text Criteria fields
These search features are available in the View forms and Enhanced Workflow Filter fields. Search strings are not case sensitive.
: - Enter a range of values using a colon.
Notes:
- The Code field in CRM is an alphanumeric field. Therefore if you perform a search based on the Code field and select a range of values, you can also retrieve other Codes (depending on the values in your database).
- The range search feature cannot be used together with other wildcards.
- Use:value to search for all entries up to this value (less than)
- Use value - to search for all entries from this value onwards (greater than)
For example a:d will match apple, banana, and kumquat but not fig, c: will match kumquat and fig, and:c will match apple and banana.
, or / or \ - Enter multiple values, separated by a comma or forward slash or backward slash. All records that meet one of the values entered will be retrieved. (Behaves the same way as the or operator).
+ or <space> - Enter multiple values, separated by a + or a space. Only records that meet all the values entered will be retrieved (Behaves the same way as the and operator).
Notes:
- If a combination of and and or wildcards are used, then the AND wildcards are processed before the OR wildcards.
- Each entry in the list of multiple/AND entries can contain range and wildcard searches
? - To represent a single character, for example: ?at = cat, mat and pat.
* - To represent multiple characters, for example *son = Wilson, Johnson and Benson. A contains search is possible using *man* to match aquaman, mantra, and Emmanuelle.
NOT or not - Prefix the criteria with not to retrieve all records that do not meet the value entered.
Any text that you enter as a criteria or filter should be enclosed in double quotes if the text contains a space or any other character such as slash or plus.
Special Search Features for Number Criteria fields.
These search features are available in the View forms.
: - Enter a range of numbers using a colon.
, or / or \ - Enter multiple values, separated by a comma or forward slash or backward slash. All records that meet one of the values entered, will be retrieved.
Special Search Features for Date Criteria fields.
These search features are available in the View forms.
: - Enter a range of dates using a colon.
, - Enter multiple dates, separated by a comma. All records that meet one of the dates entered will be retrieved. (Behaves the same way as the or operator).
TODAY - This is a reserved word that you can use to search for the current date. This is most useful in saved criteria.
Notes:
- An offset from may also be provided using the + or ?? characters. For example: TODAY-7 is seven days ago.
- This can also be used in a range search. For example TODAY-7:TODAY+7 returns dates that are later than seven days ago and earlier than seven days from now.
Dates can be entered in these formats:
- 9 August 18
- 9 August 2018
- 09/08/18
- 09/08/2018
Your internationalisation settings may be different. Define the date convention for your locale by using the Date form of the Regional Settings Properties dialog, accessed from the Regional Settings icon in the Control Panel.