Skip to main content

How to Refine Searches Using Search Operators 

  • Updated

This article includes: 

About Search Operators

With Onna you can search across all your data and metadata. Search operators help you refine your searches so results are more relevant.

Onna’s search feature offers a real-time syntax check to confirm that the syntax of your query is correct. As you type your search queries correct syntax is underlined in green, while incorrect syntax is underlined in red.

Search_Syntax.png

This article provides a list of the available search operators and some tips on how to get the best results when you use them.

 

Return to top of page

 

Onna Search Operators

When using operators, avoid using delimiters such as "-", "|", space, etc. in the search string because they tend to break them into different strings. For example, "2020-1234" may be interpreted as searching for "2020" and "1234".

To Search For

Use the Operator

Example

It’s Also Worth Knowing

An exact match of a term or phrase

""

"Alice visited Wonderland"

All documents containing the exact phrase Alice visited Wonderland

❗ Avoid using single quotes ' as a replacement for double quotes " to search for exact matches. They’re not interchangeable for our search engine.

Exclude results from search

NOT or -

stock AND purchase -payoff

All documents that contain stock and purchase but not payoff

❗ This search operator is case-sensitive

Terms together

AND or white space

stock AND purchase or stock purchase

Searches for all data that contains both terms stock and purchase. It won’t find data that only contains either stock or purchase.

📔 In boolean, a white space is a substitute forAND. Any search you make including AND will return the same results as if you used a white space


❗ This search operator is case-sensitive

Non-exclusive terms

OR

stock OR purchase

Searches for data that contains only stock, only purchase, or both.

❗ This search operator is case-sensitive

Variants (trailing wildcard)

*

bird*

Searches for data that contains variants that start with bird, such as birds, birding, or birdman
 

❗The wildcard search operator is only supported at the end of a query (trailing)

❗Wildcards cannot be nested in the search query

❗Only one wildcard can be used within a search query

❗It is suggested to use less than 10 characters before the asterisk.

Specific file extensions

type:

stock purchase type:pdf searches for all documents that contain stock and purchase that are PDFs.

stock purchase type:image searches for all documents that contain stock and purchase that are images, regardless of their extension. 

📔 Watch out for shortened extensions. jpg and jpeg aren’t considered the same

Data before a certain date

before:MM/DD/YYYY

stock purchase before:01/01/2019

Searches any data containing stock and purchase modified before that date in your source application

💚 Combine it with after: to search within a date range

❗`before` must be typed in all lower-case letters for this operator to work correctly.

Data after a certain date

after:MM/DD/YYYY

stock purchase after:01/01/2019

Searches any data containing stock and purchase modified after that date in your source application

💚 Combine it with before: to search within a date range

❗`after` must be typed in all lower-case letters for this operator to work correctly.

Terms near each other

near:

near:stock,3,purchase

Searches any data containing the terms stock and purchase at a maximum distance of 3 terms. It also returns results with a distance of 2 terms, 1 term, and no terms.

❗ near: is case sensitive. Using NEAR: won’t work.

Attachments

is:attachment

is:attachment stock purchase

Searches for attachments containing the terms stock and purchase.

 

Archived data

is:archived

is:archived stock purchase

Searches all data that has been deleted in your source application but has been archived by Onna and that contains the terms stock and purchase.

❗ This search operator only works if you’re syncing your data using the auto-sync and archive mode, which is only available for some applications.

Shared data

is:shared

is:shared stock purchase

Searches for data that is shared among users in your source application.

❗ This search operator only works with our Slack Enterprise, Box Enterprise, and Dropbox Business connectors.

Terms in titles or subjects

intitle:

intitle:stock

Searches for data that has the term stock in its title, filename (when a file doesn’t have a title), or subject line (for emails)

 

Visit the Search FAQ page to learn more about searching in Onna.


Return to top of page

Related articles