Created
April 13, 2017 01:28
-
-
Save EmilVarona/78ae2aff409922686ebff4cea785aed4 to your computer and use it in GitHub Desktop.
Outlook/Mac 2015 raw query item names
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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> |
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
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)