Raw queries - searching for meeting invites

[ianfore]

Hi,

I'm trying to query for meeting invites i.e. those messages in the
inbox which are meeting invites but which haven't been accepted yet.
Once accepted a calendar event gets created - but what I want to
search for is the message not the event.

Entourage is clearly able to distinguish these messages internally -
it displays the invites as a different icon in the "message status"
column. However that information isn't searchable via "status". So I
entered the world of "raw queries" in the hope that would get closer
to the metal.

I followed the online help for raw queries.

Some of the following metadata items in the Entourage cache looked
like good candidates for identifying the meeting invite:

com_microsoft_entourage_message_kind
kMDItemKind
kMDItemContentType
kMDItemContentTypeTree

However, none of these seem to have the right info.

Does anyone know if the right piece of data is available and
searchable?

Looking at the source of the message there is a nested VCALENDAR
inside the message - so maybe the strongest candidate field would be
kMDItemContentTypeTree
which looks like

kMDItemContentTypeTree = (
"com.microsoft.entourage08.virtual.message",
"public.email-message",
"public.message",
"public.data",
"public.item"
)

but there's nothing there which specifically identifies this as a
meeting invite. The full metadata dump is listed below


Thanks
Ian

P.S. This is the metadata listing from the Entourage cache using mdls
for an example invite message.

com_microsoft_entourage_accountID = 11
com_microsoft_entourage_author_email_addresses = (
"(e-mail address removed)"
)
com_microsoft_entourage_categories = (
0,
0
)
com_microsoft_entourage_completed = 0
com_microsoft_entourage_flagged = 0
com_microsoft_entourage_folderID = 3460
com_microsoft_entourage_forwarded = 0
com_microsoft_entourage_has_text_content = 1
com_microsoft_entourage_hasDueDate = 0
com_microsoft_entourage_hasStartDate = 0
com_microsoft_entourage_isFromMailingList = 0
com_microsoft_entourage_junkLikelihood = -100
com_microsoft_entourage_message_kind = 1
com_microsoft_entourage_messageReceived = 2008-06-27 11:42:06
-0400
com_microsoft_entourage_messageSent = 2008-06-27 11:42:06
-0400
com_microsoft_entourage_priority = 2
com_microsoft_entourage_projects = (
0,
0
)
com_microsoft_entourage_recordID = 164097
com_microsoft_entourage_recpient_email_addresses = (
"(e-mail address removed)",
"(e-mail address removed)"
)
com_microsoft_entourage_redirected = 0
com_microsoft_entourage_repliedTo = 0
com_microsoft_entourage_size = 4
com_microsoft_entourage_toEmailAddresses = (
"(e-mail address removed)",
"(e-mail address removed)"
)
com_microsoft_entourage_toRecipients = (
"\"Jones, John\"",
"\"McCallan, James\""
)
com_microsoft_entourage_unread = 1
kMDItemAlternateNames = (
"164097.vRge08Message"
)
kMDItemAuthors = (
"John Smith"
)
kMDItemContentCreationDate = 2008-06-27 11:42:06
-0400
kMDItemContentModificationDate = 2008-07-02 17:16:14
-0400
kMDItemContentType =
"com.microsoft.entourage08.virtual.message"
kMDItemContentTypeTree = (
"com.microsoft.entourage08.virtual.message",
"public.email-message",
"public.message",
"public.data",
"public.item"
)
kMDItemCoverage = "Inbox"
kMDItemDisplayName = "Updated: Weekly
Meeting"
kMDItemFSContentChangeDate = 2008-07-02 17:16:14
-0400
kMDItemFSCreationDate = 2008-07-02 17:16:14
-0400
kMDItemFSCreatorCode = ""
kMDItemFSFinderFlags = 0
kMDItemFSHasCustomIcon = 0
kMDItemFSInvisible = 0
kMDItemFSIsExtensionHidden = 0
kMDItemFSIsStationery = 0
kMDItemFSLabel = 0
kMDItemFSName = "164097.vRge08Message"
kMDItemFSNodeCount = 0
kMDItemFSOwnerGroupID = 20
kMDItemFSOwnerUserID = 501
kMDItemFSSize = 3149
kMDItemFSTypeCode = ""
kMDItemKind = "vrge08_message"
kMDItemLastUsedDate = 2008-06-27 11:42:06
-0400
kMDItemRecipients = (
"\"Jones, John\"",
"\"McCallan, James\""
)
kMDItemTitle = "Updated: Weekly Meeting"
kMDItemUsedDates = (
2008-06-27 00:00:00 -0400
)