SmartView 2018
Advanced Quick Find Features
The Quick find search function can also be used for much more complex search functions.
| 1. | Enter multiple words into the search field to search for all of those words across all columns of data. For example, in the sample database if you enter Aaron Park, it will return Aaron Fitz Electrical as well as Adam Park Resort, or if you enter Aaron Chicago, SmartView External will return all customers in Chicago and all those with the word Aaron in its name. |
| 2. | Enter a phrase in quotations for SmartView External to search for just that phrase and not the individual words contained in the phrase |
| 3. | Enter a minus sign to exclude terms from a search. For example, in the sample database, if you enter Electrical -American, you will just get Aaron Fitz Electrical and not American Electrical Contractor. |
| 4. | Enter a plus sign to only show records that have that search term. For example, in the sample database, if you enter Redmond +Resort, you will just get Kensington Gardens Resort, and not all companies in the city of Redmond. |
| 5. | Search individual columns by putting the name of the column before the search term and separated by a colon. For example, in the sample database, "Customer Name":red will return just Red's Food Market and no customers from Redmond. Note, when you have a space in the column name, you must enclose it in quotes. You can also combine this with the minus operator to filter all values with that search term. For example, in the sample database, -"Customer Name":red will return everyone but Red's Food Market) |