Outlook/Mac 2015 raw query item names

gistfile1.txt

<?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>

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
  )
)

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)

Any idea how I would search for private appointments?