Skip to content

Instantly share code, notes, and snippets.

@EmilVarona
Created April 13, 2017 01:28
Show Gist options
  • Star 25 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save EmilVarona/78ae2aff409922686ebff4cea785aed4 to your computer and use it in GitHub Desktop.
Save EmilVarona/78ae2aff409922686ebff4cea785aed4 to your computer and use it in GitHub Desktop.
Outlook/Mac 2015 raw query item names
<?xml version="1.0" encoding="UTF-8"?>
<schema version="1.0" xmlns="http://www.apple.com/metadata" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.apple.com/metadata file:///System/Library/Frameworks/CoreServices.framework/Frameworks/Metadata.framework/Resources/MetadataSchema.xsd">
<!--
Compiled from /Applications/Microsoft\ Outlook.app/Contents/Library/Spotlight/Microsoft\ Outlook\ Spotlight\ Importer.mdimporter/Contents/Resources/schema.xml
with info from http://xensoft.com/search-mac-outlook-2011-mail-with-raw-queries/
-->
<types>
<type name="com.microsoft.outlook15.contact">
<allattrs>
kMDItemTitle
kMDItemPhoneNumbers
kMDItemEmailAddresses
kMDItemInstantMessageAddresses
kMDItemContentModificationDate
com_microsoft_outlook_recordID
com_microsoft_outlook_folderID
com_microsoft_outlook_accountID
kMDItemCity
kMDItemStateOrProvince
kMDItemCountry
com_microsoft_outlook_flag
com_microsoft_outlook_nickname
com_microsoft_outlook_company
com_microsoft_outlook_department
com_microsoft_outlook_jobTitle
com_microsoft_outlook_homeURL
com_microsoft_outlook_workURL
com_microsoft_outlook_bloodType
com_microsoft_outlook_spouse
com_microsoft_outlook_customFld1
com_microsoft_outlook_customFld2
com_microsoft_outlook_customFld3
com_microsoft_outlook_customFld4
com_microsoft_outlook_customFld5
com_microsoft_outlook_customFld6
com_microsoft_outlook_customFld7
com_microsoft_outlook_customFld8
com_microsoft_outlook_homeStreet
com_microsoft_outlook_homeCity
com_microsoft_outlook_homeState
com_microsoft_outlook_homeZip
com_microsoft_outlook_homeCountry
com_microsoft_outlook_firstName
com_microsoft_outlook_lastName
com_microsoft_outlook_suffix
com_microsoft_outlook_title
com_microsoft_outlook_notes
com_microsoft_outlook_workStreet
com_microsoft_outlook_workCity
com_microsoft_outlook_workState
com_microsoft_outlook_workZip
com_microsoft_outlook_workCountry
com_microsoft_outlook_otherStreet
com_microsoft_outlook_otherCity
com_microsoft_outlook_otherState
com_microsoft_outlook_otherZip
com_microsoft_outlook_otherCountry
com_microsoft_outlook_interests
com_microsoft_outlook_japanese
com_microsoft_outlook_birthday
com_microsoft_outlook_anniversary
com_microsoft_outlook_customDate1
com_microsoft_outlook_customDate2
com_microsoft_outlook_children
com_microsoft_outlook_furigana_full_name
com_microsoft_outlook_firstNameFurigana
com_microsoft_outlook_lastNameFurigana
com_microsoft_outlook_companyFurigana
com_microsoft_outlook_spouseFurigana
com_microsoft_outlook_childrenFurigana
com_microsoft_outlook_interests
com_microsoft_outlook_projects
com_microsoft_outlook_categories
com_microsoft_outlook_primaryCategory
com_microsoft_outlook_flagged
com_microsoft_outlook_isgroup
com_microsoft_outlook_hasStartDate
com_microsoft_outlook_startDate
com_microsoft_outlook_hasDueDate
kMDItemDueDate
com_microsoft_outlook_has_reminder
com_microsoft_outlook_completed
com_microsoft_outlook_completedDate
</allattrs>
<displayattrs>kMDItemTitle
kMDItemPhoneNumbers
kMDItemEmailAddresses
kMDItemInstantMessageAddresses
kMDItemContentModificationDate
</displayattrs>
</type>
<type name="com.microsoft.outlook15.event">
<allattrs>com_microsoft_outlook_has_text_content
kMDItemTextContent
kMDItemTitle
com_microsoft_outlook_recordID
com_microsoft_outlook_folderID
com_microsoft_outlook_accountID
kMDItemCoverage
kMDItemDueDate
com_microsoft_outlook_hasStartDate
com_microsoft_outlook_hasDueDate
com_microsoft_outlook_startDate
com_microsoft_outlook_endDate
kMDItemWhereFroms
kMDItemComment
com_microsoft_outlook_timeZone
com_microsoft_outlook_recurrence
com_microsoft_outlook_recurring
com_microsoft_outlook_allDay
com_microsoft_outlook_has_reminder
com_microsoft_outlook_freeBusy
com_microsoft_outlook_free_busy_value
com_microsoft_outlook_parentRecordID
kMDItemContactKeywords
kMDItemKeywords
kMDItemProjects
com_microsoft_outlook_projects
com_microsoft_outlook_categories
com_microsoft_outlook_primaryCategory
com_microsoft_outlook_attendees
com_microsoft_outlook_attendee_emails
</allattrs>
<displayattrs>kMDItemTitle
kMDItemCoverage
kMDItemDueDate
kMDItemWhereFroms
</displayattrs>
</type>
<type name="com.microsoft.outlook15.message">
<allattrs>kMDItemTitle
com_microsoft_outlook_recordID
kMDItemContentCreationDate
com_microsoft_outlook_messageSent
com_microsoft_outlook_messageReceived
com_microsoft_outlook_priority
com_microsoft_outlook_flag
com_microsoft_outlook_unread
kMDItemContentModificationDate
kMDItemCoverage
kMDItemKeywords
kMDItemProjects
com_microsoft_outlook_has_text_content
kMDItemTextContent
kMDItemAuthors
kMDItemRecipients
com_microsoft_outlook_folderID
com_microsoft_outlook_junkLikelihood
com_microsoft_outlook_size
com_microsoft_outlook_newsAccountID
com_microsoft_outlook_accountID
com_microsoft_outlook_repliedTo
com_microsoft_outlook_forwarded
com_microsoft_outlook_redirected
com_microsoft_outlook_toRecipients
com_microsoft_outlook_toEmailAddresses
com_microsoft_outlook_ccRecipients
com_microsoft_outlook_ccEmailAddresses
com_microsoft_outlook_bccRecipients
com_microsoft_outlook_bccEmailAddresses
com_microsoft_outlook_attachments
com_microsoft_outlook_has_attachments
com_microsoft_outlook_has_mentioned_me
com_microsoft_outlook_projects
com_microsoft_outlook_categories
com_microsoft_outlook_primaryCategory
com_microsoft_outlook_flagged
com_microsoft_outlook_author_email_addresses
com_microsoft_outlook_recpient_email_addresses
com_microsoft_outlook_isFromMailingList
com_microsoft_outlook_hasStartDate
com_microsoft_outlook_startDate
com_microsoft_outlook_hasDueDate
kMDItemDueDate
com_microsoft_outlook_has_reminder
com_microsoft_outlook_completed
com_microsoft_outlook_completedDate
</allattrs>
<displayattrs>kMDItemContentCreationDate
kMDItemAuthors
kMDItemRecipients
kMDItemCoverage
kMDItemContentModificationDate
</displayattrs>
</type>
<type name="com.microsoft.outlook15.note">
<allattrs>kMDItemTitle
com_microsoft_outlook_recordID
kMDItemContentCreationDate
kMDItemContentModificationDate
com_microsoft_outlook_has_text_content
kMDItemTextContent
kMDItemKeywords
kMDItemProjects
com_microsoft_outlook_folderID
com_microsoft_outlook_accountID
com_microsoft_outlook_projects
com_microsoft_outlook_categories
com_microsoft_outlook_primaryCategory
</allattrs>
<displayattrs>kMDItemTitle
kMDItemContentCreationDate
kMDItemContentModificationDate
</displayattrs>
</type>
<type name="com.microsoft.outlook15.task">
<allattrs>com_microsoft_outlook_has_text_content
kMDItemTextContent
kMDItemTitle
com_microsoft_outlook_recordID
kMDItemContentModificationDate
kMDItemComment
com_microsoft_outlook_recurring
com_microsoft_outlook_recurrence
com_microsoft_outlook_recurrence_type
com_microsoft_outlook_priority
com_microsoft_outlook_folderID
com_microsoft_outlook_accountID
kMDItemProjects
com_microsoft_outlook_projects
com_microsoft_outlook_categories
com_microsoft_outlook_primaryCategory
com_microsoft_outlook_hasStartDate
com_microsoft_outlook_startDate
com_microsoft_outlook_hasDueDate
kMDItemDueDate
com_microsoft_outlook_has_reminder
com_microsoft_outlook_completed
com_microsoft_outlook_completedDate
</allattrs>
<displayattrs>kMDItemTitle
kMDItemDueDate
</displayattrs>
</type>
</types>
</schema>
@nommaz
Copy link

nommaz commented Oct 7, 2017

thanks for the list! any idea how to make a date based query such as (com_microsoft_outlook_startDate <= Today) ?

@kiran-machhewar
Copy link

@nommaz Did you get any solution for how to make such date based query.

@jm789
Copy link

jm789 commented May 9, 2018

@nommaz try something like (com_microsoft_outlook_startDate <= $time.today)

@bxm
Copy link

bxm commented Sep 19, 2018

With a little trial and error on values, I created this filter to display:

  • flagged items
  • unread items
  • important items (regardless of "read" state) that have not been flagged complete (so I can ultimately banish them by marking complete)

Might be useful to someone – or just future me :)

com_microsoft_outlook_flagged == 1 || com_microsoft_outlook_unread == 1 || (
  com_microsoft_outlook_priority > 0 && com_microsoft_outlook_flagged != 2
)

For pulling out Meetings use/append:

com_microsoft_outlook_has_reminder == 1

Like so, for meetings not flagged complete:

com_microsoft_outlook_flagged == 1 || com_microsoft_outlook_unread == 1 || (
  com_microsoft_outlook_flagged != 2 && (
    com_microsoft_outlook_has_reminder == 1 ||
    com_microsoft_outlook_priority > 0
  )
)

@cstrax
Copy link

cstrax commented Jan 22, 2019

This seems to have worked or maybe just the first part of the query. It only returned items sent/received today

(com_microsoft_outlook_messageSent >= $time.today) || (com_microsoft_outlook_messageReceived >= $time.today)

@retorquere
Copy link

Any idea how I would search for private appointments?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment