Difference between revisions of "Advanced Search"
(→Searching Dates) |
(→Searching Dates) |
||
| Line 34: | Line 34: | ||
* '''On or After''' - returns records that have a date value in the selected field that either exactly matches or falls after the date entered in the Search Term field. | * '''On or After''' - returns records that have a date value in the selected field that either exactly matches or falls after the date entered in the Search Term field. | ||
* '''Is empty''' - returns records that have no value in the selected field. | * '''Is empty''' - returns records that have no value in the selected field. | ||
| + | * '''Last Year''' - returns records that have a date value in the selected field of the previous year from the current year. | ||
| + | * '''This Year''' - returns records that have a date value in the selected field of the current year. | ||
==See Also== | ==See Also== | ||
Revision as of 12:00, 1 May 2014
SmartSimple contains search functionality for records at all levels.
On any given search panel, click on the hyperlink for "Advanced Search" to toggle the Advanced Search panel (shown above). To toggle back to the basic search panel, click on the hyperlink for "Basic Search" shown at the top right of the Advanced Search panel.
Advanced Search enables quick and easy input of multiple search criteria including AND, OR and NOT operators.
Multiple criteria can be specified for searches, by clicking on the Add Criteria button at the bottom of the Advanced Search section. If searching for internal contacts in a list that includes:
- Adam Smith
- Bob Smith
- Cathy Jones, and
- David Williams
...the below set of search criteria will return a list of Adam Smith and Cathy Jones, but not Bob Smith.
Once selected, a set of criteria can be saved in the system as a filter, that can be re-applied later using the "Saved Filter" dropdown.
Note that, when searching for contacts and accounts, a checklist of roles and categories, respectively, will be displayed to further narrow down your search. When using Advanced Search on objects of Level 1, 2 or 3 within the Universal Tracking Application, Templates, Types and Statuses can be selected in the checklists.
Also, when searching against a Level 2 entity users will have the ability to search for the Level 2's based on Level 1 fields. In the screenshot below the options under the Grants heading relate to the Level 1 fields, whether those fields are common to all Level 2 types or are specific to a Level 2 Type.
Searching Dates
When using the Advanced Search to search a date field (both Standard or Custom fields) then the user is presented with a different series of search options to match against:
- On - returns records that have a date value in the selected field that matches exactly the date entered in the Search Term field.
- On or Before - returns records that have a date value in the selected field that either exactly matches or falls before the date entered in the Search Term field.
- On or After - returns records that have a date value in the selected field that either exactly matches or falls after the date entered in the Search Term field.
- Is empty - returns records that have no value in the selected field.
- Last Year - returns records that have a date value in the selected field of the previous year from the current year.
- This Year - returns records that have a date value in the selected field of the current year.
