Raw Query

M

mdrusso

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

When designing an advanced search of items, I see a "Raw Query" option. How is it used?
 
W

William Smith

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

When designing an advanced search of items, I see a "Raw Query" option. How is it used?

Raw Query items are essentially the "real names" of the items you'd see
in the drop-down menus when searching in Entourage. For example:

com_microsoft_entourage_ccEmailAddresses = Addresses in the CC field
com_microsoft_entourage_categories = Categories assigned to an item
com_microsoft_entourage_firstName = First name in a contact record

Most, but not all, of the available query options are available in the
dropdown menus when creating an advanced search.

The beauty of using raw queries with Entourage is not really found until
you're using them *outside* of Entourage. Application developers will
use them for their hooks for pulling out Entourage data but regular
users can use them too for creating Finder Smart Folders.

Assume you want to create a Finder Smart Folder for all messages sent
"the past week" from your boss:

1. In the Finder you can select File --> New Smart Folder.
2. You want to Search your "home folder".
3. Add a row to extend your search.
4. Select "Raw Query" from the dropdown menu.
5. Enter the following string on one line:

com_microsoft_entourage_author_email_addresses = "(e-mail address removed)"

6. Add: "Created date is within last 7 days"

So, how do you find all these real names? Spoglight is using the cache
files found in your home folder:

~/Library/Caches/Metadata/Microsoft/Entourage/2008/Main Identity...

All of the files are the same whether they are messages, events,
contacts, etc. Open the Terminal application found in
/Applications/Utilities and enter "mdls " with a space at the end. Drag
any of the files (not folders) into the Terminal window to fill in the
path to the sample file and hit the return key. You'll see a list of
options.

For operators that can be used have a look at Apple's website here

"Query Expression Syntax"
<http://developer.apple.com/documentation/Carbon/Conceptual/SpotlightQuery/Concepts/QueryFormat.html>

Hope this helps!

--

bill

William M. Smith, Microsoft Interop MVP - Mac/Windows
Entourage Help Page <http://entourage.mvps.org/>
Entourage Help Blog <http://blog.entourage.mvps.org/>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top