Technology Tips and Tools #11
Did you know?
The best way to narrow down my searches!
Basic Search Tips
When you search in Google Apps Vault, you can include search operators in the Terms field to narrow or broaden your search. Vault supports multiple operators, including:
- Boolean operators (AND, OR, and NOT)
- Gmail operators, such as to, cc, and bcc
- Drive operators, such as type: and owner:
the wildcard operator (*). Use an asterisk at the end of a search term as a placeholder for unknown or wildcard terms. The wildcard operator is only supported at the end of a search term. For example, invit* returns both invitation and invite.
Note: If your wildcard entry results in a phrase that exceeds 100 words, the search will fail. Refine your search to make it more specific.
- quotes to specify an exact phrase, such as "top secret widget".
- the hyphen (‑) to exclude whatever follows the hyphen. For example:
- Use apples ‑bananas to retrieve messages that mention apples, but not messages that include both apples and bananas.
- Use -is:trashed to exclude files from Google Drive that are in the trash.
Note: Search operator conventions
When you use search operators, keep the following in mind:
- Vault assumes there is an AND operator between search terms if no Boolean operator is specified.
- If you use a Gmail search operator, make sure you include a colon (:) immediately after the operator. Also make sure there are no spaces between the operator and the value—for example, to:username1
- When entering multiple values for the same operator, group them together in parentheses—for example, to:(username1 OR username2)
- Enter dates using the format YYYY-MM-DD
Filter data in a desktop database
To apply a filter, right-click the field or control that you want to use for filtering, and then choose a filtering command in the lower half of the menu that pops up. To use a particular value as the basis for your filter, select the value, right-click it, and then choose a filtering command. The filtering options depend on the data type of the field that you use. Here’s what the filtering options look like for a text field with the value hello world selected:
You can use filters to display specific records in a form, report, query, or datasheet, or to print only certain records from a report, table, or query. By applying a filter, you are able to limit the data in a view without altering the design of the underlying object.