You have access to all public, and your own private data from the Excel Add-in, this document shows you how to find the data you need.
Search terms (the words you type) are used to find words within the id, name and description of an object.
Combining search terms
The more words you type, the fewer items will be found as the search terms are combined so that all the words need to be present.
For example, searching for
europe will find more items than searching for
europe potato as it only finds objects with both the words europe and potato.
Advanced searching using operators
You can utilise some operators in the search box to fine-tune the way that searching works.
Search for X or Y, this will return results related to X or Y or both using the pipe (|) operator.
europe | potato
Will search id, name and description for any of the words europe, potato
Search for X -Y, this will return results related to X but not Y using the subtract (-) operator.
Will search id, name and description for objects with the word europe but not the word potato in it.
You can group multiple terms or search operators to control how the search is executed
(europe | usa) potato
Will search id, name and description for objects with the word europe or usa and the word potato in it.
Search for words within tags using the # symbol
Will search the tags collection for the word wheat
Will search id, name and description for the word europe and the tags collection for the word wheat
You can force the search engine to use a specific field to search for a term using the colon (:) operator.
Will search the location field for objects with the word belgium in it.