Boolean operators allow conditional search results
Construct complex searches using Boolean AND, OR, and NOT operators in global text searches.
You can use Boolean operators in all global text search interfaces:
- Global text search field
- Knowledge Base search
- List search for text
Note: Boolean operators are case-sensitive. As an example, the system recognizes OR as a Boolean operator, but treats Or and or as regular search terms.
| Operator | Description |
|---|---|
| OR or vertical bar symbol \(\|\) | Finds a match if any of the search terms exist in a document (a union of sets). For example, to find documents that contain either Image omitted: search_with_lists.png Searching with the filter choice lists.</p> Note: By design, you can only have one Keywords filter condition per condition set. If you select the Keywords field in a filter choice list, the OR button for that filter condition becomes unavailable. Similarly, if you construct an OR filter condition, the Keywords field becomes unavailable in the filter choice lists. |
| AND | Finds a match if all search terms exist in a document (an intersection of sets). For example, to find documents that contain both "CPU load" and "10 minutes", search for Note: For Knowledge Base searches, if the default AND search returns poor results, the search is automatically re-run with the OR operator. Administrators can configure the knowledge base search to always use OR by modifying the glide.knowman.search.operator system property. |
| NOT, minus \(-\), or exclamation point \(!\) | Excludes documents that contain the search term after the NOT operator \(a difference of sets\). For example, to find documents that contain "CPU load" but not "10 minutes", you can search for `"CPU load" NOT "10 minutes"` or `"CPU load" -"10 minutes"` or `"CPU load" !"10 minutes"`. NOT must be a stand-alone term in your search. For example, `atom NOT ion` excludes the term `ion`, but `NOTION` searches for the term `notion`. The minus and exclamation point symbols must immediately precede the search term that you want to exclude. For example, a search for `email !Joe` excludes `Joe` but a search for `email ! Joe` includes `Joe`. You can't use the NOT operator to exclude all terms in your search. For example, the following search returns no results: `NOT "10 minutes"`. |
Parent Topic:Available search options
Related topics
List search finds records from the current table
Quotation marks allow exact phrase searches
Wildcard characters allow searching for patterns and variations